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
-
Complile and install PHP from source You can follow the steps shown below to install PHP5.2.x , PHP5.3.x and PHP5.4.x . You can download an...
-
If you, or your clients, are unable to login to your/their email accounts and the system shows this error message: Plaintext authentication ...
-
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 : 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...
-
Here in the following telnet sessions i am using the following details to demonstrate the dovecot verification. You have to replace with you...
-
Error on starting railo service. When starting Railo, it will show Railo service started but when checking the railo status ' No PID Fou...
-
Install YAZ PHP extension You can cry install yaz using the following command. But you may encounter an erro while the installation. # pecl ...
-
BCC to Boss Function - Postfix Postfix provides three mechanisms: always_bcc = address Deliver a copy of all mail to the specifi...
-
There may be a lot of reasons for the internal server error in plesk. Here in my case the situation is as follows. FIrst of all i stopped ...
-
DNS Introduction on BIND BIND or named is the most widely used DNS software on the Internet. Th...