After restore from backup -1 mysql users

E

eSupport.org.ua

Verified User
Joined
Oct 4, 2004
Messages
62
Location
UA
Hi
I transfer backups from another server and restore.
But users don't have mysql db.
Db was success on server - i can see it.

How to transfer access users to ours db?
 
You were using DirectAdmin's backup/restore functions? From the reseller or user level?

You can either recreate the users for that database with another password or if you have da_admin or root access to MySQL make another backup through phpMyAdmin and restore on the new server of the relevant entries in the mysql database.
 
I use resseler level backup.
I don't like add set manual permissions and password, it will be made by da backup recovery.

Also i try made dump from old server and restore to new - any success.
 
Hello,

What versions of mysql do you have on each box?

If you've got 4.0.x on the old one, and 4.1.x on the new one, then you'd need to either re-save the passwords in the 4.1 password format, or else, you'd need to add this to your /etc/my.cnf (which may not exist):
Code: 
[mysqld]
old_passwords
So that your old passwords work on the new version of mysql (remember to restart mysqld).

Note, the current working passwords might break as a result of using the "old_passwords" command, so it might be safest to just resave the password for each user.

MySQL 4.1.x differs from 4.0.x in that they change the password format. They aren't backwards compatible.

John
 
Hi

I do it, but not help.

May be my.cnf will be not /etc, becouse it is freebsd system.
Where is will be my.cnf for freebsd?
 
MySQL looks for the my.cnf file in multiple locations. /etc is one of them.
Did you restart MySQL after writing the my.cnf file?
 
You must log in or register to reply here.
Back
Top