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
-
Situation : I have removed some mails from the MDaemon server from the backend,ie, browsed through the mail box and deleted some mails mauna...
-
Error on starting railo service. When starting Railo, it will show Railo service started but when checking the railo status ' No PID Fou...
-
Here in the following telnet sessions i am using the following details to demonstrate the dovecot verification. You have to replace with you...
-
Domain already exists error while adding a subdomain or addon domain A very common error when adding an addon or parked domain via cpanel....
-
BCC to Boss Function - Postfix Postfix provides three mechanisms: always_bcc = address Deliver a copy of all mail to the specifi...
-
MANY TOOLS IN ONE http://network-tools.com PING http://tools.pingdom.com You can use the above site used to check whether a domain is loadin...
-
If you are planning to use mysql for cyrus-sasl authentication, it is better to install PostfixAdmin. It will help us to add new smtp users ...
-
Error : This file is too big. Files must be less than 1500 KB in size Cause : In WordPress, by default Max upload file size is set to 1500 K...
-
Upgrade PHP version to 5.3 You can follow the steps shown below to upgrade your php version to 5.3 in Kloxo. Download and install repository...
-
Crontab Failure Emails The emails vary in subject line but include: /bin/sh: 1 : ambiguous redirect - Cron <root@host> /usr/local/cpan...