Amazon RDS for MariaDB

Authorize to Connect the Database

This permission must be granted already when the user is created. However, if the user is not authorized to establish a connection, you can use the below command to create a new user and granting basic privileges. Privileges must be assigned to both the local host and the percent character (%) is used to give access remotely from any client machine. For more information, refer to MySQL Documentation.

The FLUSH PRIVILEGES command make the changes immediately available without restarting the MySQL service.

USE <SCHEMA>;
 GRANT USAGE ON *.* TO '<UID>'@'localhost' IDENTIFIED BY '<PWD>';
 GRANT USAGE ON *.* TO '<UID>'@'%' IDENTIFIED BY '<PWD>';
 FLUSH PRIVILEGES;

USE mysql;
 GRANT USAGE ON *.* TO 'sdruser'@'localhost' IDENTIFIED BY 'sdruser';
 GRANT USAGE ON *.* TO 'sdruser'@'%' IDENTIFIED BY 'sdruser';
 FLUSH PRIVILEGES;

where sdruser is the User ID and mysql is the schema.

Authorize to Select Catalog

No additional permissions required.

Not applicable

Not applicable

Authorize to Select Tables

Required for schemas other than the one for which the CONNECT_DB permission has been granted (the user has the Read permission already).

GRANT SELECT ON <SCHEMA>.<TABLE> TO '<UID>'@'localhost';
 GRANT SELECT ON <SCHEMA>.<TABLE> TO '<UID>'@'%';
 FLUSH PRIVILEGES;

GRANT SELECT ON mysql.Table1 TO 'sdruser'@'localhost';
 GRANT SELECT ON mysql.Table1 TO 'sdruser'@'%';
 FLUSH PRIVILEGES;

where sdruser is the User ID and mysql is the schema.

Authorize to Create Tables

To create a target table in the Management Center (as part of the Create Table Wizard), Syniti Replicate requires permissions to modify the database schema. MySQL allows you to grant privileges even on database objects that do not exist. In such cases, the privileges to be granted must include the CREATE privilege.

This behavior is designed to enable the database administrator to prepare user accounts and privileges for database objects that are to be created at a later time. For more information. refer to MySQL: Grant Statement.

GRANT CREATE ON <SCHEMA>.<TABLE> TO '<UID>'@'localhost';
 GRANT CREATE ON <SCHEMA>.<TABLE> TO '<UID>'@'%';
 FLUSH PRIVILEGES;

Alternatively, you can run the following command using the asterisk (*) wildcard:

GRANT CREATE ON <SCHEMA>.* TO '<UID>'@'localhost';
 GRANT CREATE ON <SCHEMA>.* TO '<UID>'@'%';
 FLUSH PRIVILEGES;

GRANT CREATE ON mysql.Table1 TO 'sdruser'@'localhost';
 GRANT CREATE ON mysql.Table1.* TO 'sdruser'@'%';
 FLUSH PRIVILEGES;

where sdruser is the User ID and mysql is the schema.

Authorize to Update Tables

To create a target table in the Management Center (as part of the Create Table Wizard), Syniti Replicate requires write permissions to the database. This command is needed for schemas other than the one on which the CONNECT_DB permission has been granted (where the user has the Write permission already).

GRANT INSERT, UPDATE, DELETE ON <SCHEMA>.<TABLE> TO '<UID>'@'localhost';
 GRANT INSERT, UPDATE, DELETE ON <SCHEMA>.<TABLE> TO '<UID>'@'%';
 FLUSH PRIVILEGES;

GRANT INSERT, UPDATE, DELETE ON mysql.Table1 TO 'sdruser'@'localhost';
 GRANT INSERT, UPDATE, DELETE ON mysql.Table1 TO 'sdruser'@'%';
 FLUSH PRIVILEGES;

where sdruser is the User ID and mysql is the schema.

Authorize to Drop or Alter Tables (Optional)

The use of these commands in Syniti Replicate is entirely optional (not necessary for running a refresh replication).

They are used if you choose to remove a table from MySQL or change the table via the Management Center SQL Query tab. This syntax can be used for schemas other than the one for which the CONNECT_DB permission has been granted (where the user has the Drop Table permission already).

GRANT DROP ON <SCHEMA>.<TABLE> TO '<UID>'@'localhost';
 GRANT DROP ON <SCHEMA>.<TABLE> TO '<UID>'@'%';
 FLUSH PRIVILEGES;

GRANT DROP ON mysql.Table1 TO 'sdruser'@'localhost';
 GRANT DROP ON mysql.Table1 TO 'sdruser'@'%';
 FLUSH PRIVILEGES;

where sdruser is the User ID and mysql is the schema.

Data Source

The name of network address of the instance of RDS for MariaDB to connect

User ID

Database User ID

Password

User password

Database

The name of the database to use initially.

Connect Timeout

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error.

Protocol

Specifies the type of connection to make to the server. Values can be socket or tcp for a socket connection, pipe for a named pipe connection, unix for a Unix socket connection, or memory to use MySQL shared memory.

Port

The MySQL port is used to listen for connections. Specify -1 for this value to use a named pipe connection (windows only). This value is ignored if Unix socket is used.

Shared Memory Name

The name of the shared memory object to use for communication if the connection protocol is set to memory.

Pipe Name

When set to the name of a named pipe, the MySqlConnection will attempt to connect to MySQL on that name pipe.

Character Set

Specifies the character set that should be used to encode all queries sent to the server. Resultsets are still returned in the character set of the data returned.

Logging

When True, various pieces of information is output to any configured TraceListener.

Allow Batch

When True, multiple SQL statements can be set with one command execution.

Allow Zero Datetime

True to have MySqlDataReader.Getvalue() return a MySqlDateTime for date or datetime columns that have illegal values.

False will cause a DataTime object to be returned for legal values and an exception will be thrown for illegal values.

Covert Zero Datetime

True to have MySqlDataReader.Getvalue() and MySqlDataReader.GetDataTime() return DateTime.MinValue for date or datetime columns that have disallowed values. For this property to be effective you need Allow Zero Datetime property set to True as well.

AllowLoadLocalInfile

If set to True, the server permits local data loading by clients that request local data loading (used in Syniti Replicate during bulk operations).

If set to False, the refresh bulk and the mirroring bulk operations using this connection as target will not be allowed.

Connection Lifetime

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the values specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online. A value of zero (0) causes pooled connections to have the maximum connection timeout.

Pooling

When True, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to appropriate pool.

Max Pool Size

The maximum number of connections allowed in the pool.

Min Pool Size

The minimum number of connections allowed in the pool.

ExtendedProperties

Additional properties no listed in the grid. Enter the properties as a list of "property = value" string separated by (;).

Bit

bit

Smallint

smallint, tinyint, year

Tinyint

tinyint

Integer

int, integer, mediumint

Bigint

bigint

Float

float

Double

double, double precision

Real

real

Numeric

numeric

Decimal

decimal

Char

char, enum

Varchar

varchar, tinytext, set

LongVarchar

text, mediumtext

Clob

longtext

Varbinary maxVersion="4.0001.0001"

tinyblob

Varbinary

varbinary, tinyblob

Binary maxVersion="4.0001.0001"

tinyblob

Binary

binary, tinyblob

LongVarbinary

blob, mediumblob

Blob

longblob

Date

date

Time

time

Smalldatetime

datetime

Timestamp

datetime, timestamp

AutoDecimal

double

AutoNumeric

double

AutoTinyint

tinyint

AutoInteger

int

AutoSmallint

smallint

NChar

char

NVarchar

varchar

NText

longtext

Sysname

varchar(128)

Money

double

Smallmoney

decimal(10,2)

GUID

varchar(40)

Number

double

TimestampZ

timestamp

TimeInterval

datetime

Set

varchar(1024)

Xml

longtext

Json maxVersion="5.0007.0007"

longtext

Json minVersion="5.0007.0008"

json