Web Hosting Talk







View Full Version : Cpanel - MySQL users


AlaskanWolf
04-01-2004, 03:55 AM
we are backing up a server to do a restore, however, i want to make sure that the Mysql users are saved as well

anyone know where these users are actually kept? or are they kept in the /var/lib/mysql/user_db folder?

Steven
04-01-2004, 04:02 AM
/var/lib/mysql/mysql

AlaskanWolf
04-01-2004, 04:05 AM
thanks

AlaskanWolf
04-01-2004, 08:09 AM
moved those over, but that didnt work, none of the users are registering after restore .....

Manu
04-01-2004, 08:23 AM
They would need to be setup as on the previous server (or backup) in the associated directory in /var/lib/mysql/*dbname*

chown -R mysql.mysql /var/lib/mysql/*dbname*