Access denied for user: '@192.168.0.71' (Using password: NO)

[infinite_root]

I tried to connect to my mysql server from a win client and the following error appeared:

c:\mysql -h 192.168.0.2 -u sqluser -p

Where:
192.168.0.2 MY MYSQL SERVER
192.168.0.71 MY CLIENT PC

/var/log/mysql.err

61 Quit
62 Connect sqluser@localhost on mysqldb
62 Query SELECT quota FROM users WHERE id ='sqluserl' AND mbox_host='domain.com'
62 Query SELECT CONCAT(home, "/Maildir/") FROM users WHERE id='sqluser' AND mbox_host='domain.com'
62 Quit
040427 15:43:52 63 Connect Access denied for user: '@192.168.0.71' (Using password: NO)
040427 15:43:55 64 Connect Access denied for user: '@192.168.0.71' (Using password: NO)
040427 15:44:00 65 Connect Access denied for user: '@192.168.0.71' (Using password: NO)
040427 15:44:07 66 Connect Access denied for user: '@192.168.0.71' (Using password: NO)
040427 15:44:14 67 Connect Access denied for user: '@192.168.0.71' (Using password: NO)

I have provided the following privileges:

GRANT ALL PRIVILIGES ON mysqldb.* TO 'sqluser'@'localhost' IDENTIFIED BY 'passwd'

Also I tried something like this:
GRANT ALL PRIVILIGES ON mysqldb.* TO 'sqluser'@'localhost' IDENTIFIED BY 'passwd WITH GRANT OPTION; GRANT ALL PRIVILEGES ON mysqldb.* TO sqluser@192.168.0.17 IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;

How can I fix the problem?

Hope you can help me Iam stuck for many weeks now.

Thanks and more power.

[ruturajv]

Code: Select all

GRANT ALL TO 'sqluser'@'192.168.0.71' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;