Welcome to Centmin Mod Community
Become a Member

MariaDB Anonymous users on default MariaDB installation ?

Discussion in 'MariaDB & General MySQL news & discussions' started by pamamolf, May 1, 2024.

  1. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:25 PM
    Nginx-1.29.x
    MariaDB 10.6.x
    Hi,


    I run mysqltunner on Almalinux default Centminmod installation and i can see the following:

    Code:
    [!!] User ''@'localhost' is an anonymous account. Remove with DROP USER ''@'localhost';
    [!!] User ''@'server.mydomain.com' is an anonymous account. Remove with DROP USER ''@'server.mydomain.com';
    Isn't that taking care from the default Centminmod installation?

    Code:
    curl -4sL https://centminmod.com/installer-el8x-mariadb10.4.sh -o installer-el8x-mariadb10.4.sh; bash installer-el8x-mariadb10.4.sh
    MariaDB 10.4


    Thanks in advance !
     
  2. eva2000

    eva2000 Administrator Staff Member

    58,904
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:25 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Thanks for the heads up. Centmin Mod will automatically remove anonymous users for MariaDB 10.3 and below but not for MariaDB 10.4+ as I understood it that MariaDB 10.4+ and above automatically don't include anonymous users out of the box anymore. But seems it is not the case. So will have to re-add the auto removal for MariaDB 10.4+ :)
     
  3. duderuud

    duderuud Active Member

    318
    97
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +215
    Local Time:
    4:25 PM
    1.29 x
    11.4
    Ha, one of the first things I do after setting up CMM is removing the anonymous users in MariaDB :)

    One less thing to worry about, thanks!