...
Expand | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Supported versionsMySQL Community Server versions 5.6.x and 5.7.x. Prerequisites
Configure the MySQL Database1. Log in to your MySQL Server.Open the Command Prompt on the computer where MySQL Community Server is installed and navigate to the MySQL installation folder (for example, C:\Program Files\MySQL\MySQL Server 5.67\bin) Connect to your MySQL server using the following command:
In this example, the username is root. In a new MySQL instance, root is the default user and can be logged in without a password. If you are using an existing MySQL Server instance, the username and password may be different. 2. Create a new user for Zephyr.Create a new user whose credentials Zephyr will use to connect to the database and set a user password. To do that, use the following command:
3. Set permissions for remote access.Type the command below to make the database accessible remotely:
where zephyrDBuser is the username and ZephyrDBuserPass is the password of the user created at step 2. When installing a database for a Data Center cluster, you need to grant permissions for each node in the cluster.
Now you an access your MySQL database remotely from the designated IPs. 4. Set the amount of memory to be used and the maximum number of connections.Open the my.ini file (Windows) or my.cnf (Linux). The default location is the MySQL root folder.
If no lines contain these parameters, then create new lines for them.
|
Expand | ||
---|---|---|
| ||
Supported Databases
Prerequisites
Configure the Microsoft SQL Server DatabaseStep 1. Create a user account with relevant permissions.In Object Explorer, expand the folder of the server instance in which you want to create a new login. In the Login – New dialog box, on the General page, enter the name of a user in the Login name box. To create a login that is saved on a SQL Server database, select SQL Server authentication. In the Password box, enter a password for the new user. Enter that password again in the Confirm password box: From the Default database list, select a default database for the login. Master is the default for this option. Next, you need to set permissions for this login. Right click the user and select Properties: In the Properties window, grant permissions for the user to Alter any database: The Effective tab will show the minimum permissions that must be provided: You have created a new Login user with the appropriate permissions. Step 2. Set permissions for remote access.In this step, we will enable remote connections on the SQL Server instance that you want to connect to from a remote computer. Staying within SQL Server Management Studio, right-click the server name in the left pane and select Properties:
Now, you need to enable the TCP/IP protocol. To do that, open SQL Server Configuration Manager, expand SQL Server Network Configuration and click Protocols for SQLEXPRESS. Check the status to ensure that the TCP/IP protocol is enabled. If it is disabled right-click on TCP/IP and select Enable: Select Properties from the same pop-up menu. Now, click the IP Addresses tab, scroll-down to the APAll section, and enter the port 1433 for TCP Port: Now you can start the SQL Server service.
Step 3. Turn on the SQL Server Browser service.Open SQL Server Configuration Manager, click SQL Server Services in the left pane, right-click SQL Server Browser service and select Properties. In the subsequent window, switch to the Service tab, click Start Mode, and select Automatic from the drop-down menu: Switch to the Log On tab and click Start to start the SQL Browser service.
Step 4. Configure the firewall to allow network traffic.Configure the firewall to allow network traffic related to the SQL Server and to the SQL Server Browser service. The following port exceptions should be set: A port exception for TCP port 1433: In the New Inbound Rule Wizard of your firewall, do the following to create a port exception:
A port exception for UDP port 1434: Click New Inbound Rule again and do the following:
Step 5. Set up authenticationIn SQL Server Management Studio, right-click the server name in the left pane and select Properties. In the subsequent window, select Security in the pane on the left, then select SQL Server and Windows Authentication mode in the Server authentication section, and click OK: Your database is ready to be used.
|
Expand | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
Supported Databases
Prerequisites
Configure the Oracle DatabaseStep 1: After you install Oracle Database, set collation and DB parameters:The default collation is binary for Oracle, and the one that is supported. The following query can be used to validate the collation for the user (database):
To configure the database, connect through the command console:Type : sqlplus Run the commands below to set up Oracle database parameters:
Step 2: Set up your database charset:
Step 3: Connect to the database in Oracle SQL Developer:User creationCreate a table space:
Create an Oracle user:
If you face issues with the table space, try doing the following: for data files below, find the path of data files and use path value and replace the value "<example>/u01/app/oracle/oradata/XE/system.dbf<example>" below.
|
...