mysql> set global validate_password.policy=low; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> create user 'syslog'@'192.168.%' identified by 'syslogpass' -> ; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on syslog.* to 'syslog'@'192.168.%' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
mysql中grant all privileges on 赋给用户远程权限
© 本文版权归 哇咔咔 所有,任何形式转载需取得作者授权。