Open main menu

CDOT Wiki β

BBB Integration mysql

Setting up DB on Ubuntu 12.04

1) Run these commands to install mysql (note the password you set when installing mysql server)

sudo apt-get install mysql-server

sudo apt-get install mysql-client

sudo apt-get install libmysql-java

2) Edit your mysql configuration file

sudo gedit /etc/mysql/my.cnf

port = 3309 (change all instances of port)

bind-address = local VM ip

3) Restart the mysql service

sudo service mysql restart

4) Connect to mysql-server (use the password you set when installing mysql server)

mysql -u root -p

5) Create the database 'db' then exit

create database db;

6) Download the MySQL script files and run them (from terminal)

mysql -u root -p db < bbb_db_manual.sql

mysql -u root -p db < bbb_db_fn_nextval.sql

mysql -u root -p db < bbb_db_sample_data.sql

7) Connect to mysql-server again

mysql -u root -p

8) Create a user for remote access to DB and grant privileges

create user 'senecaBBB'@'%' identified by 'db';

grant all on db.* to 'senecaBBB'@'%' IDENTIFIED by 'db';