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'@'%"