MysqlSchema
A mysql schema
Overview
MysqlSchema:
A mysql schema
Design
- Super Type
- RdbSchema
| Role | Concrete. (Objects can be created.) |
| Instance Names | Unique |
| Notification | false |
| Template Directory | |
| Data View | Children, proximity: 1 |
| Logger Name | MysqlSchema |
Constraints
Allowed Child Dependencies
- MysqlLoadScript
- MysqlPort
- MysqlSetting
- RdbSchemaName
- RdbSchemaPassword
- RdbSchemaUserName
Allowed Parent Dependencies
- MysqlRdb
- Node
Allowed Property Values
| Property | Allowed Values | Default | Enforced |
|---|---|---|---|
| manages-deployments |
|
true |
Commands
Note
Commandline options displayed in square brackets "[]" are optional. If an option expects arguments, then angle brackets are shown after the option "<>". Any default value is shown within the brackets.
createSchema
creates the schema
- Usage
- createSchema [-basedir <>] [-loadscript <>]
Options
| Option | Description |
|---|---|
| basedir | instance dir |
| loadscript | sql script |
grantSchema
grants access to the schema
- Usage
- grantSchema [-basedir <>] [-pass <>] [-rdbclients <localhost>] [-schemaname <>] [-user <>]
Options
| Option | Description |
|---|---|
| basedir | instance dir |
| pass | user pass |
| rdbclients | allowed client nodes |
| schemaname | name of db schema |
| user | user name |