Re: Remote access to MySQL

[gerald_clark]

Shane Bryldt wrote:

Just a thought, what about encryption of passwords?  Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
No, it should not.

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]