Check how many root rows do you have on the user table (select * from user where user='root';), some times there are several rows with different grants and probably you are going through and invalid rule.
Carlos On 5/14/2009 5:39 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal <carlos.pr...@gmail.com> wrote:Hi Carlos Try this mysql> update user set password=password('letmein') where user='root'; This way the password is saved encrypted, thats the way is compared when you try to log in.Thanks for the reply! I followed both methods in the following URL / link: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix After doing both successfully, I was unable to login over and over. I think something is wrong with MySQL. I have never seen this before :(
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
