LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
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 03-11-2010, 02:54 PM   #1
unim21
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
arashi256
Member
 
Registered: Jan 2008
Location: Brighton, UK
Distribution: Ubuntu 18.04 / CentOS 7.6
Posts: 397

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


Reply



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

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

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