User Tools

Site Tools


How to use use remote SQL server with i-MSCP

1. On remote SQL server, edit the /etc/mysql/my.cnf file and change the bind-address parameter in the mysqld section to make your server listening either on all interfaces ( or a specfic IP address.

For instance:

bind-address =

Once done, restart the MySQL server.

2. Always on the remote SQL server, create a specific SQL user with full privileges that can connect from the i-MSCP server only:

# mysql -u root -p<password>
> GRANT ALL PRIVILEGES ON *.* TO '<username>'@'<imscp_server_ip>' IDENTIFIED BY '<password>' WITH GRANT OPTION;
> quit;


  • <username> must be replaced by the username of your choice
  • <imscp_server_ip> must be replaced by the i-MSCP server IP address
  • <password> must be replaced by the password of your choice

Once done you must run the imscp-autoinstall script on the i-MSCP server and when you're asked for Mysql server, you must select the remote server option.

/var/www/virtual/ · Last modified: 2017/04/14 18:31 by nuxwin