>>Does it mean the port 3306 is blocked? Not necessarily - it could mean that MySQL didn't respond as your telnet client expected (which is not surprising!).
The "Access denied for [EMAIL PROTECTED]" message comes from the server, so there will be something wrong with your mysql.user or mysql.db tables that results in another entry being used before this one. Do a 'select user, host, password from user' and go through each entry in the order that they come out and see if another entry can match your login - the manual has a good section on how the MySQL server does this. As another tip, I've found that $ mysqladmin flush-privileges is more reliable than mysql> FLUSH PRIVILEGES; I know that they should both result in the same thing, but my experience is not so. HTH Quentin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 4:30 a.m. To: Praj Cc: mysql@lists.mysql.com Subject: Re: how can I access to mysql fro m"outside"? I can connect using Putty to the server using port 22. When I try to connect to the server using port 3306 and got "Connection timed out"? Does it mean the port 3306 is blocked? -afan > U can chk firewall by doing a telnet to the remote host on 3306 ( > default ) port . > > Error message looks like username/password might be wrong . > > [EMAIL PROTECTED] wrote: > >>hi, >>I'm trying to access to mysql on dedicated web server (hosted by hosting >>company) using MySQL Administrator. Right now I'm getting error message >>2003 (Can't connect to the server...). >>On users table I can see in user column 'root' and 'admin' as users and >>both have for host 'localhost' (root has tough localhost.localdomains >> too) >> >>After some googling I think I have to create a user (e.g. 'admin2') and >>grant: >>mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%' >> -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; >> >>(123.123.123.% means I'll access from IPs that start with 123.123.123 >> right?) >>mysql> FLUSH PRIVILEGES; >> >>Is this all? Do I have to do something else? I do have to restart mysql >>server, right? >> >>Back to top: right now, when I try to access, I'm getting error message >>2003. Since I didn't get error "Access denied for >> [EMAIL PROTECTED]", >>I think, even I have correct user/pass, someting else will stop me >>(firewall, 3306 is blocked,...), right? >>How can I check this? >> >>Thanks for any help. >> >>-afan >> >> >> > > > -- > 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] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
