For example, if it’s required to allow access to the database called database for user user with password password and remote IP address 203.0.113.2: GRANT ALL ON database.* TO '203.0.113. Grant access to remote IP address and login to MySQL. Note: For the access to client’s MySQL server on Windows, use PHPMyAdmin: Plesk > Tools & Settings > Database Servers – MySQL DB Admin. Start Plesk Services Monitor > select MySQLX or MariaDBX (where X is a version) > click Restart. Not sure if you set this up manually or with the Ubuntu LAMP application.
If it is required to bind to specific IP address, specify this particular IP instead of 0.0.0.0Īlso, make sure that skip-networking parameter is not defined. Navicat Monitor is a safe, simple and agentless remote server monitoring tool that is packed with powerful features to make your monitoring effective as. of navicat its showing error lost connection to mysql server at reading.
Note: 0.0.0.0 means every IP address on the server. You need to download Linux version of Navicat And per online manual Installation for Download Version Open or Save the gzip file. Location of this file is:Ĭhange bind-address parameter to: bind-address = 0.0.0.0 Log in to Plesk and make sure the option Allow remote connections from any host is enabled at Tools & Settings > Database Servers > Settings.Ĭonnect to a Plesk server via SSH/ RDP and open the MySQL configuration file in any text editor.
0 kommentar(er)
