The following commands create a user "kunde" with password "secret" to access the database.
MySQL user for customer access
CREATE USER 'kunde'@'%' IDENTIFIED BY 'secret'; GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELWeb.* TO 'kunde'@'%'; GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELStats.* TO 'kunde'@'%'; GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELStats2.* TO 'kunde'@'%'; GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELLog.* TO 'kunde'@'%'; FLUSH PRIVILEGES;
Access should be assigned to customers on one of the slave databases.