How can I manage Mysql with Navicat

gonyalibabo

How can I connect I get fail like
"Lost connection to MySQL server at 'reading initial communication packet', system error: 0"

I checked my My.cnf there is no Bind-address

hostnodes

If you are trying to connect from the remote, you need to update bind-address to 0.0.0.0
and secure port 3306 using a firewall.

gonyalibabo

How can I edit bind in my my.cnf file there is no bind or something like that

hostnodes

gonyalibabo You can add it if it does not exist in your my.cnf

aaPanel_Jose

gonyalibabo

Set database access permissions on the database management page
Release port 3306 on the security page
Release port 3306 in the server security group

maverick

You have to go on mysql cli or phpmyadmin and duplicate the root user, instead of localhost you can use '%' for any source or just put your source IP address.
Database Servers should not be easy to access from any location, they must be properly configured with granular and known access.

gonyalibabo

OKAY DONE

aaP_cristydavidd

It usually indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently. It might be because the MySQL server is bound to the loop-back IP (127.0.0.1 / localhost) which effectively cuts you off from connecting from “outside”. If this is the case, you need to upload the script to the webserver (which is probably also running the MySQL server) and keep your server host as ‘localhost’ Another common cause of connect timeouts is the reverse-DNS lookup that is necessary when authenticating clients. It is recommended to run MySQL with the config variable in my.cnf:

Open mysql configuration file named my.cnf and try to find “bind-address”, here replace the setting (127.0.0.1 OR localhost) with your live server ip (the ip you are using in mysql_connect function).
Restart service by command : service httpd restart
GRANT ALL PRIVILEGES ON yourDB.* TO 'username'@'YOUR_APPLICATION_IP' IDENTIFIED BY 'YPUR_PASSWORD' WITH GRANT OPTION;