Creating WordPress admin account using PhpMyAdmin

wp-admin.sql

/*
Creating admin user account for WordPress using PhpMyAdmin.

Please make the following changes and then run this SQL.

*** Change the Database name 'yourdbname'.
*** Change table names 'wp_users' and 'wp_usermeta' and also change 'wp_capabilities' and 'wp_user_level' according to table prefix.
*** Change username 'palpalani' and password 'password'
*** Change ID to whatever you need
*/

INSERT INTO `yourdbname`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('1', 'palpalani', MD5('password'), 'Palaniappan P', '[email protected]', 'http://www.m3webware.com/', '2013-09-12 00:00:00', '', '0','Palaniappan P');
INSERT INTO `yourdbname`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`,`meta_value`) VALUES (NULL, '1', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
INSERT INTO `yourdbname`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`,`meta_value`) VALUES (NULL, '1', 'wp_user_level', '10');