> I have all privileges to all the databases and tables, with user 'root'.
User 'root' likely doesn't have access from the desired IP. Users are configured by both name and approved hosts. Try this: GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Renato" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, 15 June, 2003 19:28 Subject: Remote access to MySQL 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
