Skip to main content

修改使用者來源限制

  • 修改使用者來源限制
SHOW COLUMNS FROM `mysql`.`user`;
SELECT `user`, `host`, authentication_string AS `password` FROM `mysql`.`user`;
SHOW GRANTS FOR 'exporter'@'localhost';
RENAME USER 'exporter'@'localhost' TO 'exporter'@'127.0.0.1';
FLUSH PRIVILEGES;