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 .
[EMAIL PROTECTED] 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 .
[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]
