You can change wordpress Dashboard login credentials via mysql commandline:

Consider following details:

Database name : test_data

wp_ : As database perfix

wp_users : WordPress user table

User Id: 1

1. mysql

>> to enter in to mysql command line;

2. use test_data;

>> to use our database;

3. show tables;

>> Show all tables in that database;

4. SELECT ID, user_login, user_pass FROM (wp_users);

>> shows current details and ID

5. UPDATE `test_data`.`wp_users` SET `user_pass` = MD5( ‘yourpassword’ ) WHERE `wp_users`.`ID` =1;

• MySQL
• wordpress