Step 2: Create a MySQL Database and User

Next, you need to create a MySQL database and user for your WordPress installation. Follow these steps to create a database and user:

1. Log in to the MySQL server with the following command:

   sudo mysql -u root -p

2. Enter the MySQL root password when prompted.

3. Run the following command to create a new database:

   CREATE DATABASE wordpress;

4. Run the following command to create a new MySQL user:

   CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'password';

   Replace ‘wordpressuser’ and ‘password’ with your desired username and password.

5. Grant the new user permissions to the WordPress database:

   GRANT ALL PRIVILEGES ON wordpress.* TO 'wordpressuser'@'localhost';

6. Flush the MySQL privileges to ensure the changes take effect:

   FLUSH PRIVILEGES;

7. Exit the MySQL shell:

   exit;