데이터베이스에서 워드 프레스 관리자 암호 및 이메일 변경

This brief tutorial shows you how to easily and quickly change WordPress admin password and email address from its database.

The reason I’m writing this is I ran into a minor issue where I lost control of my admin account.. not due to hackers or someone who deliberately took over my account.

A user who knew and had access to the admin account email requested a password change… the password help email was sent and password reset by the user.

 

After the change were made, I tried to contact the individual but couldn’t and couldn’t access the admin account.

I resulted to changing the admin account password and email address directly from the database to gain access to the account.

This can be used by anyone with root access to WordPress database.

The first step is to backup your MySQL databases. It’s always important to backup your databases before making changes that may corrupt them.

To backup your MySQL WordPress database, 아래의 명령을 실행, assuming your WordPress database is called wpdatabase.

mysqldump -u root -p wpdatabase >> wpdatabase.sql

After backing up your database, run the commend below to access the database server.

mysql -u root -p

Type the root password and login. When you’re logged into the database server, run the commands below to change the admin user password.

최종적으로, run the commands below to reset the admin password

UPDATE `wp_users` SET `user_pass` = MD5('new_password_here') WHERE `wp_users`.`user_login` = "admin";

To reset the admin email address from MySQL database, 아래의 명령을 실행

UPDATE `wp_users` SET `user_email` = "new_email_address" WHERE `wp_users`.`user_login` = "admin";

This tip applies to both MySQL and MariaDB database servers. If you run either of these servers, this tip should work.

즉입니다!

즐겨!

광고

회신을 남겨주

이 사이트는 스팸을 줄이기 위해 Akismet 플러그를 사용. 귀하의 코멘트 데이터가 처리되는 방법 알아보기.

우리는 당신에게 최고의 온라인 경험을 제공하기 위해 쿠키를 사용합니다. 동의함으로써 당신은에 따라 쿠키 사용을 허용 우리 개인 정보 정책.