Ich habe die Sache mal "zu Fuß" nachgespielt und komme dabei zum gleichen Ergebnis (Quittungen "OK" gelöscht, um es übersichtlicher zu halten):
Code: Alles auswählen
> mysql -uroot -p
MariaDB [(none)]> CREATE DATABASE testbase;
MariaDB [(none)]> use testbase
MariaDB [testbase]> GRANT ALL PRIVILEGES ON testbase to testuser@localhost IDENTIFIED BY 'testpass';
MariaDB [testbase]> FLUSH PRIVILEGES;
MariaDB [testbase]> quit
> mysql -utestuser -p
MariaDB [(none)]> USE testbase;
MariaDB [testbase]> SHOW GRANTS;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for testuser@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'testuser'@'localhost' IDENTIFIED BY PASSWORD '*00E247AC5F9AF26AE0194B41E1E769DEE1429A29' |
| GRANT ALL PRIVILEGES ON `testbase`.`testbase` TO 'testuser'@'localhost' |
+-----------------------------------------------------------------------------------------------------------------+
MariaDB [testbase]> create table nurtest (spalte1 int);
ERROR 1142 (42000): CREATE command denied to user 'testuser'@'localhost' for table 'nurtest'