External (Remote) MySQL server

    The correct SQL query to execute on the remote server to give permissions is:


    Code
    1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'IMSCP-SERVER-IP' WITH GRANT OPTION;


    Thank you for your help

    Edited once, last by Nuxwin ().

    Re;


    You want say:


    Code
    1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'i-MSCP-SERVER-IP' IDENTIFIED BY 'password' WITH GRANT OPTION;


    On your server, I've used:


    Code
    1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'i-MSCP-SERVER-IP' WITH GRANT OPTION;


    because the user 'root'@'i-MSCP-SERVER-IP' was already created by you.



    Thanks you for using i-MSCP.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    Edited once, last by Nuxwin ().