Change mysql data directory error, how to fix it?

April 6, 2018 551 views
MySQL CentOS

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).
1 Answer

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 chown and chmod you should reset the permissions and ownership for all files you copied over so that they match the defaults from your old server.

Have another answer? Share your knowledge.