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)]>