Page History

Sv translation

language	en

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'@'%';
GRANT ALL ON JTELCustomer.* TO 'customer'@'%';
FLUSH PRIVILEGES;

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

Sv translation

language	de

Status

colour	Red
title	This page is only available in English

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;

Sv translation

language	fr

Translations Ignore

Code Block

Page tree

Versions Compared

Old Version 5

New Version Current

Key