> -----Message d'origine----- > De : Amer Neely [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 01, 2004 3:07 PM > À : Larry Brown > Cc : MySQL List > Objet : Re: Remote access FROM a secure server > > > Larry Brown wrote: > > 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.
It is the standard telnet port. You must not put the colon in a telnet command. here is the right command: telnet host.domain.com 3306 hth Ugo > -- > <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]
