计算机科学系实验报告
实验要求: (在导入的教学管理STM数据库中完成):
1、用户的创建
①利用CREATE USER语句创建用户user1、user2、user3,密码均为’123456’。 CREATE USER 'user1'@'localhost'IDENTIFIED BY '123456',
'user2'@'localhost'IDENTIFIED BY '123456',
'user3'@'localhost'IDENTIFIED BY '123456';
②利用INSERT INTO语句向USER表创建用户user4,密码均为’123456’。
INSERT INTO http://doc.docsou.comer(HOST,USER,PASSWORD,ssl_cipher,x509_issuer,x509_subject) VALUES ('localhost','user4',PASSWORD('123456'),'','','');
FLUSH PRIVILEGES;
③利用GRANT语句创建用户user5,密码均为’123456’,且为全局级用户。 GRANT ALL PRIVILEGES ON *.* TO 'user5'@'localhost' IDENTIFIED BY '123456';
2、用户授权(利用GRANT语句)
①授予user1用户为数据库级用户,对STM拥有所有权。
GRANT ALL PRIVILEGES ON stm.* TO 'user1'@'localhost'