mysql -u root -pmypass;
use mysql;
select host, user, password from user;
create user 'yang'@'localhost' identified by 'yangpass';
drop user 'yang'@'localhost';
create user 'yang'@'%' identified by 'yangpass';
set password for 'yang'@'%' = password('yan');
grant all privileges on yang_test.* to 'yang'@"%";
flush privileges;
create user 'remote'@'%' identifed by 'app';
grant select, delete, update, insert on yang_test.t_weapon to 'remote';
revoke all privileges on yang_test.* from 'yang'@'%';
如对本文有疑问, 点击进行留言回复!!
服务器Centos部署MySql并连接Navicat过程详解
网友评论