You can create a new database administrator user in wordpress sites using phpMyadmin by issuing the following three Database Queries.
After running these queries, you can login to your worpress admin with the following login details.
UserName: admin1
Password: admin1
Query1:
INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
VALUES ('4', 'admin1', MD5('admin1'), 'Admin', 'admin@yourdomain.com', 'http://www.yourdomain.com/', '2012-12-30 00:00:00', '', '0', 'Admin');
Query2:
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');
Query3:
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, '4', 'wp_user_level', '10');
Note:- Please don't forget to change the 'databasename' with the database you are working with.
Please read through all the fields in the tables and change the values as you wish.
Reference:
http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/
About Me
Categories
Archives
Populares
-
Domain already exists error while adding a subdomain or addon domain A very common error when adding an addon or parked domain via cpanel....
-
Situation : I have removed some mails from the MDaemon server from the backend,ie, browsed through the mail box and deleted some mails mauna...
-
Here in the following telnet sessions i am using the following details to demonstrate the dovecot verification. You have to replace with you...
-
BCC to Boss Function - Postfix Postfix provides three mechanisms: always_bcc = address Deliver a copy of all mail to the specifi...
-
If you, or your clients, are unable to login to your/their email accounts and the system shows this error message: Plaintext authentication ...
-
In Kloxo ftp is running in xinetd. So first of all check this service is listening in port 21. [root@server ~]# netstat -plant | grep xinetd...
-
Install YAZ PHP extension You can cry install yaz using the following command. But you may encounter an erro while the installation. # pecl ...
-
Installing Ruby In cpanel it is easy to install Ruby using the following cpanel script. # /scripts/installruby Some times the cPanel script...
-
Change Mail sending IP Open the postfix configuration file, /etc/postfix/main.cf Find if there is an entry as follows, in the postfix config...
-
Bash script To Change password of all mail accounts The bash script given below will change the password of all the mail accounts in ...