mysql 数据库访问权限设置,将这个数据库的远程访问及修改权根赋予到这个局域网的某一IP上:
GRANT ALL PRIVILEGES ON *.* TO monty@123.45.67.89
IDENTIFIED BY 'something' WITH GRANT OPTION;
monty 是用户名
123.45.67.89是ip
something是密码
WITH GRANT OPTION 表示可以传递授权
GRANT ALL PRIVILEGES ON *.* TO monty@123.45.67.89
IDENTIFIED BY 'something' WITH GRANT OPTION;
monty 是用户名
123.45.67.89是ip
something是密码
WITH GRANT OPTION 表示可以传递授权