sudo wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
sudo yum localinstall mysql57-community-release-el7-8.noarch.rpm
- 3.检查MySQL源是否安装成功,出现红色字体即为成功
sudo yum repolist enabled | grep "mysql.*-community.*"
mysqladmin --version
mysqld --initialize --user=mysql
cat /var/log/mysqld.log
- 7.启动MySQL,可以使用 ps -ef|grep mysqld 来查看启动状态
systemctl start mysqld.service
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
- 9.修改字符集:
- 修改配置文件
vim /etc/my.cnf
在最后加上中文字符集配置
character_set_server=utf8
重启MySQL
vim /etc/my.cnf
character_set_server=utf8
systemctl restart mysqld.service
grant all privileges on *.* to 用户名@'%' identified by 密码';