Proceed as pi.
MySQL server login.
sudo mysql -uroot -p[rootpassword] mysql
Add user ‘wp’ (Stepping line)
create user 'wp'@'%' identified by 'userpassword'; grant all privileges on wp.* to 'wp'@'%'; create user 'wp'@'localhost' identified by 'userpassword'; grant all privileges on wp.* to 'wp'@'localhost'; ### Tip - delete user: drop user 'wp'@'%'; drop user 'wp'@'localhost'; ###
Create database ‘wp’
create database wp;
MySQL restart
flush privileges;
Confirmation database.
show databases;