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 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.

[sde]

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:

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

your syntax to login from the windows client looks correct:

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

that should do it.

[infinite_root]

Originally posted by sde
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:

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

your syntax to login from the windows client looks correct:

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

that should do it.

Thank you for you speedy reply. However, I intend to use mysql over the internet also. So, i probably use my external ip for that matter.

Hope youll reconsider my request.

Thanks and more power.

[sde]

ok .. well then why don't you give us a good example of your network.

as i see it, .. you have a server, and a windows client both behind a firewall?

even if this is so, then my first bit of code would allow any requests comming into the server to be accepted , so long as you hav the correct user and pass.

what you must consider is that if you are going in from outside your network, you will need to setup port forwarding on your router.

mysql runs on port 3306 i think .. so you will need to forward incoming requests from port 3306, to your internal ip of the server .. i think it is 192.168.0.2

now my second bit of code will work from anywhere, .. but yes, if you are outside your network, you will need to use your external ip.

[bdl]

Hmm, this thread looks very familiar...

[sde]

huh?
q

[infinite_root]

Originally posted by sde
[b]ok .. well then why don't you give us a good example of your network.

as i see it, .. you have a server, and a windows client both behind a firewall?

Yes, you're right my problem came from the firewall.

Thanks and more power.

[redhead]

Originally posted by bdl
Hmm, this thread looks very familiar...

Yes indeed: http://www.linuxjunior.org/yabbse/in...;threadid=9104

[sde]

heh thanks redhead .. our very own code enwbie sherlock

[infinite_root]

Originally posted by sde
heh thanks redhead .. our very own code enwbie sherlock

I am sorry Hope I didn't offended anyone for that matter.

Just looking for a forum that can address my problem more promptly.

Thanks and more power to you all.

[sde]

hey not at all .. that's what this site's here for.

[bdl]

Ha! Thanks for the link redhead, I saw the same one on another site altogether...