MySQL 5.6中的登陆初始化设置

MySQL 5.6中的登陆初始化设置2013-10-30最近研究一下MySQL 5.6 版本发现安装后，使用空密码无法登陆

安装的过程中有这样的一句话：

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER ！

You will find that password in "/root/.mysql_secret".

You must change that password on your first connect,

no other statement but "SET PASSWORD" will be accepted.

See the manual for the semantics of the "password expired" flag.

大概意思就是一个随机的密码已经生成可以在 "/root/.mysql_secret". 中找到

第一次连接必须变更密码且只能使用 "SET PASSWORD" 命令

在user 表中新增加了"password expired" 列，也就是密码过期

我们来启动mysql 然后登陆

service mysql start

mysql -uroot -pvssAWF0O

#密码是在 more .mysql_secret 里面记录

# The random password set for the root user at Mon Mar 25 11:13:11 2013 （local time）: vssAWF0O

Warning: Using a password on the command line interface can be insecure.

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

Your MySQL connection id is 1

Server version: 5.6.10

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> select 1;

ERROR 1820 （HY000）: You must SET PASSWORD before executing this statement

#提示必须现更改密码才能执行语句

mysql> set password=password（"password2013"）;

Query OK, 0 rows affected （0.00 sec）

mysql> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set （0.03 sec）

mysql>

5.6版本的安全性大大增强了，其他的新特性的等待后续研究！

本文出自 “影子骑士” 博客，请务必保留此出处http://andylhz2009.blog.51cto.com/728703/1161923