SEO

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

I don´t think it´s a problem with firewall.

The error figured out below seems it´s been a username or password problem.

<afan@afan.net> escreveu na mensagem
news:45135.216.248.119.34.1158681091.squirrel@www. afan.net...
> 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
>

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 .

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
>
>
>

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 .
>
> 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
>>
>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=afan@afan.net
>
>

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
==================

Okie there might be a entry in mysql.user table having username and
password column as blank .

That might result in Access denied when u use password .

Try this ,

use mysql ; select * from user where user='';

if so , Delete those entries .

afan@afan.net wrote:

>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 .
>>
>>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
>>>
>>>
>>>
>>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe: http://lists.mysql.com/mysql?unsub=afan@afan.net
>>
>>
>>
>
>