sudo mysqladmin -u root -p password '<new_password>'

UPDATE mysql.user SET host = '%' WHERE USER = 'root';

CREATE USER backupuser@localhost IDENTIFIED BY 'backuppassword';
GRANT LOCK TABLES, SELECT ON *.* TO backupuser@localhost IDENTIFIED BY 'backuppassword';

mysqldump -ubackupuser -pbackuppassword --all-databases --add-drop-database > all.sql
mysql -ubackupuser -pbackuppassword < all.sql;

CREATE USER <db_user>@localhost IDENTIFIED BY '<db_password>';
GRANT ALL privileges ON <db_name>.* TO <db_user>@localhost IDENTIFIED BY '<db_password>';

SELECT USER,host,password FROM mysql.user;

CREATE DATABASE IF NOT EXISTS <db_name> DEFAULT charset utf8 COLLATE utf8_general_ci;