6

Is it possible to have the actual MySQL database installed on Windows and access it from Ubuntu 10.10 on the local network?

I think I need a MySQL "client" ? So I looked here (MySQL Linux0Generic), but I don't know what to download..

Ps. I tried looking for documentation on the MySQL site but I can't see a single link for any type of documentation...

5

Of course you can, you just need a few things set up correctly first:

  • Install the MySQL Query Browser and Administrator These are both graphical tools that you can use to manage your mysql databases, no matter where they are.

  • On Windows you need to make sure the machine is available over the network via a name or fixed address so your Ubuntu machine can see it correctly.

  • Make sure you add permissions to access the database from non-localhost. In MySQL the default permissions are localhost only and you need to turn on the '.*' permissions for either root (if your managing it totally) or a user with the permissions you need.

  • Use the MySQL Admin you installed to test the connection by attempting to log into the machine's fixed ip or name with the username and password you've set up in the permissions.

You can also use openoffice.org's database to connect to mysql databases. And it really doesn't matter that MySQL is running on Windows or Ubuntu, the concerns are the same.

  • You can also use openoffice base.Also you need to open MySQL port on the win box in the firewall settings. – karthick87 Dec 31 '10 at 20:19
1

Also in my.cnf

bind-address = server_ip_here

and comment:

 # skip-networking

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.