faqts : Communication : Telephone : Errors

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

28 of 33 people (85%) answered Yes
Recently 9 of 10 people (90%) answered Yes

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;