Raspberry Pi Around the House - Raspberry Pi Hacks - page 129

All done! If you've completed all of these steps, your MySQL installation should now
be secure:
Thanks for using MySQL!
For WordPress, you'll need a database and a user. Log in to MySQL using the root
password you just set up:
$ mysql -u root -p
Then create your database and user. Replace piblogger with whatever you'd like your
database to be named and ian with the user who will be in charge of it (and it should
go without saying that mypassword is a terrible password choice that you should
change):
mysql> CREATE DATABASE piblogger;
Query OK, 1 row affected (0.00 sec)
mysql> CREATE USER 'ian'@'localhost' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON * . * to 'ian'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> EXIT
Download the latest WordPress tarball from https://wordpress.org/latest.tar.gz or:
$ wget https://wordpress.org/latest.tar.gz
Extract the tarball into the public HTML folder:
$ sudo tar -xvzf latest.tar.gz -C /var/www/html
This will create a directory called wordpress in /var/www/html . Next you need to set up
the config file:
$ vi /var/www/html/wordpress/wp-config-sample.php
The things you need to configure are at the top of the file, and the parts you need to
fill in are in all caps:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'piblogger');
/** MySQL database username */