Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to connect to MySQL database hosted on Plesk server from remote machine?
Answer
There are several ways to connect to MySQL database remotely:
Click on a section to expand
-
On Linux:
- Make sure that the package
mysql-clientis installed on the machine. - Access the database with the following command:
# mysql -u <user> -h <database_server_ip> <database_name> -p
- Make sure that the package
-
On Windows:
The MySQL Project recommends that Windows users use the client MySQL Workbench to access their database remotely.
There are a lot of graphical desktop or web-based MySQL clients to manage database servers. For example, phpMyAdmin.
More information about installation and establishing a connection with remote MySQL database server can be found here: https://docs.phpmyadmin.net/en/latest/
For example, in PHP the function mysqli_connect can be used. Check the following link for more details on this: http://php.net/manual/en/function.mysqli-connect.php
Additional information
How to enable remote access to MySQL service on Plesk server?
Comments
1 comment
Hi,
I am also facing the same issue while using machine learning codes, your answer also helped me to sort out the issue.
Please sign in to leave a comment.