mysql忘记root密码或者root权限丢失

    |     2016年6月11日   |   学习偶记   |     评论已关闭   |    2058

环境:liunx

步骤:

  1. vi /etc/my.cnf    #编辑文件,找到[mysqld],在下面添加一行skip-grant-tables

    [mysqld]

    skip-grant-tables

    :wq!  #保存退出

  2. service mysqld restart  #重启MySQL服务 ,lnmp下是lnmp mysql restart
  3. 输入 mysql进入mysql命令行模式。(不用加任何东西就进去了)
  4. use mysql; #打开mysql数据库
  5. delete from User where user=’root’
  6. INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections, plugin, authentication_string) VALUES
    (‘localhost’, ‘root’, ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ”, ”, ”, ”, 0, 0, 0, 0, ”, ”);
  7. exit; #退出mysql
  8. vi /etc/my.cnf    #编辑文件,找到[mysqld],注释掉skip-grant-tables

    [mysqld]

    #skip-grant-tables

    :wq!  #保存退出

  9. service mysqld restart  #重启MySQL服务 ,root的密码是123456

噢!评论已关闭。