Re: [cobalt-users] MYSQL is giving troubles... please help me

["auuooh!/I-Dazzle Internet Services" <fsurget@xxxxxxxxxx>]

Robbert,
what I did in this same situation is to "GRANT" all users from the machine
in question "ALL PRIVILEGES" (check the correct MySLQ syntax in the online
docs). If you are able to do this safely, then flush your hosts. This should
all be done from the command line within MySQL.
Frank

-------Original Message-------

From: cobalt-users@xxxxxxxxxxxxxxx
Date: Saturday, February 23, 2002 10:33:05 AM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: [cobalt-users] MYSQL is giving troubles... please help me

Since a few seconds I'm getting the error from one of our sites stating the
following:

Warning: Host 'XXX.XXX.XXX.XXX' is blocked because of many connection
errors. Unblock with 'mysqladmin flush-hosts' in
/home/sites/site14/web/gastenboek/guestbook_show.php on line 63

When I run 'mysqladmin flush-hosts' (without the quotes) from the prompt
(SSH)
I get the following error:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Where do I go wrong ?? How should I connect ?? What should I do to correct
this matter ??? how do I unblock.... ANY help is appriciated.....

Thanks in advance.

Robbert
__________________
Linux is like a wigwam, no windows, no gates and an apache inside .


_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users