Tech Junkie Blog - Real World Tutorials, Happy Coding!: ACME Bank: Step 3: Install MySQL on Fedora Linux

Tuesday, June 22, 2021

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

2 comments:

  1. that’s a nice article, thank you for a great article. It helped me a lot. Keep it up Must Visit: Dell Printer klantenservice nummer.

    ReplyDelete
  2. The subsequent time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I do know it was my choice to learn, however I actually thought youd have something attention-grabbing to say. All I hear is a bunch of whining about something that you could repair in the event you werent too busy in search of attention. san-wells bank

    ReplyDelete

Search This Blog