Mysql远程访问
被访问电脑设置:
登陆mysql(mysql –u用户名–p用户密码)
输入use mysql
增加新用户
格式:grant权限 on 数据库.* to 用户名@登陆主机ip identified by ‘mysql密码’ with grant option;
如grant all privileges on *.* to ‘roor’@'localhost' identified by‘mysql密码’ with grant option;
如grant all privileges on *.* to ‘root’@‘192.168.2.1’identified by ‘mysql密码’ with grantoption;
如果希望该用户能够在任何机器上登陆mysql,则将localhost改为‘%’。
flush privileges;
访问电脑访问命令:
Mysql –h登陆主机IP –uroot -p登陆主机mysql密码