|
1
by brian
clean slate |
1 |
use mysql; |
2 |
create database MYSQLtest; |
|
3 |
grant all on MySQLtest.* to mysqltest_1@localhost; |
|
4 |
show grants for mysqltest_1@localhost; |
|
5 |
Grants for mysqltest_1@localhost |
|
6 |
GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' |
|
7 |
GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' |
|
8 |
select * from db where user = 'mysqltest_1'; |
|
9 |
Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv |
|
10 |
localhost mysqltest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y Y |
|
11 |
update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost'; |
|
12 |
flush privileges; |
|
13 |
show grants for mysqltest_1@localhost; |
|
14 |
Grants for mysqltest_1@localhost |
|
15 |
GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' |
|
16 |
GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' |
|
17 |
select * from db where user = 'mysqltest_1'; |
|
18 |
Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv |
|
19 |
localhost MYSQLtest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y Y |
|
20 |
delete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost'; |
|
21 |
flush privileges; |
|
22 |
drop user mysqltest_1@localhost; |
|
23 |
drop database MYSQLtest; |