Create Database for WordPress

Enter MySql or MariaDb

sudo mysql

Show current databases

SHOW DATABASES;

Create database

CREATE DATABASE mydbname;

Now assign privileges to this database

GRANT ALL PRIVILEGES on mydbname.* to 'myusername'@'localhost' IDENTIFIED BY 'mypassword';

Save changes

FLUSH PRIVILEGES;

Check privileges

SHOW GRANTS for 'myusername'@'mydbname';