...
width | 70% |
---|
Essentials
...
...
- granting access to the root user from any server/host by using the wildcard syntax % as the host name
- see the Remote Privileges section below...
- granting access to the root user from the specific hosts you know you will run Flow and/or other BL apps on (Eg. RSS Reader, Weather Reader, etc)
- creating a new user with the required privileges
...
language | sql |
---|---|
title | Create new user |
...
...
...
Remote Privileges and Granting Player Access to the DB
During the MySQL install, the user will be asked if they would like to allow remote access for the root user. It is important to allow this so that players, and other apps that are not running on the master server can access the database. If the players are having a problem accessing the database from remote systems use the following commands to enable non-local access for the root user account.
Code Block | ||||
---|---|---|---|---|
| ||||
UPDATE mysql.user SET host = '%' WHERE host = '127.0.0.1' AND user == 'root';
FLUSH PRIVILEGES; |
Required Privileges
You may create a single user that provides access for both Flow and any other BL apps you are using.
Flow
Flow requires an extensive set of privileges to allow it to update the database schema during installation and/or upgrades as well as managing the data in use.
Code Block | ||||
---|---|---|---|---|
| ||||
GRANT
ALTER,
ALTER ROUTINE,
CREATE,
CREATE ROUTINE,
CREATE TEMPORARY TABLES,
CREATE VIEW,
DELETE,
DROP,
EXECUTE,
INDEX,
INSERT,
LOCK TABLES,
SELECT,
SHOW VIEW,
TRIGGER,
UPDATE
ON superticker.* -- to superticker tables only
TO 'BL'; |
BL Apps
You could use the same user for both Flow and the BL apps. If you wish to separate them note that most BL apps run with a much more limited privilege requirements.
Code Block | ||||
---|---|---|---|---|
| ||||
GRANT
DELETE,
EXECUTE,
INSERT,
LOCK TABLES,
SELECT,
TRIGGER,
UPDATE
ON superticker.* -- to superticker tables only
TO 'BL'; |
Suspending Privileges
You may want to temporarily disable the access to the database. In that case you would use a REVOKE command:
Code Block | ||||
---|---|---|---|---|
| ||||
REVOKE ALL PRIVILEGES ON superticker.* FROM 'BL'; |
Replication Privileges
In situations where you want to use replication to provide a ongoing backup source you need additional privileges.
...
...
...
...
...
...
...
...
Replication Monitoring
The DMan app can be used in scenarios with replication to provide status monitoring. To do so it will require the additional privilege
- REPLICATION CLIENT
...
...
...
...
...
...
...
...
In this section:
...
borderColor | #0070b1 |
---|---|
bgColor | #FFFFFF |
borderWidth | 1 |
...
indent | 15px |
---|
...
...