Class Exercise: MySQL User and Table Administration Objective: Show how to use the MySQL client (aka monitor) for command prompt interaction with the MySQL database management system. (Note: use a semicolon as a statement terminator.) 0. Login as the root user. type: mysql -u root; 1. Check user and password settings: type: use mysql; select host,user,password from user; 2. Set passwords. type: set password for root@localhost = password('new-password'); (It is also recommended to set the password for pma--PHPMyAdmin and other users.) 3. Drop anonymous users. type drop user ''@hostName; --note substitute localhost or other hostName 4. Create a database for development. type: create database databaseName; 5. Set up a regular developer account to create and manipulate tables in the database created(i.e. to avoid risks when working as root). Type: grant all|create, insert, ... on databaseName.* to 'userName'@'localhost' identified by 'password'): 6. Logout (exit, quit) and login as a regular user. Type: exit; mysql -u userName -p 7. Issue a command to use your database. Type: use databaseName; 8. Show how to enter SQL commands to create a table, insert data into the table, then select, update, and delete data from the table(see "File Operations"). 9. Rename the table created. Type alter table tableName rename to newTableName; A. Describe the column or field properties for the table created. Type show create table tableName; B. Use the alter command to modify a table attribute. Type: alter table tableName modify columnName columnType); C. Exit mysql.