Linux下安装MySQL 5.7.11

Linux下安装MySQL 5.7.11拷贝mysql5.7安装包

bash-4.1# cp /mnt/hgfs/Downloads/mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar /home解压安装包bash-4.1# tar -xvf mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar mysql-community-embedded-5.7.11-1.el6.x86_64.rpmmysql-community-common-5.7.11-1.el6.x86_64.rpmmysql-community-test-5.7.11-1.el6.x86_64.rpmmysql-community-client-5.7.11-1.el6.x86_64.rpmmysql-community-embedded-devel-5.7.11-1.el6.x86_64.rpmmysql-community-server-5.7.11-1.el6.x86_64.rpmmysql-community-devel-5.7.11-1.el6.x86_64.rpmmysql-community-libs-5.7.11-1.el6.x86_64.rpmmysql-community-libs-compat-5.7.11-1.el6.x86_64.rpm

检查系统已经安装的mysql 包

bash-4.1# rpm -qa | grep mysqlrsyslog-mysql-4.6.2-2.el6.x86_64php-mysql-5.3.2-6.el6.x86_64mysql-server-5.1.47-4.el6.x86_64mysql-connector-odbc-5.1.5r1144-7.el6.x86_64mysql-5.1.47-4.el6.x86_64dovecot-mysql-2.0-0.10.beta6.20100630.el6.x86_64mysql-libs-5.1.47-4.el6.x86_64mod_auth_mysql-3.0.0-11.el6.x86_64qt-mysql-4.6.2-16.el6.x86_64mysql-devel-5.1.47-4.el6.x86_64

删除原有mysql的安装包

bash-4.1# rpm -e rsyslog-mysql-4.6.2-2.el6.x86_64 --nodepsbash-4.1# rpm -e php-mysql-5.3.2-6.el6.x86_64 --nodepsbash-4.1# rpm -e mysql-server-5.1.47-4.el6.x86_64 --nodepsbash-4.1# rpm -e mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 --nodepsbash-4.1# rpm -e mysql-5.1.47-4.el6.x86_64 --nodepsbash-4.1# rpm -e dovecot-mysql-2.0-0.10.beta6.20100630.el6.x86_64 --nodepsbash-4.1# rpm -e mysql-libs-5.1.47-4.el6.x86_64 --nodepsbash-4.1# rpm -e mod_auth_mysql-3.0.0-11.el6.x86_64 --nodepsbash-4.1# rpm -e qt-mysql-4.6.2-16.el6.x86_64 --nodepsbash-4.1# rpm -e mysql-devel-5.1.47-4.el6.x86_64 --nodeps

安装mysql5.7的相关包，注意安装顺序，因为包之间有依赖。

bash-4.1# rpm -ivh mysql-community-common-5.7.11-1.el6.x86_64.rpmwarning: mysql-community-common-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-common ########################################### [100%]bash-4.1# bash-4.1# rpm -ivh mysql-community-libs-5.7.11-1.el6.x86_64.rpmwarning: mysql-community-libs-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-libs ########################################### [100%]bash-4.1# bash-4.1# bash-4.1# rpm -ivh mysql-community-embedded-5.7.11-1.el6.x86_64.rpmwarning: mysql-community-embedded-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-embedde########################################### [100%]bash-4.1# rpm -ivh mysql-community-client-5.7.11-1.el6.x86_64.rpmwarning: mysql-community-client-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-client ########################################### [100%]bash-4.1# bash-4.1# bash-4.1# rpm -ivh mysql-community-server-5.7.11-1.el6.x86_64.rpmwarning: mysql-community-server-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-server ########################################### [100%]bash-4.1# bash-4.1# rpm -ivh mysql-community-devel-5.7.11-1.el6.x86_64.rpm warning: mysql-community-devel-5.7.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing...########################################### [100%] 1:mysql-community-devel########################################### [100%]bash-4.1# ll /var/lib/mysqltotal 0

修改mysql的配置my.cnf ，关闭严格的密码设置，增加validate_password=OFF设置

bash-4.1# vi /etc/my.cnf# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[mysqld]## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockvalidate_password=OFF

启动mysql服务

bash-4.1#/etc/rc.d/init.d/mysqld startInitializing MySQL database: [OK]Installing validate password plugin: [OK]Starting mysqld: [OK]

有时validate_password=OFF会不生效，需要重启一下mysql 服务/etc/rc.d/init.d/mysqld restart在mysql的安装目录下会产生相关文件

bash-4.1# ll /var/lib/mysqltotal 122948-rw-r-----. 1 mysql mysql 56 Mar 31 17:04 auto.cnf-rw-------. 1 mysql mysql 1675 Mar 31 17:04 ca-key.pem-rw-r--r--. 1 mysql mysql 1074 Mar 31 17:04 ca.pem-rw-r--r--. 1 mysql mysql 1078 Mar 31 17:04 client-cert.pem-rw-------. 1 mysql mysql 1675 Mar 31 17:04 client-key.pem-rw-r-----. 1 mysql mysql346 Mar 31 17:04 ib_buffer_pool-rw-r-----. 1 mysql mysql 12582912 Mar 31 17:04 ibdata1-rw-r-----. 1 mysql mysql 50331648 Mar 31 17:04 ib_logfile0-rw-r-----. 1 mysql mysql 50331648 Mar 31 17:04 ib_logfile1-rw-r-----. 1 mysql mysql 12582912 Mar 31 17:04 ibtmp1drwxr-x---. 2 mysql mysql 4096 Mar 31 17:04 mysql-rw-rw----. 1 rootroot 6 Mar 31 17:04 mysqld_safe.pidsrwxrwxrwx. 1 mysql mysql0 Mar 31 17:04 mysql.sock-rw-------. 1 mysql mysql6 Mar 31 17:04 mysql.sock.lockdrwxr-x---. 2 mysql mysql 4096 Mar 31 17:04 performance_schema-rw-------. 1 mysql mysql 1679 Mar 31 17:04 private_key.pem-rw-r--r--. 1 mysql mysql451 Mar 31 17:04 public_key.pem-rw-r--r--. 1 mysql mysql 1078 Mar 31 17:04 server-cert.pem-rw-------. 1 mysql mysql 1675 Mar 31 17:04 server-key.pemdrwxr-x---. 2 mysql mysql12288 Mar 31 17:04 sys

修改mysql 的root用户的登陆密码

bash-4.1# mysql -u -root -pEnter password: ERROR 1045 （28000）: Access denied for user "-root"@"localhost" （using password: NO）bash-4.1# bash-4.1# /etc/rc.d/init.d/mysqld stopStopping mysqld: [OK]bash-4.1# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &[1] 10436bash-4.1# 2016-03-31T09:06:56.496531Z mysqld_safe Logging to "/var/log/mysqld.log".2016-03-31T09:06:56.613061Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysqlbash-4.1# mysqlWelcome to the MySQL monitor.Commands end with ; or g.Your MySQL connection id is 2Server version: 5.7.11 MySQL Community Server （GPL）Copyright （c） 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type "help;" or "h" for help. Type "c" to clear the current input statement.mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> UPDATE user SET authentication_string=PASSWORD（"zcxc123"） where USER="root";Query OK, 1 row affected, 1 warning （0.00 sec）Rows matched: 1Changed: 1Warnings: 1mysql> quitByebash-4.1# etc/rc.d/init.d/mysqld restart

进入mysql后，第一件事件就是要你改默认密码，由于已经关闭v
alidate_password功能，因此可以设置简单的密码

[root@c12 mysql57]# ./bin/mysql -u root -pERROR 1820 （HY000）: You must reset your password using ALTER USER statement before executing this statement.mysql> set password = password（"zcxc1234"）

本文永久更新链接地址