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

Thank you very much “dvikan”! I sincerely appreciate it. <br> <br>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 <br> <br>And just to use my own data here, would this be right: <br> <br>mysql -u root mysql -p <br>CREATE DATABASE wpdb01; <br>CREATE USER ‘wpdb01’@‘localhost’ IDENTIFIED BY ‘blahblah’; <br>GRANT ALL PRIVILEGES ON wpdb01.* TO ‘wpdb01’@‘localhost’; <br>FLUSH PRIVILEGES; <br> <br>I have the username and database as the same name here and the password as “blahblah”. <br> <br>Thanks again!

First make a password; <br>openssl rand -base64 16 <br> <br>Then create database and user and privileges. Then flush privileges. <br> <br>mysql -u root mysql -p <br>CREATE DATABASE ideside; <br>CREATE USER ‘ideuser’@‘localhost’ IDENTIFIED BY ‘yourpassword’; <br>GRANT ALL PRIVILEGES ON ideside.* TO ‘ideuser’@‘localhost’; <br>FLUSH PRIVILEGES; <br> <br>Obviously replace with your own data.

Check out <a href=“https://www.digitalocean.com/community/articles/how-to-set-up-multiple-wordpress-sites-on-a-single-ubuntu-vps”>How To Set Up Multiple WordPress Sites on a Single Ubuntu VPS</a>.