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