|
1
by brian
clean slate |
1 |
create database d1;
|
2 |
grant all on d1.* to 'sample'@'localhost' identified by 'password';
|
|
3 |
flush privileges;
|
|
4 |
select database();
|
|
5 |
database()
|
|
6 |
d1
|
|
7 |
create database d2;
|
|
8 |
ERROR 42000: Access denied for user 'sample'@'localhost' to database 'd2'
|
|
9 |
create database D1;
|
|
10 |
ERROR 42000: Access denied for user 'sample'@'localhost' to database 'D1'
|
|
11 |
drop user 'sample'@'localhost';
|
|
12 |
drop database if exists d1;
|