Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to use navicat to connect to mysql. How do I set that up on my server? It's centos

share|improve this question
1  
Is this your own server or VPS, or a shared host? If it is your's then don't open mySQL directly to the public Internet, instead use SSH tunneling or a VPN. If it is a shared host then there is nothing you can do other than consider server-side solutions like phpMyAdmin. –  David Spillett Oct 18 '11 at 14:06
    
possible duplicate of Allow Remote Connections to MySql Database –  quanta Oct 18 '11 at 14:06
    
dedicated server –  whatshakin Oct 18 '11 at 14:12

3 Answers 3

It depends on what your config file (/etc/my.cnf or /etc/mysql/my.cnf) has in it.

If there is the line "skip-networking" then remove it, since that means MySQLD is not even listening for TCP connections.

The bind-address=... option can also be disabling external connections if it is set to an internal address (127.0.0.1 or localhost for instance). If you want to allow connections from anywhere, comment out (or remove) the bind-address=... line completely (as well as the skip-networking line).

Oh yeah, and don't forget to restart the MySQLD service after you save the file.

share|improve this answer

As documented, under [mysqld] in your my.cnf file:

bind-address=an.ip.add.ress

lets you specify one IP to bind to, or none (comment it out); there are no other options, i.e. you cannot specify two IPs.

share|improve this answer

in the /etc/mysql/my.cnf file edit the line that starts with bind

share|improve this answer
    
the mysql folder is in /usr/bin/mysql and the folder is green and says it's not a directory –  whatshakin Oct 18 '11 at 14:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.