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

Tuesday, August 25, 2020

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

6 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. That’s a nice article, thank you for a great article. It helped me a lot. Keep it up Must Visit: helpdesk Brother Printer.

    ReplyDelete
  3. That’s a nice article, thank you for a great article. It helped me a lot. Keep it up Must Visit: Dell helpdesk bellen.

    ReplyDelete
  4. Hi, I do think this is a great site. I stumbled upon it ;) I'm going to revisit once again since i have saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others.

    No more waste time to searching #HDimages, #PCwallpaper, #smartphone_wallpaper, #socialmedia_banner, #socialmedia_image_post, #natureHDimages, and many more awesome pictures. Just visit All Awesome Pictures Only For Love Hearts and choose your best choice.
    All Awesome Pictures Only For Love Hearts
    All Awesome Pictures Only For Love Hearts
    All Awesome Pictures Only For Love Hearts

    ReplyDelete

Search This Blog