mysql 5.7.22安装

mysql-community-server-5.7.22 rpm 安装

删除旧包：

rpm -qa | grep -i mysql
rpm -ev mysql-libs-* --nodeps

删除mariadb:

rpm -qa | grep -i mariadb
rpm -ev mariadb-libs-* --nodeps

安装rpm包：

rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

启动、停止：

service mysqld start
service mysqld stop
service mysqld status

查看初始密码：

cat /var/log/mysqld.log | more

日志里面有默认的初始密码：

[Note] A temporary password is generated for root@localhost: nt_ZcWfqX8I0

使用初始密码登录：

mysql -uroot -pnt_ZcWfqX8I0

修改密码：

mysql> set password='Pwd@123456';
  ##允许远程访问root用户
mysql> grant all privileges on *.* to 'root'@'%' identified by 'Pwd@123456';

常见问题

• 报错缺少libaio.so.1

64位系统安装：

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm

# or
wget http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm

rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

• 使用默认密码登录失败

[root@iZbp16ix79aknv9fhzijnkZ ~]# mysql -uroot -p4%FtsNDd>vef
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

原因：默认密码中带有>，可以使用

mysql -uroot -p

在提示输入密码后输入即可。

docker中安装

docker pull mysql:5.7

启动

docker run --name some-mysql -p 3308:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

连接mysql

docker exec -it some-mysql mysql -uroot -p
  ## 或者
docker exec -it containerId mysql -uroot -p

参考：
https://hub.docker.com/r/cytopia/mysql-5.7/