Remote access to a MySQL database?

Question

I have installed MySQL Server 5.0 in both my PC and laptop.
The PC is the server and has a database (a table with 14 rows and 4 columns) that I need to access remotely using my laptop.

How can this be done?
What changes in settings(both on server side and client side) do I need to do?

and finally how do i access the database?

Answer 1

mySQL listens on TCP port 3306, so this must be open on your firewall.



How you then access the database depends on the client that you use. For instance, in phpMyAdmin (which can be run under XAMPPLite on the client) you specify the server address (ip address or DNS name, or on a local network the computer name), username and password for access and you are away.



What you do NOT do is access a server using a server as you suggest. MySQL is a database SERVER and it needs to be accessed by a database CLIENT.



To connect a tool like Access you should download and install the MySQL Connect ODBC driver. Then in the Control Panel under Administration and then Data Sources set up an ODBC data source that specifies the same details as above.

Answer 2

I'd go for installing a webserver and phpmyadmin. In fact you may be better installing a complete ampp package like XAMPP- it'll give you a fresh copy of mysql, webserver, php and phpmyadmin - then you can get access to the database through web pages on your pc and laptop with the same interface

Answer 3

Get a mysql client, there is one on mysql site download and install it,



You need to create a new user, and grant him remote access the right way of doing it, is to define the ip address of the computer that going to access it, for convenience you can set it to any.



if its on a unix/linux machine login in through ssh and do



mysql -u root -p



to log into it then create and grant the user you need, or manage it directly





More computer tips at

http://www.review-ninja.com

Answer 4

install WampServer2 you will be able to access both Pc and laptop sql's