Tuesday, October 7, 2008

How to reset root password on MySql?

Pass the root mode on terminal.

  1. To stop mysql:
    # /etc/init.d/mysql stop
  2. Access without privalages to mysql
    # mysqld_safe --skip-grant-tables &
  3. Pass to the mysql
    # mysql -u root

    # use mysql;

    # mysql -u root

    # mysql>
    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, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) VALUES
    ('localhost', 'root', '', '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);

  4. To start mysql:
    # /etc/init.d/mysql start

Now, new mysql password is blank! You can user myadmin password command to specify another password for mysql.

No comments: