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