MySQL開啟root遠程訪問權限
允許任何IP使用 root 賬戶,口令8個1遠程訪問
方法1
Sql代碼
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '11111111' WITH GRANT OPTION;
方法2
Sql代碼
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
作者 lj6684