[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 946
  • Last Modified:

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.
0
Sinoj Sebastian
Asked:
Sinoj Sebastian
2 Solutions
 
Ivo StoykovCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now