1. Home
  2. Docs
  3. CCX
  4. How-To
  5. Database Access
  6. Creating Databases and Users

Creating Databases and Users

Create a Database

From the CCX dashboard, choose the data store and navigate to the Databases section.

Create a new database, if does not exist, in the data store.

Field Description
Database Name
  • Specify the database name and click on the Create button.

Create a Database User

From the CCX dashboard, choose the data store and navigate to the Users section. Click the Create Admin user button:

Create a new database user and assign database privileges.

Field Description
Username
  • The name of the database user.
Password
  • The password is used to authenticate the database user.
Database Name
  • Select the database this user is allowed to connect to.
Authentication plugin
  • This option is only available for MariaDB databases. Currently, there are two options:
    • caching_sha2_password.
    • mysql_native_password
Note

However, this is fields are different with each CCX-supported database software.

User Accounts

In the screenshot, the user ‘dbuser’ is allowed to connect to the database. With default privileges of CREATE USER(Global Privileges) and ALL PRIVILEGES and GRANT OPTION on the WordPress database. However, this is different with each CCX-supported database software.

If you wish at any time for this user to have no access, then you can delete the account by clicking on the bin icon.

Connection assistant

From the CCX dashboard, choose the data store and navigate to the Users section. Click the Connection assistant button:

Configure your connection strings for your database.

Field Description
Db user Select the database user to be used.
Database name Select the database you want to connect to.
Endpoint Currently, the only option is primary.
Technology Select the connection driver. These are the drivers currently supported:

  • DSN
  • ADO.NET
  • JDBC
  • NODE.JS
  • ODBC
  • PHP
  • PHP.PDO
  • PHP.PEAR.DB
  • PYTHON
  • RUBY
  • GO

 

Was this article helpful to you? Yes No