1
edit
Changes
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…'
'''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';
'''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';
