MySQL Variables new 数据库 参数变量解释及正确配置使用
本站中文解释
_pass？
MySQL参数变量new_pass是MySQL root用户设置新密码时使用的变量，主要用于重置MySQL root用户的密码。
设置new_pass变量：
1、登录控制台，运行设置参数：
$ SET GLOBAL new_pass= “你指定的新密码”;
2、使用root用户登录，重新设置root用户密码：
$ ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘你指定的新密码’;
官方英文解释
new
| Command-Line Format | --new[={OFF|ON}] |
|---|---|
| System Variable | new |
| Scope | Global, Session |
| Dynamic | Yes |
| Disabled by | skip-new |
| Type | Boolean |
| Default Value | OFF |
This variable was used in MySQL 4.0 to turn on some 4.1
behaviors, and is retained for backward compatibility. Its
value is always OFF.
In NDB Cluster, setting this variable to ON
makes it possible to employ partitioning types other than
KEY or LINEAR KEY with
NDB tables. This
feature is experimental only, and not supported in
production. For additional information, see
User-defined partitioning and the NDB storage engine (NDB Cluster).
