LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 12-23-2006, 04:10 PM   #1
aquatux
Member
 
Registered: Jul 2005
Distribution: Ubuntu 11.04
Posts: 50

Rep: Reputation: 15
MySQL Remote Connection


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.

Last edited by aquatux; 12-23-2006 at 04:37 PM.
 
Old 12-23-2006, 06:11 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
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.
 
Old 12-23-2006, 06:34 PM   #3
aquatux
Member
 
Registered: Jul 2005
Distribution: Ubuntu 11.04
Posts: 50

Original Poster
Rep: Reputation: 15
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,
 
Old 12-24-2006, 01:31 AM   #4
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
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.
 
Old 12-26-2006, 05:55 PM   #5
winkydo
Member
 
Registered: Jan 2005
Location: fort worth, tx
Distribution: fedora core
Posts: 30

Rep: Reputation: 15
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.

Last edited by winkydo; 12-26-2006 at 11:15 PM.
 
Old 12-26-2006, 07:12 PM   #6
aquatux
Member
 
Registered: Jul 2005
Distribution: Ubuntu 11.04
Posts: 50

Original Poster
Rep: Reputation: 15
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql remote connection issue Jukas Linux - Software 7 11-05-2011 10:25 PM
mysql remote connection error? nayyares Linux - General 2 12-21-2006 12:08 AM
Mysql Remote Connection Problems harbringer Linux - Software 5 04-14-2005 02:42 PM
Remote Mysql Connection in PHP ElementNine Programming 2 05-03-2004 04:24 PM
Remote Connection to mysql server Graanco Linux - General 1 07-18-2003 11:27 PM


All times are GMT -5. The time now is 09:54 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration