修改root密码:
update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
开启远程访问:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
FLUSH PRIVILEGES;