Cheatsheet for SQL creating a database

cheatsheet.sql

select host, user, password from mysql.user;
create database **********;
show databases;
create user '*******'@'%' identified by '**********'; 
grant all privileges on *********.* to '**********'@'%' identified by '**********';
flush privileges;

mysqldump -u root -p database > database.sql
mysql -u root -p wp_users < wp_users.sql

#grant all privileges uses databasename.* to work (MariaDB).