登录root用户
用root用户登录控制台。
use mysql
use mysql,mysql是mysql数据库自动创建的一个数据库。
修改user表的数据
update user
set password=PASSWORD('1234')
where user='root';
Salin selepas log masuk
刷新权限
FLUSH PRIVILEGES;
Salin selepas log masuk
参考
修改mysql用户密码
附: 1、完整的命令行操作
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ospm |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> use mysql
Database changed
mysql> 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: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>
Salin selepas log masuk