Hi Renato, I think you should check once more the right sfor the user you have. Log in to mysql and do:
mysql> SHOW GRANS FOR root ; You will get something like this: GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '17cb702624900fa5' Check what it says for the combinaion of "username" AND "hostname". In case you want to be able to access mysql from anywhere then you will need an ' % ' entry for the host. That would make your statement something like: GRANT ALL ON database TO 'root'@'%' IDENTIFIED BY 'password'; Best regards Nils Valentin Tokyo/Japan 2003年 6月 16日 月曜日 08:28、Renato さんは書きました: > I have installed MySQL in Win98SE, with connection ASDL and Fixed IP. > > In the same machine, works web server (Apache2+PHP) and e-mail e ftp > server. > > Everything works perfectly accessing from my INTRANET (local network). I > obtain access to MySQL without problems. > > In Internet, all servers works perfect, except MySQL. Always I get error of > > access when use: > > mysql - h xx.xx.xx.xx - u root - p > > ERROR 2003: Can't connect you the MySQL server on 'xx.xx.xx.xx' (10060) > > Informations: > > * I don't have any firewall > * I have all privileges to all the databases and tables, with user 'root'. > * I have pleny access to the 'server' machine. > * Telnet 'xx.xx.xx.xx:3306 ' also doesn't answer on Internet - In local > network, the reply is positive, what confirms server is on > * I work with PHP and I have access to Mysql with PHP programming, never > directly. > * I use 'mysqld.exe', as MySQL server, without any special configuration in > my.ini: > [WinMySQLAdmin] > Server=C:/MYSQL/bin/mysqld.exe > [mysqld] > basedir=C:/MYSQL > datadir=C:/MYSQL/data > > Summarizing: I can't access to the Mysql from Internet! > > Some additional suggestions? > > Regards, > Renato Uchoa > [EMAIL PROTECTED] -- --- 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]
