MySQL 5.6 关于登陆的初始化设置
[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]最近研究一下MySQL 5.6 版本发现安装后,使用空密码无法登陆[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]安装的过程中有这样的一句话:
[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER ![p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]You will find that password in '/root/.mysql_secret'.[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]You must change that password on your first connect,[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]no other statement but 'SET PASSWORD' will be accepted.[p=28, null, left][color=rgb(85, 85, 85)][font=宋体,]See the manual for the semantics of the 'password expired' flag.[color=#555555][font=宋体,] 大概意思就是 一个随机的密码已经生成 可以在 '/root/.mysql_secret'. 中找到
[color=#555555][font=宋体,]第一次连接必须变更密码 且只能使用 'SET PASSWORD' 命令
[color=#555555][font=宋体,]在user 表中新增加了'password expired' 列,也就是密码过期
[color=#555555][font=宋体,]我们来启动mysql 然后登陆
[color=#555555][font=宋体,]service mysql start
[color=#555555][font=宋体,]mysql -uroot -pvssAWF0O
[color=#555555][font=宋体,]#密码是在 more .mysql_secret 里面记录
[color=#555555][font=宋体,]# The random password set for the root user at Mon Mar 25 11:13:11 2013 (local time): vssAWF0O
[color=#555555][font=宋体,]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
Copyright (c) 2000, 2013, 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> 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>