Spotter-VM/mariadb/adminpwd.sql

6 lines
199 B
MySQL
Raw Permalink Normal View History

2018-01-19 15:50:15 +01:00
DELETE FROM mysql.user WHERE User != 'root' OR Host != 'localhost';
INSTALL PLUGIN unix_socket SONAME 'auth_socket';
UPDATE mysql.user SET plugin='unix_socket';
FLUSH PRIVILEGES;
DROP DATABASE test;