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

4. select some of the records in the table you created 5. change some of the records into the table you created 6. delete records from the table you created