MySQL创建用户，并赋予表权限

#允许本地访问的用户（127.0.0.1）
mysql> create user see_yong@localhost identified by 'see_yong1'; 
 
# 允许外网IP访问的用户
mysql> create user 'see_yong'@'%' identified by 'see_yong1';

# 授予用户在本地服务器对该数据库的全部权限
mysql> grant all privileges on dbname.* to see_yong@localhost identified by 'see_yong1';

#授予用户通过外网IP对于该数据库的全部权限
mysql> grant all privileges on dbname.* to 'see_yong'@'%' identified by 'see_yong1';

#刷新权限
mysql> flush privileges;  

#授予用户通过外网IP访问所有数据库的的全部权限
mysql> GRANT ALL PRIVILEGES ON  *.* TO 'see_yong'@'%' IDENTIFIED BY 'see_yong1';