1、修改密码:
use mysql;
update user set password=password("123456")where user='root';
flush privileges;
2、允许远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
1、修改密码:
use mysql;
update user set password=password("123456")where user='root';
flush privileges;
2、允许远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;