Installing MySQL Community Server 8.0 on Red Hat Enterprise Linux

Technical Articles

Solution

Application

Content Type

Technical Documentation

Utilities & Services

ft:locale

en-US

In the terminal, change to the directory where you want to download files by executing a command similar to the following:
```
cd /tmp
```
Note:Files in the /tmp directory will automatically be deleted when the computer is restarted.
Refer to the following webpage to find and copy the URL for the most recent RPM package for MySQL:
Download MySQL Yum Repository
Download the RPM package for MySQL 8.0 by executing a command similar to the following after replacing the URL you retrieved in the previous step:
```
curl -OL https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
```
Note:The built-in repositories from Red Hat Enterprise Linux will install an older version of MySQL that is not compatible with Jamf Pro.
Add the MySQL yum repository by executing the following command:
```
sudo yum install mysql80-community-release-el7-*noarch.rpm
```
Note:
Due to the ongoing MySQL release cycle, you may need to select the version of MySQL you want to install if the expected version does not get installed. For more information, see the "Selecting a Release Series" section of the following MySQL documentation: https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
Install MySQL by executing the following command:
```
sudo yum install mysql-community-server
```
Using your preferred text editor, open the /etc/my.cnf file by executing a command similar to the following:
```
sudo vi /etc/my.cnf
```
Note:
For help with using the vi text editor, see the following webpage: A Beginner's Guide to Editing Text Files With Vi
Add the appropriate setting to the [mysqld] section of the /etc/my.cnf file based on your MySQL version and ensure that it is uncommented:
- If you are using MySQL 8.3 or earlier, add the following line:
  [mysqld] default-authentication-plugin=mysql_native_password
- If you are using MySQL 8.4 or later, add the following line instead:
  [mysqld] mysql_native_password=ON
Start MySQL by executing the following command:
```
sudo systemctl start mysqld.service
```
Enable MySQL by executing the following command:
```
sudo systemctl enable mysqld.service
```
Set the root user password by doing the following:
1. Find the temporary root password generated during MySQL installation by executing the following command:
```
sudo grep 'temporary password' /var/log/mysqld.log
```
2. Connect to the mysql> prompt by executing the following command:
```
mysql -u root -p
```
3. When prompted, enter the password returned by the previous command.
4. At the mysql> prompt, set the root password by executing a command similar to the following:
```
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
```
  Replace MyNewPass4! with your new password.
  Note:
  Default password requirements require a password containing 8 or more characters and at least one lowercase character, one uppercase character, one number, and one symbol.
5. Exit the prompt by executing the following command:
```
exit
```
6. Connect to the mysql> prompt again by executing the following command:
```
mysql -u root -p
```
7. When prompted, enter the password you set previously in the ALTER USER command to verify the new root user credentials are correct.
  The mysql> prompt should appear.
8. Exit the prompt by executing the following command:
```
exit
```
Configure MySQL 8.0 to be compatible with Jamf Pro.
For instructions, see the Configuring MySQL 8.0 for Jamf Pro article.