MYSQL CHANGE – RESET USER PASSWORD

Login to Mysql with an authorized user.

If more than one database exists, it can be listed with the following command.

Then the database where the user is located is selected.

The following command also lists the tables in the database.

You can list the fields in the table with the following command.

You can use the following command to see all the data in the table.

Or you can call up the data by customizing it as follows.

Now let’s reset the password of the user concerned.

NOTE: Clear text outgoing password should be deleted from “vim ~ / .mysql_history” file.

I hope it has been a useful article.