CREATE database abook1;
USE abook1;
CREATE TABLE addresses1
(
firstname VARCHAR(20),
lastname VARCHAR(40),
email VARCHAR(40)
);
INSERT INTO addresses1 VALUES ('Hans', 'Meier', '
[email protected]');
INSERT INTO addresses1 VALUES ('Peter', 'Mueller', '
[email protected]');
INSERT INTO addresses1 VALUES ('Stefan', 'Huber', '
[email protected]');
GRANT ALL ON abook1.* TO markus@localhost IDENTIFIED by 'eagle';
CREATE database abook2;
USE abook2;
CREATE TABLE addresses2
(
name VARCHAR(20),
street VARCHAR(40),
city VARCHAR(40),
zipcode VARCHAR(10),
country VARCHAR(30)
);
INSERT INTO addresses2 VALUES ('John Miller', 'treestreet 1', 'Big-City', '11111', 'USA');
INSERT INTO addresses2 VALUES ('Robert Smith', 'birdstreet 2', 'Small-City', '22222', 'New Zealand');
INSERT INTO addresses2 VALUES ('Jim Johnson', 'mammalstreet 3', 'Medium-Citry', '33333', 'Australia');
GRANT ALL ON abook2.* TO markus@localhost IDENTIFIED by 'eagle';
