Mysql 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.
> use “database_identify”;
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.
> describe “tables_identify”;
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.