Entry

What does the error "Found old style password for user" mean?

How can I fix things if I didn't use the PASSWORD() function when inserting passwords?

Feb 25th, 2000 16:49
Nathan Wallace, Michael Widenius

The above means that you have inserted rows into the mysql.user without
using that PASSWORD() function on the passwords.
Fix; 
Restart mysqld with --skip-grant and go to the mysql.user table and
update all rows which has the wrong password:
shell> mysql mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32 to server version: 3.23.9a-alpha-debug
Type 'help' for help.
mysql> select user,password from user where password<>"" and
length(password)<>16;