The following commands create a user "client" with password "secret" to access the database. 



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.