![\"cp-mysql-1\"](\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/cp-mysql-1-1-300x151.png\")
<\/p>\nThe following points undertake that your WordPress database table prefix is ready to \u201cwp_\u201d. If you’re working with one thing that is different table prefix, then change your code accordingly. As an example, if you’re using \u201cwpsqltable_\u201d instead of \u201cwp_\u201d, the code \u201cINSERT INTO `wp_users`\u201d gets change to \u201cINSERT INTO ` wpsqltable_users`\u201d.<\/p>\n
Step 1: Log in to your cPanel account using login details.<\/p>\n
<\/p>\n
Step 2: Locate the Databases section from the main cPanel interface, and then click on the icon entitled phpMyAdmin.<\/p>\n
![\"cp-mysql-2\"](\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/cp-mysql-2-300x179.png\")
<\/p>\n
Step 3: Once the first screen appears, see at the left hand sidebar and click on the database for your explicit WordPress installation.<\/p>\n
![\"cp-mysql-3\"](\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/cp-mysql-3-300x168.jpg\")
<\/p>\n
Step 4: When the database information get’s loaded, you can find the tab named as the SQL and click on it.<\/p>\n
![\"cp-mysql-4\"](\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/cp-mysql-4-300x101.png\")
<\/p>\n
Step 5: Following is that the code to feature a new admin account within the SQL editor named newadmin with the password pass_abc. you’ll be able to change any of the content in red to fit your needs, however leave all other data as it is.<\/p>\n
Step 6: When substitution any data fields as per your need, click the Go button to execute the code.<\/p>\n Step 7: when the above step the screen is refresh and you’ll be able to see the message \u20181 row affected\u2018 after each of the three SQL statements. This suggests the query has run with success. From here, visit your WordPress admin login panel as common and utilize the new admin login information. you’ll be directed to admin interface with none hassle.<\/p>\n","protected":false},"excerpt":{"rendered":" The following points undertake that your WordPress database table prefix is ready to \u201cwp_\u201d. If you’re working with one thing that is different table prefix, then change your code accordingly. As an example, if you’re using \u201cwpsqltable_\u201d instead of \u201cwp_\u201d, the code \u201cINSERT INTO `wp_users`\u201d gets change to \u201cINSERT INTO ` wpsqltable_users`\u201d. Step 1: Log […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1734","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\nINSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)<\/code><\/p>\nVALUES ('newadmin', MD5('password'), 'name', 'email@abc.com', '0');<\/code><\/p>\nINSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
\nVALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:\"administrator\";s:1:\"1\";}');<\/code><\/p>\nINSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
\nVALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');<\/code><\/p>\n![\"cp-mysql-5\"](\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/cp-mysql-5-300x250.png\")
<\/p>\n