Versions Compared

Old Version 11

changes.mady.by.user jtel Support

Saved on

compared with

New Version 12

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 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.

Translations Ignore


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


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

Sv translation
languagede

Status
colourRed
titleThis page is only available in English

Sv translation
languagefr

Les commandes suivantes permettent de créer un "client" utilisateur de la base de données pour l'accès en lecture et l'accès en exécution. Ces commandes doivent être exécutées sur la base de données principale, ou sur l'une d'entre elles en cas de réplication.

Translations Ignore


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


Nous recommandons au client d'accéder à la base de données des esclaves pour la plupart de ses besoins.