you're a genius! I had old_passwords=1 in my.cnf, changed it to 0,
restarted mysql, and then the users worked like a charm. thanks!
Little, Timothy wrote:
My theory would be that it's an OLD-PASSWORDS issue. It would seem that
you might have used the
old_passwords=1 in your original configur
nt: Monday, June 15, 2009 7:41 PM
To: mysql@lists.mysql.com
Subject: restoring mysql db doesn't restore user passwords
I'm running Fedora 11 i386 with Mysql 5.1.32. I dumped my mysql
databases with:
mysqldump -u root -pxxx --lock-all-tables --all-databases >
/root/mysql-back
I'm running Fedora 11 i386 with Mysql 5.1.32. I dumped my mysql
databases with:
mysqldump -u root -pxxx --lock-all-tables --all-databases >
/root/mysql-backup/all-db.sql
and then wiped the operating system and reinstalled. Then I ran
mysqladmin -u root password
to set my root pass
