SRA840 Lab7

Milton

1. give and remove user rights

1.1 Give privileges:

grant all on wordpress.* to wordpress@localhost identified by 'password';

1.2 Remove privileges:

flush privileges;

2. create a table

create table table_name (name char(20));

3. insert a few records into the table you created

insert into table_name values('milton');

4. select some of the records in the table you created

select name from table_name;

5. change some of the records into the table you created

6. delete records from the table you created