MySQL Remote Connection

aquatux · 12-23-2006, 04:10 PM

I have openSuse 10.2 with MySQL running. I need it only on my local network working with SQLyog. I have phpMyAdmin working fine but I am using SQLyog for some study.
The problem is I don't know how to make a romote connection.

I have Remote Connection enabled in Yast but that's all I know.

Edit: Man I sure got this on the wrong forum. It should be on the Suse forum. Maybe a mod can move it.

trickykid · 12-23-2006, 06:11 PM

You need to setup a user and host to allow remote connections within the mysql database in order to allow a remote connection.

And you can either use the mysql command on the remote machine acting as a client and or install phpmysqladmin or the like. MySQL also has tools or utilities for remote connection and administration as well.

aquatux · 12-23-2006, 06:34 PM

Quote:

You need to setup a user and host to allow remote connections within the mysql database in order to allow a remote connection.

Could you expand a little on that. I'm pretty slow at this.
Thanks,

trickykid · 12-24-2006, 01:31 AM

Something like this for example:

mysql> use mysql

mysql> grant all privileges on <database>.<table> to <username>@<host-or-ip> identified by '<password>';

mysql> flush privileges;

So say you have user joe at IP 192.168.1.10 to connect remotely to the database blah, your grant statement would look like:

mysql> grant all privileges on blah.* to joe@192.168.1.10 identified by 'password';
mysql> flush privileges;

See the mysql manual on the privileges you want to give the user, the one above gives all privileges to the user.

winkydo · 12-26-2006, 05:55 PM

right, and any field but the username and password can be a *. with my laptop, i will normally make a very restrictive user and give myself access to all of my databases from any IP. this is so i can view the database, but i can only edit it from a secure link.

grant all privileges on *.* to winkydo@* identified by 'mypassword';

this way i can run mysql admin from my windows based laptop to connect to the database instance.

aquatux · 12-26-2006, 07:12 PM

I can create permissions and anything else in phpMyAdmin. Thats what I normally use for my work, but I have SQLyog for some query testing. It's a free version and I have used it with some hosted space. The host uses some kind of http tunneling. You need mysql5.theirserver.com to connect remote. This is what I'm looking for the way to connect to my local network database using SQLyog.