新增超级权限并允许远程访问:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; FLUSH PRIVILEGES;
数方法1:
方法1: update mysql.user set authentication_string=password('xxx') where user='root' and Host = 'localhost'; 方法2: mysql> alter user 'root'@'localhost' identified by '123'; 方法3: mysql> set password for 'root'@'localhost'=password('123'); 刷新权限 mysql> flush privileges;