]>
Commit | Line | Data |
---|---|---|
9cc3fa3a AM |
1 | diff -urNp -x '*.orig' percona-server-5.5.62-38.14.org/scripts/mysql_system_tables_data.sql percona-server-5.5.62-38.14/scripts/mysql_system_tables_data.sql |
2 | --- percona-server-5.5.62-38.14.org/scripts/mysql_system_tables_data.sql 2018-11-15 14:19:23.000000000 +0100 | |
3 | +++ percona-server-5.5.62-38.14/scripts/mysql_system_tables_data.sql 2022-11-21 13:27:06.244824210 +0100 | |
4 | @@ -26,23 +26,17 @@ | |
5 | -- a plain character | |
6 | SELECT LOWER( REPLACE((SELECT REPLACE(@@hostname,'_','\_')),'%','\%') )INTO @current_hostname; | |
14996ad7 | 7 | |
09ee1717 | 8 | - |
28525401 AM |
9 | --- Fill "db" table with default grants for anyone to |
10 | --- access database 'test' and 'test_%' if "db" table didn't exist | |
11 | -CREATE TEMPORARY TABLE tmp_db LIKE db; | |
12 | -INSERT INTO tmp_db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y'); | |
13 | -INSERT INTO tmp_db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','N','N','Y','Y'); | |
14 | -INSERT INTO db SELECT * FROM tmp_db WHERE @had_db_table=0; | |
15 | -DROP TABLE tmp_db; | |
16 | - | |
17 | - | |
09ee1717 AM |
18 | -- Fill "user" table with default users allowing root access |
19 | -- from local machine if "user" table didn't exist before | |
28525401 | 20 | CREATE TEMPORARY TABLE tmp_user LIKE user; |
14996ad7 | 21 | -INSERT INTO tmp_user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); |
86f973a0 | 22 | -REPLACE INTO tmp_user SELECT @current_hostname,'root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','' FROM dual WHERE @current_hostname != 'localhost'; |
14996ad7 AM |
23 | -REPLACE INTO tmp_user VALUES ('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); |
24 | -REPLACE INTO tmp_user VALUES ('::1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); | |
a4082aa8 | 25 | +INSERT INTO tmp_user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); |
86f973a0 | 26 | +REPLACE INTO tmp_user SELECT @current_hostname,'mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','' FROM dual WHERE @current_hostname != 'localhost'; |
a4082aa8 AM |
27 | +REPLACE INTO tmp_user VALUES ('127.0.0.1','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); |
28 | +REPLACE INTO tmp_user VALUES ('::1','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''); | |
29 | +INSERT INTO tmp_user VALUES ('localhost','mysql_sysadmin','','N','N','N','N','N','N','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',''); | |
86f973a0 | 30 | +REPLACE INTO tmp_user SELECT @current_hostname,'mysql_sysadmin','','N','N','N','N','N','N','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'','' FROM dual WHERE @current_hostname != 'localhost'; |
a4082aa8 AM |
31 | +REPLACE INTO tmp_user VALUES ('127.0.0.1','mysql_sysadmin','','N','N','N','N','N','N','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',''); |
32 | +REPLACE INTO tmp_user VALUES ('::1','mysql_sysadmin','','N','N','N','N','N','N','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',''); | |
988dcab6 | 33 | INSERT INTO tmp_user (host,user) VALUES ('localhost',''); |
86f973a0 | 34 | INSERT INTO tmp_user (host,user) SELECT @current_hostname,'' FROM dual WHERE @current_hostname != 'localhost'; |
28525401 | 35 | INSERT INTO user SELECT * FROM tmp_user WHERE @had_user_table=0; |