vim /etc/my.cnf

[client]

port=15099

[mysqld]

port=15099

setenforce 

# 只限本地访问

CREATE USER 'username'@'localhost'  IDENTIFIED BY 'password';

# 外网不限IP地址

CREATE USER 'username'@'%'  IDENTIFIED BY 'password';

#外网指定IP地址

CREATE USER 'username'@'192.168.1.20'  IDENTIFIED BY 'password';

# 指定权限与库表名给指定用户指定地址访问

grant select,update,insert,delete on databasename.tablename to username@'%' identified by 'password';

# 指定全部权限 全部表给 全部访问路径的指定用户

grant all privileges on *.* to 'root'@'localhost' identified by 'password'; 

flush privileges;