Are you looking to install MySQL version 5.7 on your web server? Follow these simple steps to get started.
Step 1: Copy the Key to Your Clipboard
Begin by copying the key from the following link: https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html. Save the key in a file named “
signature.key” on your machine.
Step 2: Add the Key
Open your terminal and execute the following command:
sudo apt-key add signature.key
Step 3: Add the APT Repository
To add the APT repository, run the following command:
sudo sh -c 'echo "deb http://repo.mysql.com/apt/ubuntu bionic mysql-5.7" >> /etc/apt/sources.list.d/mysql.list'
Step 4: Update APT
Keep your packages up to date by running this command:
sudo apt-get update
Step 5: Check Available Versions
To check the available versions, enter the command:
sudo apt-cache policy mysql-server
Step 6: Install MySQL 5.7
Now, let’s install MySQL 5.7. Execute the following command:
sudo apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*
Step 7: Configure MySQL Community Server
During the configuration process, you’ll be prompted to set a strong password for the root account of your MySQL database. If you prefer password-less login using UNIX socket based authentication, you can leave it blank. Follow the instructions provided by the setup wizard.
Congratulations! You have successfully installed MySQL version 5.7 on your web server. Enjoy utilizing its features and power your applications with a reliable database system.
Note: Remember to keep your MySQL installation secure by setting strong passwords and following best practices.