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