Install MySQL 8 on CentOS, RHEL 6/7
To Add MySQL yum repository to your server, go to
https://dev.mysql.com/downloads/repo/yum/
Download the rpm file available.
For RHEL/CentOS 7
|
1 2 |
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm rpm -ivh mysql80-community-release-el7-3.noarch.rpm |
For RHEL/CentOS 6
|
1 2 |
wget https://dev.mysql.com/get/mysql80-community-release-el6-1.noarch.rpm rpm -ivh mysql80-community-release-el6-1.noarch.rpm |
Installing MySQL Server
|
1 |
yum install mysql-community-server |
Stop/Start MySQL
To stop/start MySQL, use service name “mysqld”.
|
1 2 3 |
systemctl start mysqld systemctl stop mysqld systemctl restart mysqld |
MySQL 8 root Password
When MySQL first starts, it create a random password and store in MySQL log file. To find the MySQL root password, run
|
1 |
grep 'temporary password' /var/log/mysqld.log |
This default password don’t allow you to do anything, so login to MySQL with this password and set a secure password for root.
|
1 |
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MYSQL_ROOT_PASSOWRD'; |
MYSQL_ROOT_PASSOWRD – replace it with you secure new MySQL root password.
Installing Older Version of MySQL
When you add MySQL repository, it activate latest version by default. If you want older version, say 5.7, you need to activate it.
To see available repository, run
|
1 |
yum repolist all | grep mysql |
To disable MySQL 8 repository, run
|
1 |
yum-config-manager --disable mysql80-community |
To enable MySQL 5.7 repository, run
|
1 |
yum-config-manager --enable mysql57-community |
Now installing MySQL server will install MySQL 5.7 instead of latest version.