太阳花工作室

rpm安装mysql5.6.12遇到密码的问题

post by:sunshine 2013-7-21 10:17

wget mysql.5.6.12.rpm

rpm -ivh mysql.5.6.12.rpm

步骤都很常规。中间缺少什么库就安装什么库。安装完成之后发现，使用空密码无法登陆。

使用以前的改密码的方法都没有成功。

其中有

[root@loaclhost] /usr/bin/mysqld_safe --usr=mysql --skip-grant-tables --skip-networking&

开启第二个终端

[root@loaclhost] /usr/bin/mysql -u root mysql

使用mysqladmin。输入　

mysqladmin -u root -p oldpassword newpasswd

让我郁闷了很久。

问度娘和布谷鸟都没有解决。偶然间看到一篇文章上面说。，安装的过程中有这样的一句话：

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' 列，也就是密码过期

#我里个去，没有仔细看文档说明。哎………………

service mysql start

#密码是在 /root/ .mysql_secret 里面记录

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

mysql -uroot -pvssAWF0O

#终于进去了。

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('123456789');

Query OK, 0 rows affected (0.00 sec)

mysql>