Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Networking
User Name
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.


  Search this Thread
Old 10-18-2006, 07:50 AM   #1
Registered: Jun 2003
Location: SoCal
Distribution: CentOS
Posts: 465

Rep: Reputation: 30
Connecting to a Remote MySQL Server

I'm currently running MySQL on my home server. I'd like to connect to it from my Ubuntu Desktop using MySQL Administrator. On the server I've opened tcp & upd port 3306 (or whatever the port is, sorry i'm not in front of the server right now). I keep getting a permission error when I try to connect.

When I use the MySQL Administrator locally on the DB server, I can connect to it just fine. Is there a setting in MySQL that I have to configure to allow a remote host to connect?

Old 10-18-2006, 12:03 PM   #2
Registered: Nov 2003
Location: North of the Border
Distribution: Gentoo & Debian
Posts: 155

Rep: Reputation: 30
You have to connect to the MySQL server on the localhost and add a user with any host or '%' access. By default users only have access from the localhost.
Old 10-18-2006, 12:07 PM   #3
Registered: Jun 2003
Location: SoCal
Distribution: CentOS
Posts: 465

Original Poster
Rep: Reputation: 30
Cool I'll give that a shot. Thanks!


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
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
Connecting to a remote server Mossaiby Linux - Networking 5 07-30-2004 03:38 PM
connecting to remote MySQL server acos7 Linux - Software 2 01-30-2004 11:37 PM
Connecting Mysql Database on remote server akamol Programming 4 10-16-2003 11:46 AM
Connecting to remote server tracey Linux - Newbie 1 08-11-2003 07:41 AM > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 07:11 PM.

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