首页 / MYSQL / Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynami

Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynami

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynami，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3112字，纯文字阅读大概需要5分钟。

内容图文

 

 

InnoDB Notes

  • Incompatible Change: The InnoDB storage engine can no longer be disabled. The --skip-innodb option is deprecated and has no effect, and its use results in a warning. It will be removed in a future MySQL version. This also applies to its synonyms (--innodb=OFF, --disable-innodb, and so forth).

 

Security Notes

  • Incompatible Change: MySQL 5.6 deprecated passwords that used the older pre-4.1 password hashing format. Support for these passwords is now removed, which involves the following changes. Applications that use any feature no longer supported must be modified.

    • The server-side mysql_old_password authentication plugin is removed. Accounts that use this plugin are disabled at startup and the server writes an “unknown plugin” message to the error log. For instructions on upgrading accounts that use this plugin, see Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin.

      The client-side mysql_old_password authentication plugin is removed from the C client library.

    • The --secure-auth option to the server and client programs is the default, but is now a no-op. It is deprecated and will be removed in a future MySQL version.

    • The --skip-secure-auth option to the server and client programs is no longer supported and using it produces an error.

    • The secure_auth system variable permits only a value of 1; a value of 0 is no longer permitted.

    • For the old_passwords system variable, a value of 1 (produce pre-4.1 hashes) is no longer permitted.

    • The OLD_PASSWORD() function is removed.

    • The mysqladmin old-password command is removed.

  • MySQL now includes a server-side authentication plugin named mysql_no_login for setting up accounts that accept no client connections. This plugin enables DBAs to implement the following use cases:

    • Stored program and view objects that perform sensitive or adminstrative operations must run with elevated privileges. Less-privileged users must be able to execute these objects but not be able to directly log in as the account that has the privileges. To implement this, create a no-login account using mysql_no_login, grant it the required privileges, define objects with a DEFINER of that account, and include SQL SECURITY DEFINER in the definitions.

    • Access to a proxy account must always be by the usual proxy mechanism, never by users logging in directly to the proxy account. To implement this, assign mysql_no_login as the authentication plugin when you create the proxy account.

    For more information, see No-Login Pluggable Authentication.

 

Functionality Added or Changed

 

内容总结

以上是互联网集市为您收集整理的Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynami全部内容，希望文章能够帮你解决Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynami所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/874948.html

来源：【匿名】