Harpreet wrote:
>
> I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
> server and connect to it from my machine using Telnet.
> But everytime i try to connect using mysql client or through access 2000 i
> get the following error:
>
> Host 'ip address' is not allowed to connect to this MySQL server
> please help and let me know what am i missing.
>From the online manual...
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.
>
> An early response will be appreciated.
>
> Regards,
> Harpreet Kaur
> Software Developer
> Crispin Corporations Inc.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
