enable mysql access from remote machine

I have a mysql 5.0 server (new installation) on my Ubuntu 8.10. What should I do to connect to the server from a windows machine on the same LAN? I tried change bind-address and the mysql-server failed to start with this changed configuration. Mysql server start only if the bind-address is IP of the ubuntu machine.
LVL 12
Sinoj SebastianCTO & OpenERP Project managerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ivo StoykovConnect With a Mentor Commented:
you could try something like the sample below.
this will all anything to the user johndoe connecting from the given address at stated network,
HTH
Ivo Stoykov

mysql> GRANT ALL PRIVILEGES ON db.* TO johndoe@'192.58.197.0/255.255.255.0';

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.