How to create

<a id="_q53zi5l73llx"></a>How to Change WordPress user Password via MySQL on Ubuntu

Step 1: log in ubuntu server\.

Step 2: Check the WordPress database name in the wp\_config\.php file\.

Step 3: Go to MySQL with root \(or\) WordPress user and use the WordPress database\.

$mysql \-u username \-p

> show databases;

> use wordpress\_databasename;

Step 4: In WordPress database we view wp\_users under WordPress databases\.

> show tables;

Step5 : view that wp\_users table with below quary

> select \* from wp\_users;

Step 6: select one user from the wp\_users table and change the password with below quarry

UPDATE database\_name\.database\_table\_name SET database\_table\_column = MD5\( 'your\_new\_password' \) WHERE database\_table\_name\.database\_table\_column = "your\_admin\_username";

Example:

> UPDATE wordpress\.wp\_users SET user\_pass = MD5\( 'kPjIZIWLXs'\) WHERE wp\_users\.user\_login = "saritha";