Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Configuring the MySQL database

  1. Create databases for the platform and the application.

E.g.: The following command is used to create the database xxcloudio:

create database xxcloudio;

2. Create a user to access the databases.

E.g.: The following command is used to create a user for the database xxcloudio:

create user xxcloudio@localhost IDENTIFIED BY PasswordForUser;

Note

If you want to access this remotely, then replace localhost with '%'

3. Grant the user privileges required to work with the databases.

E.g.: The following command is used to grant the user privileges for the database xxcloudio:

grant all privileges on xxcloudio.* to xxcloudio_qa@localhost

Note

If you want to give access to all the databases, then replace Database with *. If you want to give access to all the tables of database, then replace Table with *.

E.g.: The following command is used to grant the users, the privileges to all the databases and tables.

"grant all privileges on *.* to 'xxcloudio_qa'@'%"

Last updated