登录root用户

用root用户登录控制台。

use mysql

use mysql，mysql是mysql数据库自动创建的一个数据库。

修改user表的数据

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

刷新权限

FLUSH PRIVILEGES;

参考

修改mysql用户密码



附： 1、完整的命令行操作

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>