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.
# 下载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
# 更新Yum源 sudo yum makecache # 安装 MySQL sudo yum install mysql-server
# 启动MySQL服务 sudo systemctl start mysqld # 开机自启动MySQL服务 sudo systemctl enable mysqld
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
Use the following commands to configure MySQL security:
#进入mysql安全配置 sudo mysql_secure_installation #按提示操作,设置管理员密码等
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!