Want more timely Centmin Mod News Updates?
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 Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:36 PM
    Nginx-1.25.x
    MariaDB 10.3.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

    53,142
    12,108
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,643
    Local Time:
    12:36 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 Premium Member Premium Member

    220
    78
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +166
    Local Time:
    4:36 PM
    1.25 x
    10.6
    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!