以mysql 5.6版本为例：
1.mysql连接：
转到mysql/bin 下:使用下面命令:
mysql -hlocalhost -uroot -p
输入密码，进入mysql后：使用mysql表;
use mysql
建立用户，赋予权限;
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT privileges ON databasename.tablename TO 'username'@'host' identified by '';
例如:grant all privileges on . to remote@'%' identified by '';
Paste_Image.png
权限刷新：
flush privileges;
Paste_Image.png
Paste_Image.png
