Relational Databases
From Gridkaschool
Contents
General information
ssh reldb@gks-virt(050-061).scc.kit.edu -p24
Session 1 - Setup
$ mysql -u root mysql> show databases; mysql> create database playground; mysql> show databases; CTRL-D $ sudo ls -la /var/lib/mysql/ $ sudo ls -la /var/lib/mysql/playground $ sudo ls -la /var/lib/mysql/mysql $ mysql -u root mysql> use mysql; mysql> show tables; mysql> select * from user; mysql> create user 'joffrey' identified by 'kings_landing'; mysql> create user 'joffrey'@'localhost' identified by 'kings_landing'; mysql> create user 'hodor' identified by 'hodor'; mysql> create user 'hodor'@'localhost' identified by 'hodor'; mysql> select * from user; mysql> drop user 'joffrey'; mysql> drop user 'hodor'; mysql> select * from user; CTRL-D $ mysql -u hodor -p mysql> use playground; CTRL-D $ mysql -u root mysql> show grants; mysql> grant all privileges on playground.* to 'joffrey'@'localhost'; CTRL-D $ mysql -u joffrey mysql> show grants; CTRL-D