mysql版本
mysql5.7.28
下载地址
https://downloads.mysql.com/archives/community/
依赖组件依次安装(rpm方式安装)
common>>libs>>client>>>>server
安装步骤
-
检查是否安装mysql,和mariadb(如果存在)
rpm -qa|grep mysql
rpm -qa|grep mariadb 若存在,则把原先的删除
rpm -e --nodeps mysql
rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
-
组件的名称及版本如下
查看自己Linux版本,不要下错哦~
uname -a
3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm
- 安装下载的组件
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
-
成功的页面如下
-
启动mysql服务
service mysqld start
- 查看mysql服务和端口是否正常
ps -ef|grep mysql
netstat -an|grep 3306
- mysql的root用户,默认了一个临时密码
grep 'temporary password' /var/log/mysqld.log
- 使用临时密码登录进去,修改root的密码
set global validate_password_policy=0;
set global validate_password_length=1;
alter user root@localhost identified by 'root';
或者
update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
-
远程访问root
默认只有本机访问的权限,要通过其他机器访问,必须授权
grant all privileges on *.* to root@'%' identified by 'root';
flush privileges;
-
遇到过的报错
安装mysql-community-common-5.7.28-1.el7.x86_64.rpm出现冲突