centos yum installation mysql

CentOS is a free and open source Linux distribution and a stable and efficient server operating system. When using CentOS, we usually need to install some services or tools, such as MySQL database. In this article, we will introduce the detailed steps to install MySQL using yum on CentOS.

1. Download the corresponding Yum source repo file from the MySQL official website and move it to the yum source configuration file directory of CentOS.

# 下载yum源文件
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

# 安装yum源文件，如果已经安装可以使用yum reinstall命令重新安装
sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm

# 将yum源配置文件复制到yum源配置目录下
sudo cp /etc/yum.repos.d/mysql-community.repo /etc/yum.repos.d/mysql-community.repo.bak

2. Update Yum source and install MySQL:

# 更新Yum源
sudo yum makecache

# 安装 MySQL
sudo yum install mysql-server

3. Enable MySQL service and configure auto-start at boot

# 启动MySQL服务
sudo systemctl start mysqld

# 开机自启动MySQL服务
sudo systemctl enable mysqld

4. Configuring MySQL

After starting, you need to configure MySQL first. When starting MySQL for the first time, a temporary password will be generated. Use the following command to view it:

sudo grep 'A temporary password' /var/log/mysqld.log

In MySQL command line mode Use the generated temporary password to log in and configure the MySQL user name and password:

#以临时密码为*8Lh8tU-m$iV 进入mysql
mysql -uroot -p*8Lh8tU-m$iV

#输入以下命令修改密码：
ALTER USER 'root'@'localhost' IDENTIFIED BY 'yournewpassword';

#修改完后，退出mysql，使用新密码重新登录
exit

mysql -uroot -p

5. Configure MySQL security:

Use the following commands to configure MySQL security:

#进入mysql安全配置
sudo mysql_secure_installation

#按提示操作，设置管理员密码等

6. Set encoding for MySQL

MySQL default encoding is latin1, we want to change it to utf8, first perform the following operations in MySQL:

# 进入mysql安全配置
sudo mysql_secure_installation

# 设置管理员密码后进入安全设置，并输入以下命令修改MySQL编码
set global character_set_server = utf8mb4;
set global collation_server = utf8mb4_unicode_ci;

Then add the following two lines of code under the [mysqld] section of the /etc/my.cnf file:

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci

Restart mysql after the settings are completed to take effect:

sudo systemctl restart mysqld.service

That’s it. We have successfully installed MySQL on CentOS using yum, which can be logged in and used through the mysql -u root -p command.

The above is the detailed content of centos yum installation mysql. For more information, please follow other related articles on the PHP Chinese website!