Yes, indeed. You don't have a firewall. But the firewall from the Internet Service Provider's computer prohibits the access of the others users from the Internet to the port of your MySQL server. Or you are in a private network which must use IP port forwarding to be reached from the Internet. Talk with your ISP to give all others, from the Internet, access to your MySQL port. The poor Windows is not guilty for this. It has too much guilty for the other problems...
Good Luck, Iulian ----- Original Message ----- From: "Renato" <[EMAIL PROTECTED]> To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:11 PM Subject: RES: Remote access to MySQL > >> 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 > > > I have all grant statements: > GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'password'; > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; > GRANT ALL PRIVILEGES ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; > FLUSH PRIVILEGES; > > Still not working... > Do you know if Win98 have some trouble receiving telnet commands? > > Thanks again. > > Regards, > Renato Uchoa > [EMAIL PROTECTED] > > ----- 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]
