New features of mysql5.7

After mysql 5.7 version came out, there were still a lot of modifications and some optimizations, some bugs were fixed, some old parameters were deleted, and here is a simple cleanup.

Because mysql is usually installed using binary packages, so here we start with mysql binary package deployment. First of all, mysql installation initialization abandoned the old version of mysql_install_db and use mysqld --initialize initialization, mysql root password after initialization is not empty password, but after initialization will give a random password, to use normally need to change the password can be used, in mysql other installation parts and previous versions are the same

[root@localhost mysql]# ./ bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysqldata --user=mysql --initialize

Of course, if you forget the initial root random password, you can also find it in the.mysql_secret file in the user's home directory of the deployment installation.

After mysql 5.7.7 mysql removed the default test library and added user-locked functionality and syntax, and changed it to sys library, which added relevant system settings. And because of the continuous rise of MongoDB and other related files nosql, json support was added to mysql in version 5.7. In addition, the innoDB engine was heavily used in version 5.7, and the InnoDB engine could no longer be disabled. Even the user table of the system used the innoDB engine to improve performance and change some system parameters. In addition, some system parameters of other instructions were changed. In addition, some table fields in mysql library were modified in mysql 5.7, such as deleting the password field in the user table. Therefore, it is changed to the more secure authentication_string, so that if you want to modify the password of mysql5.7, you must update the authentication_string field. The operation is the same as the old version, as follows:

[root@localhost data]# mysqld_safe --skip-grant-tables --skip-networking &#start ignore authorization table, disable external network [root@localhost data]# mysql -pmysql> update mysql.user set authentication_string=password ('youpassword ') where user='root';

After modification, restart MySQL directly.