It means that the username you are using hasn't been allowed to connect to
the server from the IP you are using on the NT box. Try this, connect to
mysql from the Solaris box, then do this:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from user\G
*************************** 1. row ***************************
Host: localhost
User: root
Password:
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
1 row in set (0.00 sec)
This what you should see after a default install, notice the Host field.
The way this User table is set up, the only user who can connect is root,
and only from the local machine. The real problem with this is that any
local user can connect with absolute power over the database by just typing
"mysql -u root". If yours looks this way this is why you can't connect from
the NT box and points to a large security issue. To fix root's problem give
him a password, like so:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set Password = password('your_own_password_here') where
User = 'root';
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
Now you still need to add a user that you can use from the NT box, you
"could" allow user root to connect from anywhere "host=%", but I don't
reccomend this! Instead read this section from the manual on adding users:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Adding_users
I also reccomend you read the section on the privilege system:
http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#What_Priv
ileges
Scott Helms
Director of Technology, ZCorum
----- Original Message -----
From: "Marcelo Muzilli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 05, 2002 2:27 PM
Subject: MySQL Client/Server problem
> Hi all,
> I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
> How can I do this? I need some services running in the Server (in my case,
SUN
> Solaris). What means the message:
>
> "Host <my_IP> is not allowed to connect to this MySQL server" ??????
>
>
> Thanks in advance,
>
> Marcelo Muzilli
> Support Analyst Datacom/Access
> Ericsson Serviços de Telecomunicaçoes Ltda.
> +55 11 6224-8935
> [EMAIL PROTECTED]
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
