mysql connection
 

Hi all..
Tux.. I need your help. Here we have our RH Linux server 7.3 with default mysql server installed. We are trying to connect it from a Windows2K workstation. There is a user 'usr' with password 'amma123' for mysql and linux. We tried to connect from the win2k and got the message 'host 192.168.0.246 (the win client) is unable to connect'. The ipaddress of the Linux sever is 192.168.0.238 and the mysql port is not changed! what can be done for the same?
expecting a soon reply

It's a little more than a username and password. There's network access rules, user rules, auth rules, database and table control to the Nth degree. The mysql user doesn't need an account on the machine, just the proper priveleges granted to them by the database.

Spend a 1/2 hour or so reading the authentication/access parts of the documentation. You really need to make sure you understand this so that you don't leave a huge barn door open in your database access rules.