Login
mysql -u root -p
Create database
create database wp_example_com;
Create user
CREATE USER 'wp_user'@'localhost' IDENTIFIED BY 'seofahdkshK';
Give the user permissons
GRANT ALL ON wp_example_com.* TO 'wp_user'@'localhost';