Reset mysql user password, needs to be run in save mode.

Mysql user reset

INSERT INTO mysql.user 
SET user = 'root', 
    host = 'localhost', 
    password = Password('wwPmz59DyjPYqa'), 
    super_priv = 'y', 
    select_priv = 'y', 
    insert_priv = 'y', 
    update_priv = 'y', 
    delete_priv = 'y', 
    create_priv = 'y', 
    drop_priv = 'y', 
    reload_priv = 'y', 
    shutdown_priv = 'y', 
    process_priv = 'y', 
    file_priv = 'y', 
    grant_priv = 'y', 
    references_priv = 'y', 
    index_priv = 'y', 
    alter_priv = 'y', 
    show_db_priv = 'y', 
    create_tmp_table_priv = 'y', 
    lock_tables_priv = 'y', 
    execute_priv = 'y', 
    repl_slave_priv = 'y', 
    repl_client_priv = 'y', 
    create_view_priv = 'y', 
    show_view_priv = 'y', 
    create_routine_priv = 'y', 
    alter_routine_priv = 'y', 
    create_user_priv = 'y';