mysql-5.5和5.7_mysql 5.5 和5.7 安装的区别

mysql 5.5 的安装步骤：

1 软件安装

[root@dg2 ~]# rpm -ivh MySQL-server-advanced-5.5.54-1.el6.x86_64.rpm

warning: MySQL-server-advanced-5.5.54-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing...                ########################################### [100%]

1:MySQL-server-advanced  ########################################### [100%]

[root@dg2 ~]# rpm -qa |grep MySQL

MySQL-server-advanced-5.5.54-1.el6.x86_64

MySQL-shared-compat-advanced-5.5.54-1.el6.x86_64

MySQL-client-advanced-5.5.54-1.el6.x86_64

--直接重启会失败

[root@dg2 mysql]# service mysql restart

ERROR! MySQL server PID file could not be found!

Starting MySQL.Logging to '/var/lib/mysql/dg2.err'.

.... ERROR! The server quit without updating PID file (/var/lib/mysql/dg2.pid).

--必须通过mysql_install_db 进行初始化，才能重启成功

mysql_install_db --user=mysql --basedir=/var/lib/mysql --datadir=/var/lib/mysql

或者

/usr/bin/mysql_install_db  --user=mysql

[root@dg2 ~]# service mysql restart

Shutting down MySQL.... SUCCESS!

Starting MySQL... SUCCESS!

登录mysql不用密码，直接登录

[root@dg2 ~]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.54-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql>

修改密码的方式

update user set password=password('mysql') where user='root' and host='localhost';

mysql 5.7 的安装方式

---安装数据库软件

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

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

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

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

[root@dg ]# rpm -ivh mysql-commercial-server-5.7.18-1.1.el6.x86_64.rpm

warning: mysql-commercial-server-5.7.18-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing...                ########################################### [100%]

1:mysql-commercial-server########################################### [100%]

[root@dg tmp]# rpm -qa |grep MySQL

perl-DBD-MySQL-4.013-3.el6.x86_64

MySQL-server-advanced-5.5.54-1.el6.x86_64

MySQL-devel-advanced-5.5.54-1.el6.x86_64

MySQL-shared-compat-5.6.35-1.el6.x86_64

MySQL-client-advanced-5.5.54-1.el6.x86_64

---初始化数据

/usr/sbin/mysqld --initialize --user=mysql --basedir=/var/lib/mysql --datadir=/var/lib/mysql

----重启数据库

[root@dg log]# service mysqld restart

Stopping mysqld:                                           [  OK  ]

Starting mysqld:                                           [  OK  ]

---登录mysql，密码吗会在mysqld.log 中

[root@dg log]# cat mysqld.log  |grep password

2017-03-16T07:18:26.877377Z 1 [Note] A temporary password is generated for root@localhost: MwBV,Xdy<1Dm

mysql  -uroot -p 输入密码

---修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Cz.123456';

Query OK, 0 rows affected (0.00 sec)

mysql>  update mysql.user set authentication_string=PASSWORD('Cz.123456') where user='root' and host='localhost';

Query OK, 1 row affected, 1 warning (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 1

结论：通过对比可以发现5.7版本有很多改进

1、初始化方面，mysql  5.5 习惯用mysql_install_db ，而在5.7版本开始推荐用--initialize 来初始化数据库

2、在登录方面，5.5在登录的时候回用空密码登录，而在5.7版本会产生随机密码在日志文件中

3、在修改密码方面，5.7 可以用alter user的方式直接修改密码，在5.5版本是没有的