I don’t know if this is a bug or I am not setting something properly, but if I connect to localhost on my windows box

Mysql –u root –p –h localhost (or optionally mysql –u –root –p)

A password is required to connect and when inputted, I have access to the databases/tables. This is correct and I am happy with this.

However if I try to connect to the mysql database via the Ethernet IP address (in this case 192.168.0.2 ) from either this machine or another,

There is no password on –u root.

IE

C:\mysql\bin>mysql -u root -p -h 192.168.0.2 Enter password: ************ ERROR 1045: Access denied for user: 'root@shane' (Using password: YES)

And this will also occur if I try connecting to the MYSQL database from another machine within the lan.

[shane@co3029006-a shane]$ mysql -u root -h 192.168.0.2 -p Enter password: ERROR 1045: Access denied for user: 'root@CO3029006-A' (Using password: YES)

However, If I try to connect without sending a password, I can connect and use / manipulate / delete tables.

From either the host machine or remotely

FROM REMOTE MACHINE:

[shane@co3029006-a shane]$ mysql -u root -h 192.168.0.2 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.39-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use peoples Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed mysql>

FROM LOCAL MACHINE:

C:\mysql\bin>mysql -u root -h 192.168.0.2 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 50 to server version: 3.23.39-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use peoples Database changed mysql>

However, If I stipulate a non-existant user, I get a error in opening the table (which is fine).

Thought you may like to know and if it is just my setup.

Machine : Duron 800 256Meg Ram, Win2K SP2 , MYSQL-3.23.39-nt