You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Current »

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. 

  • No labels