2.3.7. MySQL Database for Sequoia ERP

Install MySQL first in order to install Sequoia ERP with MySQL. Please consult the process for installing MySQL in this manual. After installing MySQL, create a database for Sequoia ERP.

 

In order to create a MySQL database, access it with the following command:


$ mysql -u root -h 127.0.0.1 -p <root-password>


Create the database:


mysql> create database sequoia;

mysql> create user sequoia;

mysql> grant all privileges on sequoia.* to 'sequoia'@'localhost' identified by 'sequoia-password' with grant option;

 

Quit the MySQL client, and try to access the Sequoia database with your Sequoia user:


$ mysql -h 127.0.0.1 -u sequoia -p <sequoia-password>

mysql> use sequoia;