Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
Description
It appears we create anonmyous users as part of the default install. This causes issues with logging in via newly created named users.
MariaDB [test]> grant all on *.* to test@'%' identified by 'test123';
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> flush privileges;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [test]> exit
|
Bye
|
|
|
[root@c898c1318174 /]# /usr/local/mariadb/columnstore/mysql/bin/mysql -u test -p
|
Enter password:
|
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES)
|
[root@c898c1318174 /]#
|
|
|
[root@c898c1318174 /]# mcsmysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 7
|
Server version: 10.1.18-MariaDB Columnstore 1.0.4-1
|
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [(none)]> drop user ''@'localhost';
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [(none)]> exit
|
Bye
|
[root@c898c1318174 /]# /usr/local/mariadb/columnstore/mysql/bin/mysql -u test -p
|
Enter password:
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.1.18-MariaDB Columnstore 1.0.4-1
|
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [(none)]>
|