Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a secure facility so I haven't messed with SSL for mysql, so for instance it may use a different port number etc.
Just my 2 cents worth...
Larry
-----Original Message----- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 2:07 PM To: MySQL Subject: Remote access FROM a secure server
I have a Perl script running on a secure server (https) and am trying to access the mysql server on a different (unsecure) server. My ISP administrator has done the following:
GRANT ALL ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Then he restarted the server. But I'm still not getting access. Is the 'FLUSH PRIVILEGES' still necessary, or is the restart sufficient? I can access the db from a local phpMyAdmin and am using the same parameters in my script, so I know it is accessible. We're both stumped.
Anyone shed some light on this please?
Good thought. I just tried that and still got booted away. Connecting To xxx.xxx.xxx:3306...Could not open a connection to host on port 23 : Connect failed
Curious where the 'port 23' came from.
--
<sig>All outgoing email scanned by AVG Antivirus
Amer Neely, Softouch Information Services | Home of Spam Catcher & Research Central.
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | PHP | MySQL | CGI programming for all data entry forms.
"We make web sites work!"</sig>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
