Connection problem for Sequel Pro database management application
You can access the database for the website from the cpanel >> phpmysql but incase If a client is getting the problem for connecting to the database using the database management application apart from the phpmyadmin like Sequel Pro for the Mac OS. It seems that the Local System IP address is not allowed into the Remote Database Access Hosts.
Quote:
>> Initially, Check weather the Local IP address is blocked into the firewall of the server.
If blocked then release it, If its not blocked then check for the remote mysql entry
|
Quote:
>> If you want to add the IP address into the remote mysql.
Access the cpanel >> Remote Database Access Hosts
You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site.
Add Access Host (% wildcard is allowed) >> Ip address (Submit).
|
Quote:
|
>> Now try to access the database with the help of the Sequel Pro
|
Thats it, Done !!!