MySQL 5.6 关于登陆的初始化设置

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:509

[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

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)