Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your problem is most likely similar to the problem I had. I don't
know about it working on the intranet for you but by default the windows
version does not have TCP connections enabled, only named pipes (localhost
connections). It took me a few minutes to realize this the last time I had
it installed on windows. Check your configuration, as I recall it was
something commented out, perhaps the port number if I recall correctly.
-Shane
----- Original Message -----
From: "Renato" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12: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]
