How do you setup a MySQL database to use with a WordPress installation?

Question

I have a “Wordpress on Ubuntu 12.10” droplet (512MB Ram 20GB SSD Disk) and I would like to setup additional WordPress installations. But I first need to know how to setup a MySQL database under such a scenario.

What are the exact steps to setup a MySQL database to use with a WordPress installation using DigitalOcean?

Thanks!

pablo · Answer

Check out How To Set Up Multiple WordPress Sites on a Single Ubuntu VPS.

hello292806 · Answer

Thank you very much “dvikan”! I sincerely appreciate it.

When you say “First make a password”, are you referring to the password that I would type in when I do this “ssh root@IP -ADDRESS-HERE”? If so, I already have a password for that. Should I just go straight to: mysql -u root mysql -p

And just to use my own data here, would this be right:

mysql -u root mysql -p
CREATE DATABASE wpdb01;
CREATE USER ‘wpdb01’@‘localhost’ IDENTIFIED BY ‘blahblah’;
GRANT ALL PRIVILEGES ON wpdb01.* TO ‘wpdb01’@‘localhost’;
FLUSH PRIVILEGES;

I have the username and database as the same name here and the password as “blahblah”.

Thanks again!

me285394 · Answer

First make a password;
openssl rand -base64 16

Then create database and user and privileges. Then flush privileges.

mysql -u root mysql -p
CREATE DATABASE ideside;
CREATE USER ‘ideuser’@‘localhost’ IDENTIFIED BY ‘yourpassword’;
GRANT ALL PRIVILEGES ON ideside.* TO ‘ideuser’@‘localhost’;
FLUSH PRIVILEGES;

Obviously replace with your own data.

Question

How do you setup a MySQL database to use with a WordPress installation?