Create WordPress admin user directly in the database

create.sql

START TRANSACTION;

SET @user_login = 'ryandial';
SET @user_nicename = 'Ryan Dial';
SET @user_email = 'ryan@example.com';

INSERT INTO `wp_users` (`user_login`,
                        `user_pass`,
                        `user_nicename`,
                        `user_email`,
                        `user_url`,
                        `user_registered`,
                        `user_activation_key`,
                        `user_status`,
                        `display_name`)
VALUES (@user_login,
        MD5(uuid()),
        @user_nicename,
        @user_email,
        '',
        now(),
        '',
        '0',
        @user_nicename);

SET @user_id = (SELECT `ID` FROM `wp_users` WHERE `user_login` = @user_login);

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, @user_id, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, @user_id, 'wp_user_level', '10');

COMMIT;