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