[SOLVED] mysqladmin connection error

[wsetchell]

I'm trying to connect to a database I made on a linux box using mysqladmin from XP.

When I try to login as root I get this error.

MySQL Error Number 1045
Access Denied for user 'root' at 'myip' (using password: NO)

There is no root password setup. (at least i think there isn't based on this)

$ mysql -u root
Welcome to the MySQL monitor. ...
mysql>

I've already ran a GRANT ALL ... command if that makes any difference here

Any help would be appreciated

[secondmouse]

Not sure how your grant command looks like, but if you want to enable access for user root from <xp_ip>, you would have to execute the following mysql commands on the server after logging in with user root:

grant all on *.* to 'root'@'<xp_ip>' identified by '<password>';
flush privileges;

Substitute <xp_ip> and <password> with your xp's ip and the password you want.

[bills]

Hi Wsetchell, You might have forgot to give access to IP in that SQL string. try above SQL query if that doesnt work then make sure that port 3306 is open in your firewall.

Good Luck.

[secondmouse]

make sure that port 3306 is open in your firewall

I don't think firewall is the problem here since the reply message

MySQL Error Number 1045
Access Denied for user 'root' at 'myip' (using password: NO)

is from mysql server, meaning if you are not connected to the mysql server, you would not have seen that error at all.

[wsetchell]

grant all on *.* to 'root'@'<xp_ip>' identified by '<password>';
flush privileges;
Substitute <xp_ip> and <password> with your xp's ip and the password you want.

This fixed my problems. Thanks everyone