Mysql change user password _ MySQL

Log on to the console as the root user. Usemysqlusemysql is a database automatically created by the mysql database. Modify the data in the user table updateusersetpasswordPASSWORD (1234) whereuser & 3 log on to the console as the root user.

Use mysqluse mysql is a database automatically created by the mysql database.

Modify data in the user table

update user set password=PASSWORD('1234') where user='root';

Refresh permission

FLUSH PRIVILEGES;

Refer to modifying the mysql User password



Appendix: 1. complete command line operations

mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || ospm               || performance_schema || test               |+--------------------+5 rows in set (0.00 sec)mysql> use mysqlDatabase changedmysql> show tables;+---------------------------+| Tables_in_mysql           |+---------------------------+| columns_priv              || db                        || event                     || func                      || general_log               || help_category             || help_keyword              || help_relation             || help_topic                || host                      || ndb_binlog_index          || plugin                    || proc                      || procs_priv                || proxies_priv              || servers                   || slow_log                  || tables_priv               || time_zone                 || time_zone_leap_second     || time_zone_name            || time_zone_transition      || time_zone_transition_type || user                      |+---------------------------+24 rows in set (0.00 sec)mysql> update user set password=PASSWORD('1234') where user='root';Query OK, 1 row affected (0.02 sec)Rows matched: 1  Changed: 1  Warnings: 0mysql> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec)mysql>