I move the database from /var/lib/mysql to a new location /homee2/mysql. I can start the database and I can see databases from WHM, chage passwords for databases, login as root.
However new problem occured.
1. I can't see the list of databases for specific domain (user).
2. when I try to add new database it is added as Cpanel::Mysql=HASH(0xa489468) instead of the name of the database
3. I can't access phpMyAdmin from WHM and I get the error:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
This is also log from Cpanel:
DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /usr/local/cpanel/Cpanel/Mysql.pm line 29
Fri Aug 31 06:11:54 2007 info [Cpanel::Mysql]: Creating MySQL database Cpanel::Mysql=HASH(0xa222680) for user kinggame
Fri Aug 31 06:11:54 2007 info [Cpanel::Mysql]: Not updating privileges for kinggame (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 254
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa222680)') called at /usr/local/cpanel/Cpanel/Mysql.pm line 129
Cpanel::Mysql::create_db('Cpanel::Mysql=HASH(0xa222680)', 'kinggame_tptestdb') called at /usr/local/cpanel/bin/mysqladmin line 242
Can anyone help me to solve it?
However new problem occured.
1. I can't see the list of databases for specific domain (user).
2. when I try to add new database it is added as Cpanel::Mysql=HASH(0xa489468) instead of the name of the database
3. I can't access phpMyAdmin from WHM and I get the error:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
This is also log from Cpanel:
DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /usr/local/cpanel/Cpanel/Mysql.pm line 29
Fri Aug 31 06:11:54 2007 info [Cpanel::Mysql]: Creating MySQL database Cpanel::Mysql=HASH(0xa222680) for user kinggame
Fri Aug 31 06:11:54 2007 info [Cpanel::Mysql]: Not updating privileges for kinggame (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 254
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa222680)') called at /usr/local/cpanel/Cpanel/Mysql.pm line 129
Cpanel::Mysql::create_db('Cpanel::Mysql=HASH(0xa222680)', 'kinggame_tptestdb') called at /usr/local/cpanel/bin/mysqladmin line 242
Can anyone help me to solve it?
Last edited: