方法一:用set password命令
首先,登录MySQL(刚安装默认没有密码):
命令格式:set password for 用户名@localhost = password('新密码');
例子: set password for root@localhost = password('123');
方法二:update 更新user表
步骤一:登录MySQL
步骤二: mysql>use mysql;
步骤三: mysql> update user set password=password('123') where user='root' and host='localhost';
步骤四: mysql> flush privileges;