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]
