Category: MySQL
-
WordPress/MySQL change URLs
•
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…
-
WordPress can’t connect to database after MySQL move to new datadir
•
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…
-
Moving mysql datadir in Redhat (don’t forget SELinux!)
•
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…
-
Connection errors from WordPress to Azure MySQL database
•
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…
-
MySQL Cheat Sheet
•
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…
-
Migrate WordPress.com site
•
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…