Change WordPress Database Table Prefix Back To wp_
Here is how to change the WordPress database tables back to the default wp_ prefix. First thing is to change the php constant table prefix in wp-config.php Change the wp-config.php constant $table_prefix = ‘wp_’; Change the table prefixes in phpMyAdmin Next open your WordPress database in phpMyadmin, select all the tables and choose the option…
Read MoreInstall Apache, MySQL, PHP on macOS 11 Big Sur and earlier macOS
Get your Local Web Development Environment Up & Running on macOS Big Sur 11 and Catalina 10.15 With Apples’ new macOS Big Sur 11 available for download, here is how to get the AMP stack up and running on the new macOS. This tutorial will go through the process of getting Apache, MySQL, PHP (or…
Read MoreChange and Update WordPress URLS in Database When Site is Moved to new Host
After migrating a WordPress site to a new URL either to a live production site or a testing development server, the new URL strings in the MySQL database need to be changed and updated in the various MySQL database tables. This method just uses the whole MySQL database rather than a WordPress export/import from within and…
Read MoreAdd phpMyAdmin to ServerPilot
By default when you set up a ServerPilot instance no GUI app is installed for MySQL interaction, ServerPilot recommend using Adminer which has a similar interface to phpMyAdmin and sits as a standalone single php file which you can use for individual database users. This guide however goes through using phpMyAdmin instead and using it…
Read More