User Tools

Site Tools


use_external_sql_server

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 (0.0.0.0) or a specfic IP address.

For instance:

[mysqld]
bind-address = 0.0.0.0

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;

where:

  • <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/i-mscp.net/wiki/htdocs/data/pages/use_external_sql_server.txt · Last modified: 2017/04/14 19:31 by nuxwin