相关链接:
mysql安装包下载:MySQL :: Download MySQL Community Server (Archived Versions)
1.新建文件夹/opt/mysql,并cd进去
2运行wget http://dev.mysql.com/get/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar,下载mysql安装包,需要先自行安装wget。
3.运行tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
PS:centos7.6自带的类mysql数据库是mariadb,会跟mysql冲突,要先删除。
4.运行rpm -qa|grep mari,查询mariadb相关安装包
5.运行rpm -e --nodeps mariadb-libs和rpm -e --nodeps marisa,卸载
6.然后开始真正安装mysql,依次运行以下几条
******
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
******
如果报以下错误,请加上--nodeps
warning: mysql-community-server-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
7.运行systemctl start mysqld.service,启动mysql
然后开始设置root用户密码
8.Mysql自动给root用户设置随机密码,运行grep "password" /var/log/mysqld.log可看到当前密码
如日志内容为空
rm -rf /var/lib/mysql
systemctl restart mysqld
grep 'temporary password' /var/log/mysqld.log
9.运行mysql -u root -p,用root用户登录,提示输入密码可用上述的,可以成功登陆进入mysql命令行
10.设置root密码,对于个人开发环境,如果要设比较简单的密码(生产环境服务器要设复杂密码),可以运行
set global validate_password_policy=0;提示密码设置策略
set global validate_password_length=1;设置密码程度策略
(validate_password_policy默认值1)
set password for 'root'@'localhost' =password('rootroot');
11.运行flush privileges;使密码设置生效
重新运行mysql -u root -prootroot进入数据库
12.修改远程访问权限
grant all privileges on *.* to 'root'@'%' identified by 'rootroot' with grant option;
flush privileges;(方便后续主从复制+读写分离)
******此步可有可无
13./etc/my.cnf文件设置字符集为utf-8
#在[mysqld]部分添加:
character-set-server=utf8
#在文件末尾新增[client]段,并在[client]段添加:
default-character-set=utf8