MySQL Forums
Forum List  »  Newbie

locked out of MYSQL (password type)
Posted by: Alex Hank
Date: June 17, 2005 10:19AM

my database was working great when I logged in as root.

I wanted to create anonther account with less privledges (only select, insert, update). I was able to create new accounts with My SQL Administrator, and My PHP admin. However, when I would log out of the root account, and try to log in with the new acccout, I would would get the error that the account would not work with the old password type.

So I went back into My SQL admin to the security tab and checked the box to only allow old passwords. Now I can not even get into the root account.

I get the following error when I try to login with mysql admin

Could not connect to host 'localhost'.
MySQL Error Nr. 1275
Server is running in --secure-auth mode, but 'root'@'localhost' has a password in the old format; please change the password to the new format

How do I change to new format when I can't even login?


I get the following error when I try to login with terminal window

[root@localhost root]# mysql -u root -p
Enter password:
ERROR 1275 (HY000): Server is running in --secure-auth mode, but 'root'@'localhost' has a password in the old format; please change the password to the new format

WHAT DO I DO NOW???????????????


thanks

Alex

Options: ReplyQuote


Subject
Written By
Posted
locked out of MYSQL (password type)
June 17, 2005 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.