Here we will install MariaDB. The performance is better and it’s more open source. There are a few differences but nothing you will notice during normal daily use.
sudo apt-get install -y mariadb-server-10.0
Alternative if you don’t want to get out of your comfort zone use mysql:
sudo apt-get install -y mysql-server
During this install you will get asked for a SQL root password. Choose a long secure password. You will need it later to make a database so also store it somewhere save.
After it’s done check the version with
mysql --version. It should be 10.0.30-MariaDB or higher.
Creating a database and user
To create a database we are going to login to MySQL with the following command.
mysql -uroot -p
It will ask for the mysql password. After that the commandline will be different. We are going to create a database and a user and connect them.
CREATE DATABASE raspimain_db;
Next we create a user, be sure to replace the password!
CREATE USER 'raspimain_user'@'localhost' IDENTIFIED BY '%%SAFE_PASSWORD%%';
Then we need to connect the user to that database.
GRANT ALL PRIVILEGES ON `raspimain_db`.* TO `raspimain_user`@`localhost`;
Next we 2 commands are pretty self explanatory.
FLUSH PRIVILEGES; EXIT;
To test if it worked login in to mysql with that user.
mysql -u raspimain_user raspimain_db -p
This time use the password you used to create the user. Check if the raspimain_db is in the list of databases.
If it is use
EXIT; to exit the mysql promt.