[install] Allowed host value (ip+%) for SQL user

  • Installer said:
    Please, enter the host from which SQL users created by i-MSCP should be
    allowed to connect to your SQL server:


    Allowed values are:
    - Fully qualified hostname or localhost
    - IPv4 or IPv6 addresses
    - The percent character '%' for any host


    This dialog is mostly for remote MySQL server usage. If you are using a
    local server, default value should be fine.


    I tried to set: 192.168.0.% but the Installer didn't accept it, I had to change the value to exact IP (ex: 192.168.0.50) after that I had to change it in the MySQL by hand.


    It's bug or feature? :)


  • http://dev.mysql.com/doc/refman/5.5/en/grant.html

    Code
    1. You can specify wildcards in the host name. For example, user_name@'%.example.com' applies to user_name for any host in the example.com domain, and user_name@'192.168.1.%' applies to user_name for any host in the 192.168.1 class C subnet.


    Thanks you for using i-MSCP.


    Edit: Can you open a ticket?

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

    Edited once, last by Nuxwin ().

  • Of course, I have already openned a new ticket for it.
    Thank you!


    Re;


    Should be fixed in master. ;)

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