Skip navigation links

MySQL Forums :: Newbie :: locked out of MYSQL (password type)


Advanced Search

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) Alex Hank 06/17/2005 10:19AM
Re: locked out of MYSQL (password type) Jay Pipes 06/17/2005 10:33AM
Re: locked out of MYSQL (password type) Alex Hank 06/17/2005 10:43AM
Re: locked out of MYSQL (password type) Jay Pipes 06/17/2005 11:35AM
Re: locked out of MYSQL (password type) Alex Hank 06/17/2005 11:50AM
Re: locked out of MYSQL (password type) Jay Pipes 06/17/2005 01:11PM


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.