mysql57离线安装_mysql 5.7 离线安装

删除原有的mariadb

rpm -qa|grep mariadb

rpm -e --nodeps mariadb-libs

安装

rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm

rpm -ivh mysql-community-devel-5.7.20-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm

service mysqld status

systemctl start mysqld

重置root密码

grep 'temporary password' /var/log/mysqld.log

1 mysql -u root -p

2 mysql> Enter password: (输入刚才查询到的随机密码)

3 mysql> SET PASSWORD FOR 'root'@'localhost'= "123";

4 mysql> exit

授权

1 mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'qaz-123' WITH GRANT OPTION;

2 mysql>FLUSH PRIVILEGES;

3 mysql>exit;

防火墙

1 firewall-cmd --zone=public --add-port=3306/tcp --permanent

2 firewall-cmd --reload

通过修改my.cnf配置文件来修改时区

# vim /etc/my.cnf

##在[mysqld]区域中加上default-time_zone ='+8:00'

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

问题：

warning: mysql-community-server-5.7.20-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

libaio.so.1()(64bit) is needed by mysql-community-server-5.7.20-1.el7.x86_64

libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.20-1.el7.x86_64

libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.20-1.el7.x86_64

解决：

yum install libaio