Difference between revisions of "SRA840 Lab7"
Milton.paiva (talk | contribs) (→Milton) |
Milton.paiva (talk | contribs) (→Milton) |
||
| Line 1: | Line 1: | ||
= Milton = | = 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 | ||
Revision as of 16:25, 11 April 2009
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
