Internet Marketing Forum

For Webmasters and Entrepreneurs

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 21, 2012, 02:58:06 PM

Mountaintops inspire leaders but valleys mature them.

- Winston Churchill

Home

Privacy

Internet Marketing Forum > Online Business Discussions > Website Design and Maintenance > Database

Connect to MySQL from remote host using Navicat

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: Connect to MySQL from remote host using Navicat (Read 2021 times)

OnlineBob

Senior Member

Joined: Dec 2006
Posts: 164

That's important, now isn't it ?

$View OnlineBob\s Profile$
Gender: Male

Netherlands

Jan 05, 2008, 05:44:49 PM

I'm banging my head against the wall. My client has a new dedicated server running MySQL on the linux platform. I am trying to connect to the database with a remote connection using Navicat mysql software. I logged into the mysql server in ssh as root user and added another user with the host '%' (which should mean connect from anywhere) but I keep getting an error "Unable to connect to database".

Is there something I need to set in the database ?

Code4Gold

Administrator

Joined: Jan 2006
Posts: 6215

Administrator

$View Code4Gold\s Profile$

United States

Jan 07, 2008, 03:57:00 AM

Did you make sure you opened the port in iptables firewall ?? Here's the command...

iptables -A INPUT -p tcp --destination-port 3306 -j ACCEPT

Also, you should make sure you have the following lines in your /etc/my.cnf

port=3306
socket=/var/lib/mysql/mysql.sock

Latest Blog Post : 8 Tips for Creating a Marketing Buzz

Best Affiliate Programs Ξ SocialNews Ξ Blogger Forum Ξ Wealth Watching

Summer Savings! $7.49 .com domains at GoDaddy.com!

Pages: [1]