SenecaBBB ========= Seneca BigBlueButton Integration Project # 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_creation.sql mysql -u root -p db < bbb_db_init.sql mysql -u root -p db < bbb_db_sampleData.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'; ```