Versions Compared

Old Version 2

changes.mady.by.user user-45924

Saved on

compared with

New Version Current

changes.mady.by.user jtel Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed translated content for 'fr'
Sv translation
languageen

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


Translations Ignore


Code Block
titleMySQL 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. 

Sv translation
languagede

Folgende Befehle legen ein User "client"(kunde

...

User für Kunden-Zugriff

) mit Passwort "secret" für den Zugriff auf die Datenbank ein. 


Translations Ignore


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



Der Zugriff sollte den

...

kunden auf einer der Slave-Datenbanken zugeteilt werden.