Database for Wordpress
I just installed a new mariadb 10.3 and am attempting to create a wordpress database for a new website. I created a database using the command
CREATE DATABSE wordpress;
Then I attempted to set up a user account using the command
GRANT ALL ON wordpress.* TO 'me'@'localhost' IDENTIFIED BY 'mypswd";
This resulted in setting up a user account in the mysql database, but not in the wordpress database. Furthermore when I examine the wordpress database there are no tables of any kind. It is totally empty. When I attempt start up wordpress from my browser, I get an error message saying "ERROR establishing database connection".
I am setting up a new website on an Ubuntu 20/04 server with a LEMP stack. I have a test site set up and have everything else working correctly, but I cannot get wordpress to start up.
What am I doing wrong and how am I supposed to set up a database for wordpress.?