MariaDB [(none)]> show create user;
|
+--------------------------------+
|
| CREATE USER for root@localhost |
|
+--------------------------------+
|
| CREATE USER 'root'@'localhost' |
|
+--------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> drop user root@localhost;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [(none)]> create user root@locahost identified by 'sugar plum fairy';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [(none)]> grant all on test.* to root@localhost;
|
ERROR 1133 (28000): Can't find any matching row in the user table
|
|
MariaDB [(none)]> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.2.38-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|