mysql 密码悲剧了

action08

1. [root@192 ~]# service mysqld start
   
2. Initializing MySQL database:                               [  OK  ]
   
3. Installing validate password plugin:                       [  OK  ]
   
4. root
   
5. Starting mysqld:                                           [  OK  ]
   
6. [root@192 ~]#

复制代码

直接rpm安装的mysql，为什么这个root密码不是空的呢？？

1. [root@192 ~]#
   
2. [root@192 ~]# mysql
   
3. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
   
4. [root@192 ~]# mysql -proot
   
5. mysql: [Warning] Using a password on the command line interface can be insecure.
   
6. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
   
7. [root@192 ~]#

复制代码

oracle现在搞什么啊？？

action08

1. mysql>
   
2. mysql> show create table user;
   
3. +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   
4. | Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
   
5. +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   
6. | user  | CREATE TABLE `user` (
   
7.   `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
   
8.   `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
   
9.   `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
   
10.   `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
11.   `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
12.   `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
13.   `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
14.   `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
15.   `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
16.   `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
17.   `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
18.   `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
19.   `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
20.   `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
21.   `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
22.   `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
23.   `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
24.   `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
25.   `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
26.   `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
27.   `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
28.   `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
29.   `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
30.   `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
31.   `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
32.   `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
33.   `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
34.   `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
35.   `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
36.   `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
37.   `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
38.   `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
    
39.   `ssl_cipher` blob NOT NULL,
    
40.   `x509_issuer` blob NOT NULL,
    
41.   `x509_subject` blob NOT NULL,
    
42.   `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
    
43.   `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
    
44.   `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
    
45.   `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
    
46.   `plugin` char(64) COLLATE utf8_bin NOT NULL DEFAULT 'mysql_native_password',
    
47.   `authentication_string` text COLLATE utf8_bin,
    
48.   `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
49.   `password_last_changed` timestamp NULL DEFAULT NULL,
    
50.   `password_lifetime` smallint(5) unsigned DEFAULT NULL,
    
51.   `account_locked` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
    
52.   PRIMARY KEY (`Host`,`User`)
    
53. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges' |
    
54. +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    
55. 1 row in set (0.00 sec)
    
56. 
    
57. mysql>
    

复制代码

你妹的，技术变化太快了

daili0703

一看见你的头像，我就以为论坛图片打不开了呢   

lvchenotl

使用cat /root/.mysql_secret试试呢
我之前rpm安装5.6.24的时候也是，它会自己生成个随机的密码，并且会告诉你让你去指定的目录查看随机的密码

或者在配置文件中加个skip-grant-tables配置项，然后重启数据库试试