Add a new admin user to wordpress via mySQL

new-user.sql

--
-- these are the only values you need to set
-- and then just run these in squence from the mysql terminal
--
SET @USER  := 'Your User Name';
SET @EMAIL := '[email protected]';
SET @PASS  := 'your-password-here';

--
-- wordpress will 'upgrade' the MD5 on your first login
--
INSERT INTO    `wp_users` 
   ( `ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, 
     `user_registered`, `user_activation_key`, `user_status`, `display_name`) 
VALUES (
      null
   ,  @USER
   ,  MD5(@PASS) 
   ,  @USER
   ,  @EMAIL
   ,  ''
   ,  now()
   ,  ''
   ,  '0'
   ,  @USER);

SELECT LAST_INSERT_ID() INTO @USER_ID;

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


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