开启数据库外部访问

执行sql语句:GRANT ALL PRIVILEGES ON *.* TO [email='myuser'@'192.168.0.101']%27myuser%27@%27192.168.0.101%27[/email] IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

表示允许IP为192.168.0.101的电脑以myuser的账号连接本机数据库,密码为mypassword


版权声明:本文为sinat_35788325原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。