ACME Bank: Step 3: Install MySQL on Fedora Linux

The most important thing for most modern dynamic application these day is choosing a database to store your data.  If you are on a Windows environment then you use SQL Server database that is a fine choice. But if you are on Linux MySQL is a great choice also.  In this post we are going to go through how to install MySQL server on our Fedora development machine.

Here are the steps to install MySQL on Fedora Linux:

1. First we need to add the MySQL repository to our machine by tying in the following command in the terminal

sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-fc32-1.noarch

2. After the repository has been added we are now ready to install MySQL with this command sudo dnf install mysql-community-server

3.  The next step is to start and enable the MySQL service with these commands

sudo systemctl start mysqld

sudo systemctl enable mysqld

4.  For security reasons MySQL assigns a temporary password to the root account, you can get the temporary password with this command

sudo grep 'temporary password' /var/log/mysqld.log

Make a note of this password

5. Before first use type the following command to make the database more secure

sudo mysql_secure_installation

After typing in the command and entering the temporary password, you will be given an opportunity to set a new password for the root user, type in the password the root user.  Say yes to all the prompt for y/n

6.  Now we can connect to MySQL server with this command

mysql -u root -p 

Enter the root password when prompted and when you are connected to MySQL type SELECT version(); to see the version

There you have it, how we have everything we need to develop our application on Fedora.  I know it seems like a lot of work for very little result, but this is the nature of software development.  If the repository link does not work go to this URL https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html and install it from there

Previous: Setting Up Development Environment With .NET Core, NodeJS , VSCode and Postman

Next: Create An Asp.Net Core Web API With The Asp.Net Core CLI