Entry

When I connect to MySQL server from the client, it says permission denied to 'root' user?

Jan 5th, 2005 20:28
Melanie Chisolm, Loganathan N, http://dev.mysql.com/doc/mysql/en/Access_denied.html

If the following error occurs when you try to connect from a host other
than the one on which the MySQL server is running, it means that there
is no row in the user table with a Host value that matches the client host:

Host ... is not allowed to connect to this MySQL server

You can fix this by setting up an account for the combination of client
hostname and username that you are using when trying to connect. If you
don't know the IP number or hostname of the machine from which you are
connecting, you should put an entry with '%' as the Host column value in
the user table and restart mysqld with the --log option on the server
machine. After trying to connect from the client machine, the
information in the MySQL log will indicate how you really did connect.
(Then change the '%' in the user table entry to the actual hostname that
shows up in the log. Otherwise, you'll have a system that is insecure
because it allows connections from any host for the given username.) 

On Linux, another reason that this error might occur is that you are
using a binary MySQL version that is compiled with a different version
of the glibc library than the one you are using. In this case, you
should either upgrade your operating system or glibc, or download a
source distribution of MySQL version and compile it yourself. A source
RPM is normally trivial to compile and install, so this isn't a big problem.