How to Set Up Accounting and Reporting Database in MySQL

1. Log in to the database as a superuser.

   # mysql -u root -p<password>

2. Create user and grant privileges for arco_read and arco_write.

   mysql> GRANT ALL on *.* to 'arco_write'@'<hostname>' identified by '<password>' with GRANT OPTION;
   mysql> GRANT ALL on *.* to 'arco_write'@'localhost' identified by '<password>' with GRANT OPTION;
   mysql> GRANT ALL on *.* to 'arco_write'@'%' identified by '<password>' with GRANT OPTION;
   
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'<hostname>' identified by '<password>';
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'localhost' identified by '<password>';
   mysql> GRANT SELECT,SHOW VIEW on <db_name>.* to 'arco_read'@'%' identified by '<password>';

3. Log in to the database as arco_write user.

   # mysql -u arco_write -p<password>

4. Create the accounting and reporting database.

   mysql> CREATE DATABASE ARCO;

5. Install the Accounting and Reporting Software.