Host 'localhost' is not allowed to connect to this MySQL

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Host 'localhost' is not allowed to connect to this MySQL

Postby geraldgrogan » 05. May 2007 19:11

I acidentally revoked all users privilages (instead of granting all access - having a very bad day :cry: ) and now I am getting the following error message at the command line:

mysqladmin -u root flush-privileges password "newpass"
'Host 'localhost' is not allowed to connect to this MySQL server'

**Any ideas how I can gain access to this database on a Windows XP machine?
Posts: 2
Joined: 05. May 2007 18:57

mysql - forgotton password

Postby mammut » 24. June 2007 13:46

you have to stop mysql
then start it with the option "--skip-grant-tables"
With this option you achieve that the tables for the rights are not read at start of mysql.
start mysql
then you can delete the crypted password for root.
stop it again and start mysql without this option.
Now you can give root a new password.
I hope this will help you. I did not test it.
Posts: 6
Joined: 24. June 2007 13:20
Location: Oberkochen

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests