![]() ![]() ![]() Run the following MYSQL commands to rename the prefix of the rows mentioned in step 4 of the above guide.In our example, the WordPress MySQL database is called wpdb: Select the WordPress database using the below command.Login to MySQL using the below command and once prompted specify the root password:.Change Records from wp_usermeta Table using MySQL Commands Once the above database records from the wp_usermeta table have been renamed, you should be able to login to the WordPress dashboard. In this example we used a default WordPress installation database. If you installed third party plugins or themes that add entries to this table you might need to change their prefix as well.Ensure that the CaPiTaLiZatIoN of the prefix matches that of the prefix for all database tables.Kyp51_dashboard_quick_press_last_post_id.If you have multiple WordPress users, you might need to change the below list of entries for each and every WordPress user.Įxample: if the current WordPress database table prefix is Kyp51, the entries should be renamed to: Once the list of user options is loaded, change the prefix of the following entries in the meta_key column for the administrator username to match the prefix you have configured in your WordPress wp-config.php file.Kyp51, the table name will be Kyp51_usermeta. The default WordPress table prefix is wp therefore if you just changed the prefix to e.g. ![]() Click on the table wp_usermeta to access its content. Once the WordPress database is selected a list of all the tables in the database is populated as seen in the below screenshot.If you have multiple databases and not sure which is the WordPress database, you can find the name of the database from the WordPress wp-config.php file, e.g. Once logged in to PHPMyAdmin, select the WordPress MySQL database.Login to your hosting provider CPanel and launch phpMyAdmin which can be found in the Databases section as seen in the below screenshot.Change Records from wp_usermeta Table using phpMyAdmin In this WordPress tutorial we will explain which entries should be changed and how to change them using the phpMyAdmin or MySQL commands. To fix this problem and regain access to the WordPress dashboard you have to manually change some entries from the table wp_usermeta in the WordPress MySQL database. The WordPress error You do not have sufficient permissions to access this page is typically encountered when trying to access the WordPress dashboard or admin pages after you have changed the WordPress database table prefix, or moved WordPress from one hosting provider to another, or just upgraded your WordPress. Solution for You do not have sufficient permissions to access this page WordPress Error ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |