The following commands create a database user "customer" for read access and execute access. These commands should be executed on the master database, or one of them in the case of replication.

CREATE USER 'customer'@'%' IDENTIFIED WITH mysql_native_password BY 'secret';
GRANT SELECT, CREATE TEMPORARY TABLES, EXECUTE ON JTELWeb.* TO 'customer'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, EXECUTE ON JTELStats.* TO 'customer'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, EXECUTE ON JTELStats2.* TO 'customer'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELLog.* TO 'customer'@'%';
GRANT ALL ON JTELCustomer.* TO 'customer'@'%';
FLUSH PRIVILEGES;

We recommend that the customer access the slave database for most purposes.

  • No labels