cs222p-2018-fall: setup-mysql.txt

Simple instructions to setup a MySQL database on 64-bit Ubuntu.

Prepared by Prof. Chen Li for UCI course 'Principles of Data Management.'

shell> sudo apt-get update
shell> sudo apt-get install mysql-server
shell> sudo apt-get install mysql-client

shell> mysql -u root -p

mysql> CREATE USER 'mytestuser'@'localhost' IDENTIFIED BY 'mypassword';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'mytestuser'@'localhost';

mysql> create database moviedb;
mysql> use moviedb;

mysql>  create table stars(
             id integer primary key,
             first_name varchar(50),
             last_name varchar(50),
             dob date,
             photo_url varchar(200)
             );
                 
mysql> INSERT INTO stars VALUES(755011, 'Arnold', 'Schwarzeneggar', '1947/07/30', 'http://www.imdb.com/gallery/granitz/2028/Events/2028/ArnoldSchw_Grani_1252920_400.jpg?path=pgallery&path_key=Schwarzenegger,%20Arnold');
                 
mysql> INSERT INTO stars VALUES(755017, 'Eddie', 'Murphy', '1961/04/03', 'http://www.imdb.com/gallery/granitz/2487/Events/2487/EddieMurph_Pimen_2724994_400.jpg?path=pgallery&path_key=Murphy,%20Eddie%20(I)');

mysql> select * from stars;
mysql> exit

shell> mysql -u mytestuser -p
mysql> use moviedb;
mysql> select * from stars;