![]() Solution: You can add more allowed IPs to the Firewall(a maximum of 5 IPs or IP ranges). Only the listed IPs will be allowed to connect to your application. If you have enabled Firewall Rules under the “Security” tab, it will restrict the remote connection. While ‘127.0.0.1’ and ‘localhost’ mean the user does not support remote connection.įirewall restricts IP connection on “Security” The option ‘ % ’ means all hosts can connect to MySQL user. Open phpMyAdmin in the Control Panel and check the MySQL User permission in phpMyAdmin.ġ) If you cannot log in to MySQL via phpMyAdmin and get the following error, the password of the database user might be wrong.Ģ) If a MySQL user can log in to MySQL via phpMyAdmin, please check if the user has remote connection permission in phpMyAdmin. Inputting the command “cd log/”, then “ls -a”, followed by “vi mysql_error.log” to open the log file.ĭB user does not have correct password or permission If the MySQL service is not working, please use the shell tool in the Control Panel to check MySQL logs. The service is working if the result is as the following screenshot shows. MySQL service is not runningġ) Please check the status on the “Overview” page of your application in the Control Panel.Ģ)Running the command “ps –ef” via shell interface to check the MySQL status. This article lists some reasons why you cannot connect to MySQL remotely and shows you how to solve the remote database connection issues.Ģ> DB user does not have correct password or permission.ģ> Firewall restricts IP connection on the “Security” page.Ĥ> Remote Connection issue between your local server to our MySQL.ĥ> The MySQL remote connection port is blocked by your server or ISP.Ħ> Wrong MySQL connection information defined in application. How to Download a Backup to My Local Machine Troubleshooting Database Connection Issuesīacking up and Restoring a Single Database via SSHīacking up and Restoring a Single Database via phpMyAdmin Synchronizing Database and User Data to the Control PanelĬonnecting to MySQL Server via Different programming Languages How Can I Set the Time Zone for My Application to Fit My Own Time ZoneĪdd or Remove Resources for My Application via AddonsĪdd or Remove Resources via Plan Upgrade or DowngradeĬhanging Database Access Permission for a User How Can I Reset Password for a Database User ![]() How Can I Change MySQL Configuration Parameters in the Client Panel How Can I Add or Remove Resources for My Applications How Can I Troubleshoot MySQL Connection Issues How Can I Change MySQL Configuration Parameters via SSH ![]() How Can I Limit Special IPs to Access MySQL Database I Want to Download a Backup of MySQL Databases to My Local ![]() I want to migrate a database to Cloud Clusters from current provider or local PC How can I create Database User with different Permissions How Can I Start with Your Hosting Service How to Add and Remove Your Payment Method Reset Password for Cloud Clusters Account ![]()
0 Comments
Leave a Reply. |