Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

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

Installation and configuration iussues

Moderators: macek, egami, gesf

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

Postby infinite_root » Tue Apr 27, 2004 6:35 pm

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.
User avatar
infinite_root
New php-forum User
New php-forum User
 
Posts: 2
Joined: Tue Apr 27, 2004 6:30 pm

try this

Postby ruturajv » Tue Apr 27, 2004 10:11 pm

Code: Select all
GRANT ALL TO 'sqluser'@'192.168.0.71' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India


Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron