制作网站购买主机,百拓公司做网站怎么样,帮别人做网站赚钱,网站建设交流发言稿系统Ubuntu16.04 LTS1、开放3306端口查看端口状态:netstat -an|grep 3306tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN目前只有本机可以访问输入指令:sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf如果之前配置过全局配置文件,也可输入指令:su…系统Ubuntu16.04 LTS1、开放3306端口查看端口状态:netstat -an|grep 3306tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN目前只有本机可以访问输入指令:sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf如果之前配置过全局配置文件,也可输入指令:sudo vim /etc/mysql/my.cnf修改文件,找到下面那行,在bind前面加一个#bind-address 127.0.0.1:wq退出重启MySQL:sudo /etc/init.d/mysql restart[ ok ] Restarting mysql (via systemctl): mysql.service.查看端口状态:netstat -an|grep 3306tcp6 0 0 :::3306 :::* LISTEN至此端口放开了2、下面MySQL新建远程连接用户新建用户名密码开放远程连接(对所有局域网内主机)GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;新建用户名密码开放远程连接(对局域网内指定IP)GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘‘192.168.1.3‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;删除用户use mysql;delete from user where user‘admin‘ and host‘%‘;新建无权限用户:grant usage on *.* to ‘foreigner‘‘%‘ identified by ‘foreigner‘;增加其权限:grant all privileges on db.* to ‘foreigner‘‘%‘;撤回权限:revoke all privileges on db.* from ‘foreigner‘‘%‘;查看权限:mysql show grants for ‘foreigner‘‘%‘;-----------------------------------------------------| Grants for foreigner% |-----------------------------------------------------| GRANT USAGE ON *.* TO ‘foreigner‘‘%‘ || GRANT ALL PRIVILEGES ON soso.* TO ‘foreigner‘‘%‘ |-----------------------------------------------------2 rows in set (0.00 sec)
