mysql database users not stored in Backups

[SupermanInNY]

Hi All,

I have an old server running with WhiteBox 3 and is intended to be retired.

It is running mysql 5.0.45 and apache 1.3.41 with PHP4.4.7.
It is running with DA 1.31.4


I have a new server that I've just setup, fresh install of everything:

CentOS 5.0 i386
It is running mysql 5.0.45a and apache 1.3.41 with PHP4.4.8
It is running with DA 1.32.1

When I'm creating the Reseller's backup it creates a backup with the database, but when I try to restore it, it doesn't create the Database Users.

I've tried to load the backup and restore it onto a diff server (running with mysql 4.1).
I get the same result of No Database users created.

Any pointers?

-Alon.

 

[DirectAdmin Support]

I've replied to your email, see if the binaries I've sent you help at all. Let me know if they don't. I may need to take a look to figure it out.

John

 

[SupermanInNY]

RESOLVED

Thanks to John of DA the issue has bee identified and resolved.

The problem was with the MySQL database.

John checked the mysql err log and found:

080622 21:11:21 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run


The fix for this kind of problem is simple:

mysql_fix_privileges_table --user=da_admin --password=daadminpass

(The value for the daadminpass is located at: /usr/local/directadmin/conf/mysql.conf


Thanks John and Hopefully this will help someone else down the road.

-Alon.

 

[ThomasK]

also stuck

Hhmmm, same problem here. I urgently needed to move server. MySQL users and databases are not restored from the backup

Unable to restore database user1_mail.sql to user1_mail : ERROR 1045 (28000): Access denied for user 'user1'@'localhost' (using password: NO)

Unable to restore database user1_menu.sql to user1_menu : ERROR 1045 (28000): Access denied for user 'user1'@'localhost' (using password: NO)

I'm still looking into the problem....

 

[xeryph]

RESOLVED

Thanks to John of DA the issue has bee identified and resolved.

The problem was with the MySQL database.

John checked the mysql err log and found:

080622 21:11:21 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run


The fix for this kind of problem is simple:

mysql_fix_privileges_table --user=da_admin --password=daadminpass

(The value for the daadminpass is located at: /usr/local/directadmin/conf/mysql.conf


Thanks John and Hopefully this will help someone else down the road.

-Alon.

Where to write this?

 

[floyd]

Its obviously a command you have to run. If its not that obvious to you then you should probably get someone to help you with server administration.