I don´t think it´s a problem with firewall. The error figured out below seems it´s been a username or password problem.
<[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > 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]
