I am having centos 7 and recently i changed my data directory of mysql from /var/lib/mysql to /test/sql after the migration i am able to login from mysql server through terminal but not able to login through phpmyadmin says Cannot log in to the MySQL server without any error code. I tried flush privelage,creating news user with terminal and granting permission changing password of the account

1 Answer

After changing the data location of MySQL you also need to change thephpmyadmin settings accordingly to be able to login via phpmyadmin. You need to reconfigure it to use socket authentication and point to the new location of the mysql socket

If the new file system mounted under /data, edit the file/etc/phpMyAdmin/config.inc.php (CentOS/RHEL) or/etc/phpmyadmin/config.inc.php (Ubuntu).

The data_type is probably set currently to tcp and needs to be changed tosocket. Then set the new location of the socket:

$cfg['Servers'][$i]['socket'] = '/data/mysql/mysql.sock'; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')

Restart Apache to apply the changes.

Source:PhpMyAdmin and changed MySQL data directory.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy