可以使用Navicat登录管理员账户,新建一个用户并对用户授权,如下:
grant all privileges on *.* TO 'root'@'%' identified by 'root' with grant option;
flush privileges;
实例:
grant all privileges on *.* TO 'root'@'10.88.5.211' identified by 'root123456' with grant option;
FLUSH PRIVILEGES;