MYSQL remote access help needed

agvar · - Joined: 08 May 2004 Posts: 5 Location: tennessee

Ok i need to know how to allow access to mysql from another computer on my local network

thanks in advance

Agvar

iNaNimAtE · Posted: Sat May 15, 2004 8:06 pm Post subject:

MySQL is just a database running in the background. If Abyss Web Server is available to anyone, then so is MySQL. You need to use/create a script in the language of your choice (most people here prefer PHP) and it can utilize the databse.

http://www.phpbb.com is a popular forum script that utilizes MySQL.
Also, get http://phpmyadmin.net to manage your databases.
_________________
Bienvenidos!

agvar · - Joined: 08 May 2004 Posts: 5 Location: tennessee

i want to be able to connect to mysql via telnet from another machine on my local network to do this you need to set incomeing login premissions in mysql it has nothing to do with php or the webserver it's self

iNaNimAtE · Posted: Sat May 15, 2004 8:20 pm Post subject:

I don't quite know how that would do you any good, but if you want to be able to execute commands on MySQL remotely, download the SSH client and server, (the secure version of telnet).

http://download.com.com/3000-2094-10247344.html?tag=lst-0-3
_________________
Bienvenidos!

agvar · - Joined: 08 May 2004 Posts: 5 Location: tennessee

you have to set log in premissions in mysql when mysql is installed the default is to allow only connections from the local machine and since the webserver is on the local machine it naturaly has access rights

what i need to know is how to grant access rights to a remote machine at ip xxx.xxx.xxx.xxx

iNaNimAtE · Posted: Sat May 15, 2004 8:59 pm Post subject:

How is your databse being accessed?
_________________
Bienvenidos!

Anonymoose · - Joined: 09 Sep 2003 Posts: 2192

Managing MySQL with SSH on Windows.

http://dev.mysql.com/doc/mysql/en/Windows_and_SSH.html

The solution at the bottom of that page takes into account the localhost aspect. When you run an SSH server it will also be running on localhost - connecting remotely to the SSH server, the SSH server will connect locally to the MySQL and forward the results back to you. Basically, you'll have a standard command prompt accessing MySQL securely and remotely. You don't want to open your database up to direct access from other machines.

Check http://dev.mysql.com/doc/mysql/en/Security_guidelines.html

If you insist on doing it without SSH, http://dev.mysql.com/doc/mysql/en/Connection_access.html

agvar · - Joined: 08 May 2004 Posts: 5 Location: tennessee

Ah yes thats just the information i was looking for thanks a bunch i looked all over that site for the info and couldent find it useing there search

once again thanks a bunch

this topic can be closed now :)

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI