Ticket #879 (Security Issue - SQL user hostname - Remove wildcard) updated

    [feedquote='Trac','http://trac.i-mscp.net/ticket/879#comment:10']

    jonci

    This really depend of your setup.

    If your MySQL server is on same server (i-MSCP server) you can set the IP to 127.0.0.1 because the MySQL listen only to the loopback interface and because normally, the SQL users connects to the server only locally (not from outside).

    Now, if you are using a remote MySQL server, yes, the IP must be set differently because SQL users connect to the MySQL server from i-MSCP server (from outside). In such a case, the IP should be set to the i-MSCP server IP.

    In your example above you make assumption of an internal LAN usage or VPN but some user only have public IPs.
    [/feedquote]