projects / packages / mysql.git / blame
| Commit | Line | Data |
|---|---|---|
| 7eed3192 AM |
1 | --- percona-server-5.6.51-91.0/scripts/mysql_system_tables_data.sql~ 2021-02-02 15:20:34.000000000 +0100 |
| 2 | +++ percona-server-5.6.51-91.0/scripts/mysql_system_tables_data.sql 2021-06-30 09:18:45.855932271 +0200 | |
| 3 | @@ -33,30 +33,24 @@ | |
| 4 | -- a plain character | |
| 5 | SELECT LOWER( REPLACE((SELECT REPLACE(@@hostname,'_','\_')),'%','\%') )INTO @current_hostname; | |
| 14996ad7 | 6 | |
| 09ee1717 | 7 | - |
| 28525401 AM |
8 | --- Fill "db" table with default grants for anyone to |
| 9 | --- access database 'test' and 'test_%' if "db" table didn't exist | |
| 10 | -CREATE TEMPORARY TABLE tmp_db LIKE db; | |
| 11 | -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'); | |
| 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 db SELECT * FROM tmp_db WHERE @had_db_table=0; | |
| 14 | -DROP TABLE tmp_db; | |
| 15 | - | |
| 16 | - | |
| 09ee1717 AM |
17 | -- Fill "user" table with default users allowing root access |
| 18 | -- from local machine if "user" table didn't exist before | |
| 28525401 | 19 | CREATE TEMPORARY TABLE tmp_user LIKE user; |
| 91049128 AM |
20 | -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,'mysql_native_password','','N'); |
| 21 | -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,'mysql_native_password','','N' FROM dual WHERE @current_hostname != 'localhost'; | |
| 22 | -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,'mysql_native_password','','N'); | |
| 23 | -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,'mysql_native_password','','N'); | |
| 24 | +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,'mysql_native_password','','N'); | |
| 25 | +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,'mysql_native_password','','N' FROM dual WHERE @current_hostname != 'localhost'; | |
| 26 | +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,'mysql_native_password','','N'); | |
| 27 | +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,'mysql_native_password','','N'); | |
| 0cb1ff50 ER |
28 | +INSERT INTO tmp_user VALUES ('localhost', 'mysql_sysadmin','','N','N','N','N','N','N',/*10:Reload_priv*/'Y',/*11:Shutdown_priv*/'Y','N','N','N','N','N','N','N','N','N','N','N','N',/*24:Repl_client_priv*/'Y','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'); |
| 29 | +REPLACE INTO tmp_user SELECT @current_hostname,'mysql_sysadmin','','N','N','N','N','N','N',/*10:Reload_priv*/'Y',/*11:Shutdown_priv*/'Y','N','N','N','N','N','N','N','N','N','N','N','N',/*24:Repl_client_priv*/'Y','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N' FROM dual WHERE @current_hostname != 'localhost'; | |
| 30 | +REPLACE INTO tmp_user VALUES ('127.0.0.1', 'mysql_sysadmin','','N','N','N','N','N','N',/*10:Reload_priv*/'Y',/*11:Shutdown_priv*/'Y','N','N','N','N','N','N','N','N','N','N','N','N',/*24:Repl_client_priv*/'Y','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'); | |
| 31 | +REPLACE INTO tmp_user VALUES ('::1', 'mysql_sysadmin','','N','N','N','N','N','N',/*10:Reload_priv*/'Y',/*11:Shutdown_priv*/'Y','N','N','N','N','N','N','N','N','N','N','N','N',/*24:Repl_client_priv*/'Y','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'mysql_native_password','','N'); | |
| 988dcab6 | 32 | INSERT INTO tmp_user (host,user) VALUES ('localhost',''); |
| 001b57c1 | 33 | INSERT INTO tmp_user (host,user) SELECT @current_hostname,'' FROM dual WHERE @current_hostname != 'localhost'; |
| 28525401 | 34 | INSERT INTO user SELECT * FROM tmp_user WHERE @had_user_table=0; |
| 7eed3192 AM |
35 | DROP TABLE tmp_user; |
| 36 | ||
| 37 | CREATE TEMPORARY TABLE tmp_proxies_priv LIKE proxies_priv; | |
| 38 | -INSERT INTO tmp_proxies_priv VALUES ('localhost', 'root', '', '', TRUE, '', now()); | |
| 39 | -REPLACE INTO tmp_proxies_priv SELECT @current_hostname, 'root', '', '', TRUE, '', now() FROM DUAL WHERE LOWER (@current_hostname) != 'localhost'; | |
| 40 | +INSERT INTO tmp_proxies_priv VALUES ('localhost', 'mysql', '', '', TRUE, '', now()); | |
| 41 | +REPLACE INTO tmp_proxies_priv SELECT @current_hostname, 'mysql', '', '', TRUE, '', now() FROM DUAL WHERE LOWER (@current_hostname) != 'localhost'; | |
| 42 | INSERT INTO proxies_priv SELECT * FROM tmp_proxies_priv WHERE @had_proxies_priv_table=0; | |
| 43 | DROP TABLE tmp_proxies_priv; |