Versions Compared

Old Version 14

changes.mady.by.user jtel Support

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: Content imported from a Scroll Translations translation file.
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) mit Passwort "secret" für den Zugriff auf die Datenbank ein. 


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;



Der Zugriff sollte den kunden auf einer der Slave-Datenbanken zugeteilt werden. 

Sv translation
languagefr

Les commandes suivantes créent un utilisateur "client" avec un mot de passe "secret" pour accéder à la base de données. 


Translations Ignore


Code Block
titleUtilisateur MySQL pour l'accès des clients
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;



L'accès doit être attribué aux clients sur l'une des bases de données esclaves.