In this subsection you find out the details useful for your DB account
Please note that for Database account you can either use root as user with its corresponding password or a new user needs to be created.
CREATE USER 'my_user'@'127.0.0.1' IDENTIFIED BY 'my_password';
GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'my_user'@'127.0.0.1';
FLUSH PRIVILEGES;
This step is valid for FREE version only.
If you use a PREMIUM version, i.e. you have the possibility to RESTORE or CLONE your DB, please add the following line:
GRANT CREATE, INSERT ON *.* TO 'my_user'@'127.0.0.1';
Use 127.0.0.1 is fine WITHOUT DOCKER, and if the host specified in the setup is 127.0.0.1, otherwise, the appropriate IP should be used. With Docker, 127.0.0.1 becomes %
CREATE USER 'my_user'@'127.0.0.1' IDENTIFIED BY 'my_password';
GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'my_user'@'127.0.0.1';
GRANT SELECT ON performance_schema.log_status TO 'my_user'@'127.0.0.1';
GRANT SELECT ON performance_schema.keyring_component_status TO 'my_user'@'127.0.0.1';
GRANT SELECT ON performance_schema.replication_group_members TO 'my_user'@'127.0.0.1';
FLUSH PRIVILEGES;
If you use a PREMIUM version, i.e. you have the possibility to RESTORE or CLONE your DB, please add the following line:
GRANT CREATE, INSERT ON *.* TO 'my_user'@'127.0.0.1';
CREATE USER 'my_user'@'127.0.0.1' IDENTIFIED BY 'my_password';
GRANT RELOAD, PROCESS, LOCK TABLES, BINLOG MONITOR ON *.* TO 'my_user'@'127.0.0.1';
FLUSH PRIVILEGES;
If you use a PREMIUM version, i.e. you have the possibility to RESTORE or CLONE your DB, please add the following line:
GRANT CREATE, INSERT ON *.* TO 'my_user'@'127.0.0.1';
CREATE USER 'my_user'@'127.0.0.1' IDENTIFIED BY 'my_password';
GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'my_user'@'127.0.0.1';
FLUSH PRIVILEGES;
If you use a PREMIUM version, i.e. you have the possibility to RESTORE or CLONE your DB, please add the following line:
GRANT CREATE, INSERT ON *.* TO 'my_user'@'127.0.0.1';