1、设置参数old_passwords的值
mysql> set old_passwords=0;
Query OK, 0 rows affected (0.26 sec)
2、再次运行OK
mysql> grant all privileges on *.* to root@'%' identified by '123456';
Query OK, 0 rows affected (0.30 sec)
时间:2026-02-12 14:00:01
1、设置参数old_passwords的值
mysql> set old_passwords=0;
Query OK, 0 rows affected (0.26 sec)
2、再次运行OK
mysql> grant all privileges on *.* to root@'%' identified by '123456';
Query OK, 0 rows affected (0.30 sec)