Code Forums - View Single Post - Access denied for user: '@192.168.0.71' (Using password: NO)

sde · 04-27-2004, 07:54 PM

well, .. if you're not worried too much about security, .. then you can open it up by logging in as the mysql root on the server and typing this:

Code:

GRANT ALL PRIVILEGES ON *.* TO sqluser@'%' IDENTIFIED BY 'passwd'

your syntax to login from the windows client looks correct:

Code:

cd c:\mysql\bin
mysql -usqluser -h192.168.0.2 -p
password: passwd

that should do it.

04-27-2004, 07:54 PM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,541	well, .. if you're not worried too much about security, .. then you can open it up by logging in as the mysql root on the server and typing this: Code: GRANT ALL PRIVILEGES ON . TO sqluser@'%' IDENTIFIED BY 'passwd' your syntax to login from the windows client looks correct: Code: cd c:\mysql\bin mysql -usqluser -h192.168.0.2 -p password: passwd that should do it. __________________ Mike