• Table of Contents
• Print Version
• Code Documentation
• spunQ Blog
• spunQ.com

Database Creation - mySQL specific

Login to MySQL as root:
# mysql -u root -p

Create a database for this project:
mysql> CREATE DATABASE spunq_db; // or an other database-name according to your setup

Create a user with all permissions to create and modify tables:
mysql> GRANT ALL PRIVILEGES ON spunq_db.* TO spunq_adm@localhost identified by 'pwd'
mysql> GRANT SELECT ON spunq_db.* TO spunq_web@localhost identified by 'pwd'

Leave the MySQL and fill the database with the provided dump:

cd backend/install/
mysql -u root -p spunq_db < spunq_db_mysql.dump

Tags

Related Subjects

Do you need additional information?