CentOS 7: MySQL

  LEMP, Mysql

Look, you could just download an rpm and run it, it’s not hard, but meh! Lazy, yum it, mine said mariadb, I though why not.

yum install mariadb-server mariadb

Start and enable…

systemctl start mariadb
systemctl enable mariadb

Now secure it some the baddies have to work a tiny bit harder to get your useless data. Run this, set password, a strong one, save it in your phone as Mr MySQL, disallow remote access, yada yada yada.

mysql_secure_installation

Well done, might as well create a database, for something like a crap WordPress blog to note things down, not for someone to read it, just because you might remember how to do it. No idea why writing it down make me rememeber, I won’t look back at this! So, create a database.

mysql -u root -p

Lets hope you remembered your password.

CREATE DATABASE my_wordpress_db;
CREATE USER my_wordpress_user@localhost IDENTIFIED BY 'LettersNumbersWeirdLookingSymbol';
GRANT ALL PRIVILEGES ON my_wordpress_db.* TO my_wordpress_user@localhost;
FLUSH PRIVILEGES;
exit