Discover Centmin Mod today
Register Now

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,056
    427
    83
    May 31, 2014
    Ratings:
    +828
    Local Time:
    7:46 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

    51,987
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    2:46 AM
    Nginx 1.25.x
    MariaDB 10.x
    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

    202
    74
    28
    Dec 5, 2020
    The Netherlands
    Ratings:
    +153
    Local Time:
    6:46 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!