依次执行以下三条语句即可
创建远程访问用户:(username为远程登录的用户名,password为对应的密码,“%”为允许所有ip及ip的占位符)
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
进行远程访问权限授权
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
刷新权限
FLUSH PRIVILEGES;
依次执行以下三条语句即可
创建远程访问用户:(username为远程登录的用户名,password为对应的密码,“%”为允许所有ip及ip的占位符)
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
进行远程访问权限授权
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
刷新权限
FLUSH PRIVILEGES;