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).
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
Based on what you’ve described, I am guessing that you did not set the permissions and ownership of the files you copied over. Using
chownandchmodyou should reset the permissions and ownership for all files you copied over so that they match the defaults from your old server.