External (Remote) MySQL server

Hello,

I will install imscp first time, I was reading the wiki but I didn't find if I could use a remote DB server with a MySQL. That is possible or will be a problem ?

Thank you

Quote from Nuxwin

Hello

Remote mysql option is available in last master.

Thanks for using i-MSCP.

What do you mean with last master ?

- Last stable release 1.0.3.0
- Last github versión
- Last RC candidate 1.1.0-rc1.4

Thank you.

Hello

I did what you told me but on the lasts steps I got this errors on the DB

Servers::ftpd::proftpd::installer::setupDB: Unable to add privileges on the 'vm0_imscp.ftp_group' table for the 'vftp' SQL user: Error while executing query: GRANT command denied to user 'root'@'xxx.xxx.xxx.xxx' for table 'ftp_group'

how could I solve this ?

Thank you

Quote from gOOvER

Seems your root User have not all privileges on your MySQL Server

Hello !

I made sure was all right with the root user. Now install the panel with the Local DB

Thank you for your help !
Martin

Quote from Nuxwin

Hello ;

You should have an root with all permissions, including GRANT such as

root@<ip_of_imscp_server>

Thanks you for using i-MSCP

Display More

Hello Nuxwin,

yes, the command was :

grant all privileges on *.* to 'root'@'IP-I-MSCP' identified by 'RootPassword';

I will try again with MySQL remote on the next server, and I will tell you about.

Thank you.
Martin