CREATE USER 'exporter'@'localhost' IDENTIFIED BY 'XXXXXXXX' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost';
Won't work with --mysqld.address defaulted as localhost:3306 as --mysqld.address will try to connect to 127.0.0.1, which is the address for localhost, but for mysqld localhost, in CREATE USER and GRANT is the unix socket.
So :
CREATE USER 'exporter'@'127.0.0.1' IDENTIFIED BY 'XXXXXXXX' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'127.0.0.1';
works better.
Won't work with
--mysqld.addressdefaulted aslocalhost:3306as--mysqld.addresswill try to connect to 127.0.0.1, which is the address for localhost, but for mysqld localhost, in CREATE USER and GRANT is the unix socket.So :
works better.