Resolved MariaDb 10.1 and new user ?

[OverWolf]

Hi,
after upgrade to 10.1 I have seen that there is a new user. is it normal ?

 

[OverWolf]

New screen that leave me

 

[OverWolf]

Hi,
I've found this link : The "test" Database and Security that explain the "test" database (I know that it's oracle -mysql-) but I think that is probably the truth for MariaDB too. So, is this the function for the user "Any" too ?

 

[Bitpalast]

is it normal ?

No. The entry means that anyone from anywhere can connect to the database and use it. Check the detailed permissions, but in general, this is not correct. My suggestion is to make a backup of the table, then remove then entry and check that things are still all working.

 

[OverWolf]

Hi Peter,
I think that after a new installation anyone need to follow this procedure

mysql_secure_installation

that delete anonymous user and test DB.

 

[Bitpalast]

An interesting link. However, at least here on CentOS this was never necessary. It was always a quite perfect installation from start.