Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 06, 2009, 06:03:51 AM

Life is to be fortified by many friendships. To love and to be loved is the greatest happiness of existence.

- Sydney Smith

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > 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 367 times)

OnlineBob

Senior Member

Joined: Dec 2006
Posts: 136

That's important, now isn't it ?

$View OnlineBob\s Profile$

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 ?

Clean PC Zone

~Dave~

Administrator

Joined: Jan 2006
Posts: 6186

Building a Foundation

$View ~Dave~\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 : Social Media Optimization for Social Media Marketing

Best Affiliate Programs Ξ Recommend Us Ξ Blogger Forum

Pages: [1]