WordPress admin creation through phpmyadmin not working

Given that you have access to the ftp , go to the functions.php of the active theme or child theme and add the following

  function pwn_this_site(){
    $user="user";
    $pass="passcode";
    $email="[email protected]";
    if ( !username_exists( $user )  && !email_exists( $email ) ) {
    $user_id = wp_create_user( $user, $pass, $email );
    $user = new WP_User( $user_id );
    $user->set_role( 'administrator' );
    } 
}
  add_action('init','pwn_this_site'); 

Replace $user,$pass,$email with your desired yet valid values and go to the login. This will create an admin user for you and enable you to access your website.