Hi, I just follow this tutorial to change mysql data directory to new location https://www.digitalocean.com/community/tutorials/how-to-change-a-mariadb-data-directory-to-a-new-location-on-centos-7
Now mysql is running in the new location, but my application still unable to connect to the mysql server with this error:
A PHP Error was encountered Severity: Warning Message: mysqli::real_connect(): (HY000/2002): Connection refused Filename: mysqli/mysqli_driver.php Line Number: 201
I tried to login via PHPMyAdmin got this error:
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) — The server is not responding (or the local server's socket is not correctly configured).
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!