|
Access denied for user: '@192.168.0.71' (Using password: NO)
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 vmail
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.
|