Event Timeline
Comment Actions
mysql:root@localhost [(none)]> revoke SELECT, SHOW VIEW ON `idwikimedia\_p`.* FROM 'labsdbuser'; Query OK, 0 rows affected (0.00 sec) mysql:root@localhost [(none)]> Ctrl-C -- exit! Aborted root@labsdb1010:~# mysql -uroot --skip-ssl Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7135706 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql:root@localhost [(none)]> pager grep idwikimedi; show grants for labsdbuser; PAGER set to 'grep idwikimedi' 890 rows in set (0.00 sec) mysql:root@localhost [(none)]> Ctrl-C -- exit! Aborted root@labsdb1010:~# mysql -umaintainviews -p --skip-ssl -e "create database idwikimedia_p;" Enter password: ERROR 1044 (42000) at line 1: Access denied for user 'maintainviews'@'localhost' to database 'idwikimedia_p'