1. 下载 MySQL 官方 Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2. 开始安装
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
3. 启动 MySQL 服务端
systemctl start mysqld.service
查看一下服务端运行情况
systemctl status mysqld.service
4. 在日志找到 MySQL 初始密码
grep "password" /var/log/mysqld.log
5. MySQL 配置
修改初始密码,先用上面找到的密码进行登录
mysql -u root -p
然后输入上面的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
new password 即为你自己设定的新密码!!!
MySQL 授权,方便客户端用工具远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new password' WITH GRANT OPTION;
new password 即为你上面设定的新密码
刷新权限信息
FLUSH PRIVILEGES;
配置 MySQL 的默认编码,设置为 UTF-8
vim /etc/my.cnf
添加
[mysqld] character_set_server=utf8 init_connect='SET NAMES utf8'
重启 MySQL 服务端
systemctl restart mysqld
6. 其他命令
1. systemctl restart mysqld(重启 MySQL)
2. systemctl status mysqld(查看 MySQL 运行状态)
3. systemctl start mysqld(启动 MySQL 服务端)