> 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]

Reply via email to