MySQL Forums
Forum List  »  Security

Re: root password change does not work
Posted by: Arjen Lentz
Date: February 23, 2005 06:29PM

Hariharan Gopalan wrote:
> I am facing a funny situation. All of a sudden my root password to the mysql server version 3.23.49
> stopped working. I reset the password and tried logging in again, but what ever I do, I am unable
> to login as root. If I skip grant tables, I am able to, but not otherwise.
>
> wonder what could be wrong.

Well, I presume that somehow you messed around directly in the mysql system tables, which is always a bad idea. It doesn't jsut magically happen.

As for a solution:
I suggest you shut down the server, and run the mysql_install_db script again to intitialize the grant tables. Then run the mysql_secure_installatoin script to secure.

Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

Options: ReplyQuote


Subject
Views
Written By
Posted
4702
February 15, 2005 01:07PM
Re: root password change does not work
3615
February 23, 2005 06:29PM


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.