Permissions for MySQL
For the automatic schema migration or DDL schema methods to work, you must assign the proper permissions to the DB Login User that is used to connect from the Traveler Server.
Automatic schema migrations
- The DB Login User's From Host needs to include the Traveler Server.
-
CREATE, ALTER, INDEX, DROP
- INSERT, UPDATE, SELECT and DELETE
DDL schema
- The DB Login User's From Host needs to include the Traveler Servers.
- INSERT, UPDATE, SELECT and DELETE
No other specific permissions are required. The LNTUSER does not include any schema privileges. As a result, this user will not be able to alter the schema. Additional database permissions are required for tell traveler dbmaint to execute the database actions. The user needs the following permissions:
- CREATE, ALTER, INDEX, DROP