以mysql 5.6版本為例：
1.mysql連接：
轉(zhuǎn)到mysql/bin 下:使用下面命令:
mysql -hlocalhost -uroot -p
輸入密碼，進(jìn)入mysql后：使用mysql表;
use mysql
建立用戶耗拓，賦予權(quán)限;
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
權(quán)限刷新：
flush privileges;
Paste_Image.png
Paste_Image.png
