Uda Wiki Web

Error Messages (X)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

<host> is not allowed to connect to this MySQL server

If you get the following error when you try to connect from a different
host than the one on which the MySQL server is running, then there is no
row in the user table that matches that host:

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

You can fix this by using the command-line tool mysql (on the server
host!) to add a row to the user, db, or host table for the user/hostname
combination from which you are trying to connect and then execute
mysqladmin flush-privileges. If you are not running MySQL Version 3.22
and 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 replace the '%' in the user table entry with the actual hostname
that shows up in the log. Otherwise, you'll have a system that is
insecure.) Another reason for this error on Linux is that you are using
a binary MySQL version that is compiled with a different glibc version
than the one you are using. In this case you should either upgrade your
OS/glibc or download the source MySQL version and compile this yourself.
A source RPM is normally trivial to compile and install, so this isn't a
big problem.