Remote connection to the MySQL server using ISPmanager5 and SSH

Remote connection to mysql server using ISPmanager5

The MySQL server can listen to certain addresses to receive incoming connections.

To change the settings, go to Settings → Database Servers

Highlight the connected server and click Change. To change the listening ip-address, enable remote access on the form and select the address from the list that appears:

Creating a database user

Due to the fact that the work with remote access will be brought up to date, the creation and editing of database users will undergo changes. If remote access is disabled on the server where the user is to be placed, in the user settings the item of the same name will be unavailable.

Remote connection to mysql server using Console

To connect to MySQL server using command line, in terminal emulator type the following command:

mysql -h domain.com -u example_user -p

• -h your domain name
• -u database user
• -p password request for database user

You can also connect directly to the desired database:

mysql -h domain.com -u example_user -p example_db

where example_db at the end of the command is the name of your database.