with a certified person.
If multiple database exists, it may be indexed with the next command.
Then the database the place the person is positioned is chosen.
The next command additionally lists the tables within the database.
You’ll be able to checklist the fields within the desk with the next command.
You’ll be able to use the next command to peer the entire knowledge within the desk.
>make a choice *from“tables_identify”G;
Or you’ll name up the knowledge via customizing it as follows.
>make a choice *from wp_users the place ID=1;
Now let’s reset the password of the person involved.
>UPDATE wp_users SET user_pass=MD5(‘123456’)the place ID=1;
NOTE: Transparent textual content outgoing password will have to be deleted from “vim ~ / .mysql_history” record.
I’m hoping it’s been an invaluable article.