The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

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.?

Answer Answered by Ian Gilfillan in this comment.

See the Wordpress documentation for details.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.