LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-07-2006, 02:28 PM   #1
Mulsiphix
LQ Newbie
 
Registered: Dec 2005
Posts: 28

Rep: Reputation: 16
MySQL + Debian + MySQLCC + Remote Connections, How?


I am renting a dedicated server and have just finished installing MySQL on Debian (Sarge). I would like to connect to manage my databases from my computer using MYSQL Control Center. I am receiving the error below. What do I need to do to enable remote connections to my databases and does this pose a significant security threat?

Quote:
ERROR 2003: Can't connect to MySQL server on 'my servers ip' (10061)
 
Old 01-07-2006, 02:36 PM   #2
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
Is your mysql server running on your dedicated server? Check your my.cnf to see if "skip-networking" is uncommented. Comment that line and restart your mysql instance and see if that lets you in. Check 'ps aux' to make sure it's running after the restart.

As for 'is it secure', one would hope If you haven't secured your box, you may want to secure it before opening more ports to the world. For more info on securing this type of setup, post/search in the Linux - Security forum, we really have some security guru's living over there.

Cool
 
Old 01-07-2006, 03:29 PM   #3
Mulsiphix
LQ Newbie
 
Registered: Dec 2005
Posts: 28

Original Poster
Rep: Reputation: 16
Yup my mysql server is running on my dedicated server. Thank you very much for the quick reply. I checked my.cnf and this is what I found. If I comment bind-address then I receive a new error saying host is not allowed to connect to this server. Definitely is progress but I am not sure how to gain access. I would try to bind it to my IP but it is not static. Please advise.

Quote:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
 
Old 01-07-2006, 04:46 PM   #4
MasterC
LQ Guru
 
Registered: Mar 2002
Location: Salt Lake City, UT - USA
Distribution: Gentoo ; LFS ; Kubuntu
Posts: 12,612

Rep: Reputation: 68
Does your dedicted server have a private IP for that machine? Assuming you don't need things like Port-Forwarding and all traffic is sent to a specific IP, then you could bind to that private IP for that machine (not the loopback one).

IIRC you can bind to a hostname instead of an IP...

Does that provide any luck?

Cool
 
  


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
X and remote connections? jonsson Linux - Newbie 6 11-15-2004 12:25 AM
restricting remote connections dominant Linux - General 0 03-03-2004 11:56 AM
Remote connections dARkHunTEr Linux - Networking 7 08-03-2003 10:22 AM
MySQL Control Center (mysqlcc) CBT Linux - Software 1 01-20-2003 11:11 AM
Remote connections cipher_arg Linux - Newbie 3 12-10-2002 06:07 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

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

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration