Every WordPress installation has a database in the backend. That’s one of WordPress’ requirements.
Now, there are many different database servers you can use with WordPress. From MySQL to MariaDB to Percona and MongoDB, all of these different database servers should work just fine with WordPress.
Because you can’t use all of them at the same time, you must select one to use with WordPress. For this post, we’re going to be using MySQL databases to connect WordPress.
This brief tutorial is going to show you how to create WordPress MySQL database and user, and how to grant the user rights to manage the WordPress database.
To get started with managing WordPress’ MySQL databases, follow the steps below:
Step 1: Install MySQL
If you haven’t installed MySQL yet, the commands below show you how to install it on Ubuntu.
sudo apt-get update sudo apt-get install mysql-server mysql-client
During the installation, you’ll be prompted to create and confirm a new root password for MySQL. Please type and confirm a password to continue.
This is the same password you’ll use to sign onto MySQL server.
Step 2: Sign on and Create a WordPress Database and User
After the database server has been installed, run the commands below to sign onto the database.
sudo mysql- u root -p
You’ll be prompted for a password.. type the password you created earlier during the installation.
After signing on to MySQL database server, run the commands below to create a new WordPress database called wpdb.
CREATE DATABASE wpdb;
This will create a new WordPress database called wpdb.
After creating the WordPress database, you’ll also need to create a database user. This account will be used by WordPress to interact with the database. To create the database user named wpuser, run the commands below.
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'type_user_password_here';
The above commands create a new database user called wpuser.
Now you should have both the database and user created. The user does have not any rights to the database. In order for the database user to interact on behalf of WordPress, including making changes to the data in the database, the user will need the rights to do these things.
To give the user full rights to mange the database, run the commands below
GRANT ALL ON wpdb.* TO 'wpuser'@'localhost';
The commands above grant wpuser all rights to manage all the tables in the wpdb database.
To grant the user right to a single table, run the commands below
- Installing MySQL Server on Ubuntu from its Repository
- Installing MySQL Latest Versions on Ubuntu 17.04
- How to Install the Latest MySQL 5.7 on Ubuntu 17.04
- Backup MySQL Databases with AutoMySQLBackup on Ubuntu 17.04 / 17.10
- Installing phpMyAdmin, Apache2, MySQL and PHP on Ubuntu 17.04 / 17.10
- Manage Remote MySQL Databases via phpMyAdmin on Ubuntu 17.04 / 17.10
- Resetting MySQL Root Password on Ubuntu 17.04 / 17.10
- Install MySQL Latest Versions on Ubuntu 16.04 LTS Server
- Install MySQL 8.0 on Ubuntu 16.04 / 17.10 / 18.04