Users and Databases

Users

This section has all the existing users in the environment.

You can see the following information from each user:

• Account: The username.
• Privileges: The privileges assigned to the account.
• Connection String example: A basic connection string example.

In the “Actions” section you will see the button to delete the existing user.

Databases

This section has all the databases created in the environment.

You can see the following information from each database:

• Database Name
• Size
• Tables

Connection Assistant

Configure your connection strings for your database using the Connection Assistant.

Select the following connection options:

• Account
• Database Name
• Host

And as the result, you will see a connection string example for different methods, like:

• DNS
• ADO.NET
• JDBC
• Node.js
• ODBC
• PHP
• Python
• Ruby
• Go

Add New User

CCX will create a new database user using this option, and for this, it will ask you some basic information:

• Username: The new username to be created.
• Password: The password for the new user.
• Allowed Host: The host that the user is allowed to connect from.
• Database Name: Select the database to access with the new user.
• Admin User: Toggle this button to create an Admin User.
• Database Privileges: Specify the privileges for the new user. The options are SELECT, INSERT, DELETE, UPDATE, DROP, or CREATE for PXC and MariaDB, and adding TRUNCATE, REFERENCES, TRIGGER for PostgreSQL.

Add New Database

Create a new database on this cluster.