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