1 2 3 4 5 6 7 8 9 10 11 12 |
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 user 'sample'@'localhost'; drop database if exists d1; |