Hi Faith, Damn, did I post a stupid GRANT command !! Doesn't seem to be my day today ;-) Don't use the GRANT command from the previous e-mail, use the one below.
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxx' WITH GRANT OPTION; Sorry I must have been completely out of my mind for the previous posting. I hope you didn't have a chance yet to try the command from the previous e-mail. Best regards Nils Valentin Tokyo/Japan 2003年 7月 9日 水曜日 17:15、Nils Valentin さんは書きました: > 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 -- --- 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]
