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? -- <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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
