1、mysql的配置檔案,my.cnf檔案中,注釋掉bind_address=127.0.0.1
2、開啟權限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
1、mysql的配置檔案,my.cnf檔案中,注釋掉bind_address=127.0.0.1
2、開啟權限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;