Difference between revisions of "BBB Integration mysql"
(Created page with ''''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 sud…') |
(No difference)
|
Latest revision as of 19:35, 5 June 2013
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';