3、配置远程访问用户 CREATE USER 'ips8000omc'@'%' IDENTIFIED BY 'mxsuccess!';//创建一个用户 GRANT ALL PRIVILEGES ON *.* TO 'ips8000omc'@'%';//配置该用户可以操作所有数据和数据表,并且可远程访问 FLUSH PRIVILEGES;//刷新数据库
ALTER USER 'ips8000omc'@'%' IDENTIFIED WITH mysql_native_password BY 'mxsuccess!';//修改用户登录身份验证为老版本插件 FLUSH PRIVILEGES;//刷新数据库