Connect to MySQL and view tables to see what you need USE <DB_NAME>; SHOW TABLES; Grab site URLs SELECT * FROM wp_options WHERE option_name = ‘home’; SELECT * FROM wp_options WHERE option_name = ‘siteurl’; **NOTE** Multisite setups are different. Each site has their own set of wp_options, depending on your site, it may be set Read more about WordPress/MySQL change URLs[…]
Resolution: The problem is related to your moving the mysql.sock file to a new location. PHP needs to know where it is, changing the location will fix the problem and reload apache/httpd (if you are using php-fpm, restart the service) Easy fix: Edit your php.ini file and make sure you specify the new mysql.sock location. Read more about WordPress can’t connect to database after MySQL move to new datadir[…]
Issue: You have moved /var/lib/mysql data files to their new destinations, but mysql will not start up. Resolution(s): 1. Review and verify configurations (in this example, MySQL 8) – /etc/my.cnf.d/mysql-server.cnf datadir=/ & socket=/ set to the right folder? – /etc/my.cnf.d/client.cnf add the following lines under [client]: datadir=/path/to/your/files port=3306 2. Grant SELinux permissions to the new Read more about Moving mysql datadir in Redhat (don’t forget SELinux!)[…]
Issue: You are getting connection issues to your hosted Azure MySQL database server. You are putting the correct information in, but still WordPress is showing Error Connecting to Database. Error: After some investigation, you most likely are getting this error: mysqli_real_connect(): (HY000/9002): SSL connection is required. Please specify SSL options and retry Resolution: Believe it Read more about Connection errors from WordPress to Azure MySQL database[…]
I grew accustomed to using MySQL GUI tools, but found that they can be quite daunting to use, ESPECIALLY a big pain to use is the MySQL Workbench suite. If you MUST use a GUI interface, try SQLYog. Simple and to the point. If you are looking for MySQL command line, here are a few that may Read more about MySQL Cheat Sheet[…]
Issue: Client wanted to migrate their WordPress.com site and retain full functionality in a WordPress.org site. Long/Short: This is not possible to do, as the WordPress.com sites have built-in features exclusive to only WordPress’ own hosting platform. Note in the article that you can only use Tools/Export to an XML file (or, of course, pay Read more about Migrate WordPress.com site[…]