\u525b\u525b\u4e0d\u5c0f\u5fc3\u8aa4\u522aroot…\u771f\u662f\u60b2\u5287<\/p>\n
1.\u95dc\u9589\u670d\u52d9
\n#\/etc\/init.d\/mysql stop<\/p>\n
2.\u5b89\u5168\u6a21\u5f0f\u555f\u52d5\uff0c\u4e0d\u6aa2\u67e5\u6b0a\u9650
\n#mysqld_safe \u2013-skip-grant-tables &<\/p>\n
3.\u9032\u5165mysql\u6307\u4ee4
\n#mysql<\/p>\n
4.\u9078\u64c7mysql\u8cc7\u6599\u5eab
\nmysql> use mysql<\/p>\n
5.\u52a0\u5165\u540d\u70baroot\u7684user
\nmysql> insert into user set user=’root’;<\/p>\n
6.\u66f4\u65b0\u5bc6\u78bc
\nmysql> update user set password=password(‘123456′) where user=’root’;<\/p>\n
7.\u66f4\u65b0\u6b0a\u9650\u8a2d\u5b9a
\nmysql> update user set Host=’localhost’,select_priv=’y’, insert_priv=’y’,update_priv=’y’,
\nAlter_priv=’y’,delete_priv=’y’,create_priv=’y’,drop_priv=’y’,reload_priv=’y’,shutdown_priv=’y’,
\nProcess_priv=’y’,file_priv=’y’,grant_priv=’y’,References_priv=’y’,index_priv=’y’,create_user_priv=’y’,
\nshow_db_priv=’y’,super_priv=’y’,create_tmp_table_priv=’y’,Lock_tables_priv=’y’,execute_priv=’y’,
\nrepl_slave_priv=’y’,repl_client_priv=’y’,create_view_priv=’y’,show_view_priv=’y’,create_routine_priv=’y’,
\nalter_routine_priv=’y’,create_user_priv=’y’,Event_priv=’y’,Trigger_priv=’y’ where user=’root’;<\/p>\n
8.\u5957\u7528\u65b0\u6b0a\u9650
\nmysql> flush privileges;<\/p>\n
9.\u96e2\u958bmysql
\nmysql> quit<\/p>\n
10.\u5f37\u5236\u95dc\u9589mysql\u670d\u52d9
\n#killall mysqld<\/p>\n
11.\u6b63\u5e38\u555f\u52d5mysql
\n#\/etc\/init.d\/mysql start<\/p>\n","protected":false},"excerpt":{"rendered":"
\u525b\u525b\u4e0d\u5c0f\u5fc3\u8aa4\u522aroot…\u771f\u662f\u60b2\u5287 1.\u95dc\u9589\u670d\u52d9 #\/etc\/init … \u95b1\u8b80\u5168\u6587