afan@afan.net 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 admin2@123.123.123.123",
> 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
>

Your error message indicates MySQL Administrator cannot connect to the
port. Your telnet attempt confirms this.

Check your my.cnf file. Ensure that skip-networking is off (the default
is to disable networking) and the port is set to 3306,

Then try to telnet or ssh into the server command prompt. From there try

telnet localhost 3306

If you can't connect here, networking is disabled. If you can connect
here, but still not from the remote, you have a firewall blocking the port.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================