Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

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


Translations Ignore


Code Block
titleMySQL user for customer access
CREATE USER 'kundeclient'@'%' IDENTIFIED BY 'secret';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELWeb.* TO 'kundeclient'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELStats.* TO 'kundeclient'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELStats2.* TO 'kundeclient'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, EXECUTE ON JTELLog.* TO 'kundeclient'@'%';
FLUSH PRIVILEGES;



Access should be assigned to customers on one of the slave databases. 

...