2 messages in com.mysql.lists.win32Re: Error 1130| From | Sent On | Attachments |
|---|---|---|
| Josh Carrico | 27 Oct 2003 08:09 | |
| Christian Mack | 28 Oct 2003 07:01 |
| Subject: | Re: Error 1130 |
|---|---|
| From: | Christian Mack (mack...@gmx.de) |
| Date: | 10/28/2003 07:01:28 AM |
| List: | com.mysql.lists.win32 |
Josh Carrico wrote:
I seem to have locked everyone out of the mySQl database. I did an update on the users table to set all passwords. Now when I try to login, it states:
ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server.
HELP.
_____
Josh Carrico ICQ# 25327271
"Great spirits have often encountered violent opposition from weak minds." -Albert Einstein
Hi Josh
You can do one of the following. 1) Get your old priviledges back: stop the mysqld server restore your old "mysql" database directory from a backup start the server again
2) create new priviledges from scratch stop the mysqld server remove the content of your "mysql" database directory reinstall mysql (this will give you the "root" account without password back) start the server set the new priviledges as needed
3) repair the actual priviledges
stop the mysql server
start it with option "--skip-grant-tables"
Note: This option will allow everyone to connect to your server with all
priviledges!!!!!
So I would disconnect it from network for security.
repair the priviledges
restart the mysqld server without the above option
To stop the server in the first place, you have to use your corresponding OS
task / process killing tool.
In Linux/xxBSD/MacOS X this is the command "kill" or "killall".
In Windows 98/Me/NT/2000/XP this tool is called "Taskmanager".
Hope this helps
Bye Christian