Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 03-11-2010, 02:54 PM   #1
LQ Newbie
Registered: Apr 2009
Posts: 11

Rep: Reputation: 0
Navicat and MySQL

Greetings all,

I just setup a new machine running Ubuntu Server 9.10, MySQL 5.1.37 and Apache2. I am attempting to connect to the MySQL database using Navicat but I'm getting an error (10061)"Cannot connect to some_host@whatever". I have done the following:

1. Ensured the user I was connecting as was properly added and given the necessary privileges from the subnet I am working from

2. Made sure port 3306 was open and listening for TCP/IP connections

3. Disabled UFW (ubuntu default firewall)

Still can't connect, but I can access the database from shell using putty.

Has anyone else encountered this problem?
Old 03-12-2010, 07:48 AM   #2
Registered: Jan 2008
Location: Brighton, UK
Distribution: Ubuntu 12.04 / CentOS 6.5
Posts: 394

Rep: Reputation: 61
Have you checked that MySQL is listening for remote connections? (check out the mysql.users table for this info). Is the MySQL server service running?
Old 03-14-2010, 02:59 PM   #3
LQ Newbie
Registered: Apr 2009
Posts: 11

Original Poster
Rep: Reputation: 0
Problem solved....issue was in the my.cnf config file only allowing connections from localhost.


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
Looking for a Navicat MySQL tool alternative and a color picker program Seregwethrin Linux - Software 10 05-13-2013 07:40 AM
Navicat MySQL GUI for Linux version 8.0.23 is released. samnav Linux - Software 0 01-31-2008 01:17 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:39 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration