From the CCX dashboard, choose the data store and navigate to the Users and Databases section.
Create a Database
Create a new database, if not exists, in the data store.
Field
Description
Database Name
Specify the database name and click on the Submit button.
Create a Database User
Create a new database user and assign database privileges.
Field
Description
Username
The name of the database user.
Password
The password used to authenticate the database user.
Allowed Host
The host allowed to connect to the database deployment. You may enter % for all hosts, or be specific and specify a certain host that is allowed to connect.
For MariaDB and Percona, you may use % as the wildcard value, e.g:
192.168.0.% – All hosts that the IP address is started with ‘192.168.0.’
app%.mydomain.com = All hosts with the FQDN prefixed with string “app”, followed by any value, and suffixed with “.mydomain.com” value.
For PostgreSQL, specify the CIDR, similar to pg_hba.conf definition, e.g:
192.168.0.11/32 – A single host, with IP address 192.168.0.11.
192.168.0.0/16 – All hosts under the 192.168.0.0 network range.
0.0.0.0/0 – All IPv4 hosts.
Database Name
Select the database this used is allowed to connect to.
Admin User
Toggle if this user is an admin user. The admin user is allowed to create/drop users on the database specified in ‘Database Name’. In MariaDB and Percona data stores, this translates to ALL PRIVILEGES WITH GRANT OPTION on the specific database.
Database Privileges
Specify the privileges for the database user. This option is available if Admin User is not toggled.
User Accounts
In the screenshot, the user ‘dbuser’ is allowed to connect to the database from 192.168.100.23 (the applications server). However, another account is implicitly created by CCX to allow access for this particular user from the load balancers.
If you do not wish this user to have access via the load balancers, then you may delete the account by clicking on the bin icon.