Goto https://codebeautify.org/wordpress-password-hash-generator and enter the password you would like to set for your admin user.
UPDATE `users` SET `user_pass` = '$P$BXdJzbcCjLnLoXzHS645odEe/BMaBA1' WHERE `users`.`user_login` = 'john';
Use the SQL above to update the user_pass field. Make sure you replace the value for user_pass with the new hash from the website and replace the user_login value with your admin username.