遠(yuǎn)程安全組要打開3306端口械巡,
本地創(chuàng)建用戶的時候用的語句:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'230.125.189.54' IDENTIFIED BY '123'党涕,
其中230.125.289.54位公網(wǎng)ip;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'newpass' WITH GRANT OPTION; flush privileges;這是完成開權(quán)限遠(yuǎn)程的寫法