Hi Faith,
You will have to check your user account privileges. Make sure that the Host
you are connecting from is entitled to connect to the server.
Login to the mysql server with the command line tool "mysql" and do this:
mysql> show grants for user;
+---------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+---------------------------------------------------------------------------------------------+
| GRANT SELECT, SHOW DATABASES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD
'xxx' |
+---------------------------------------------------------------------------------------------+
1 row in set (0.08 sec)
Then set the privileges f.e. with
GRANT SELECT, SHOW DATABASES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxx'
This will allow root to connect from any host.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 15:57、fatih olcer さんは書きました:
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> i got an error when i try to connect mysql server with
> mysqlcc :
>
> error 1130 : "Host xxx.xxx.xxx.xxx not allowed to connect this server" .
>
> does anyone know any solution ?
>
> thanX.
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
