Have Geek Brain

Mysql access without a web server (like Apache)

I was wondering if there is a way to access the database service on a remote computer without having a web server installed on that computer?

Does the MYSQL DBMS provide some interface (port) that can be directly connected to, or is it a web server (which forwards the message)?

+1


a source to share


3 answers


MySQL may be available by default on port 3306. Typically this port will be blocked by a firewall, although it’s not a good idea to have your database server accessible to the outside world.

If you want to access the remote database via the command line, you can use the mysql client .



If you're doing this over the Internet, you should probably use a tunnel or VPN for security.

+5


a source


You can connect to MySQL using ODBC. The default port is 3306



0


a source


As they said. You can connect to mysql using (default 3306). You can use mysql client or ODBC, JDBC or ADO.Net interfaces. There are connectors for most major programming languages.

If you are looking for a handy tool for using mysql like PHPmyAdmin you might like the MYSQL GUI tools http://dev.mysql.com/downloads/gui-tools/5.0.html

0


a source






More articles:


All Articles