mysqldump -u root moodle_32 | xz > ~/Dropbox/moodle_32.sql.xz
use mysql; SELECT * FROM user where User="root"\G
CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL PRIVILEGES ON dbname.* TO dbuser@localhost WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `%`.* TO dbuser@'localhost' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'dbuser'@'localhost';
FLUSH PRIVILEGES;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass');
SHOW WARNINGS to see warnings if exists