maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Am 04.01.2018 um 17:56 schrieb Guillaume Lefranc:
> it might be because of socket authentication plugin:
>
> https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/
>
> In other words if you use "root" unix account you don't need password.

then he would have seen the "mysql" database in "show databases"

> Le jeu. 4 janv. 2018 à 09:20, Karthick Subramanian 
> <ksubramanian@xxxxxxxxxxxxxxx <mailto:ksubramanian@xxxxxxxxxxxxxxx>> a 
> écrit :
>
>     Thank you.
>
>     I noticed some anonymous user entries in mysql.user. I have executed
>     the mysql_secure_installation and removed those users as well.
>
>     On Thu, Jan 4, 2018 at 1:03 PM, Federico Razzoli
>     <federico_raz@xxxxxxxx <mailto:federico_raz@xxxxxxxx>> wrote:
>
>         Check table mysql.user: you probably have the account
>         '%'@localhost. It's a pattern, and rot@localhost matches.
>         When running SHOW DATABASES you see only the databases which you
>         have some permissions.
>
>         Federico
>
>
>
>         ------------------------------------------------------------------------
>         *Da:* Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx
>         <mailto:ksubramanian@xxxxxxxxxxxxxxx>>
>         *A:* Maria Discuss <maria-discuss@xxxxxxxxxxxxxxxxxxx
>         <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>>
>         *Inviato:* Giovedì 4 Gennaio 2018 6:01
>         *Oggetto:* [Maria-discuss] Is this normal behaviour?
>
>         All,
>
>         When I tried to connect in centos 7 mariadb 10.2.11 server using
>         root user, by mistake I gave wrong user name, but it connected
>         successfully. I am not sure why. When I check show databases, it
>         didnt list all DBs, but when I connect with root again, I can
>         see all valid Dbs.
>
>         Is this normal that even if I give wrong user, it authenticate
>         into DB server from root.
>
>         [root@ipaddr ~]# mysql -u rot
>         Welcome to the MariaDB monitor.  Commands end with ; or \g.
>         Your MariaDB connection id is 22
>         Server version: 10.2.11-MariaDB MariaDB Server
>
>         Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
>
>         Type 'help;' or '\h' for help. Type '\c' to clear the current
>         input statement.
>
>         MariaDB [(none)]> show databases;
>         +--------------------+
>         | Database           |
>         +--------------------+
>         | information_schema |
>         | test               |
>         +--------------------+
>         2 rows in set (0.00 sec)
>
>         MariaDB [(none)]> exit
>         Bye
>         [root@ipaddr~]# mysql -u root
>         Welcome to the MariaDB monitor.  Commands end with ; or \g.
>         Your MariaDB connection id is 24
>         Server version: 10.2.11-MariaDB MariaDB Server
>
>         Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
>
>         Type 'help;' or '\h' for help. Type '\c' to clear the current
>         input statement.
>
>         MariaDB [(none)]> show databases;
>         +--------------------+
>         | Database           |
>         +--------------------+
>         | mydb01     |
>         | information_schema |
>         | mydb02      |
>         | mysql              |
>         | performance_schema |
>         | test               |
>         +--------------------+
>         6 rows in set (0.00 sec)