Lab 6 -25082009-

Today’s lab is about database security.


First of all, MySQL Front and server is installed. After it is successfully installed, sql command is need in order to connect to MySQL server.


In order to change password, use this command: SET PASSWORD FOR root@localhost = OLD_PASSWORD (‘123456’); when the password is successfully changed, OK message will be displayed.


After that, we are asked to create table in the database. All attribute and data type is created in the table. Then, we need to secure the database by protecting information in statistical database and examine the potential interaction between security mechanisms in the database management system. Besides, we also need to define the access right for each row of the table.