diff options
| author | unknown <jperkin@production.mysql.com> | 2007-10-04 12:06:13 +0200 |
|---|---|---|
| committer | unknown <jperkin@production.mysql.com> | 2007-10-04 12:06:13 +0200 |
| commit | 61e8c53898fedd38db9abbc8596013d70882f136 (patch) | |
| tree | dc4d7343e2fd610f0b0e9e69d41deabbc74cbb8c /scripts/mysql_system_tables_data.sql | |
| parent | c8cb61bef370538c33ed7eb2e479b5bfab96e832 (diff) | |
| parent | 549cbcd54731985b0085d542e7b7dd515fbd77ca (diff) | |
| download | mariadb-git-61e8c53898fedd38db9abbc8596013d70882f136.tar.gz | |
Merge production.mysql.com:/usersnfs/jperkin/bk/build/5.0
into production.mysql.com:/usersnfs/jperkin/bk/bug-27692/5.0
Diffstat (limited to 'scripts/mysql_system_tables_data.sql')
| -rw-r--r-- | scripts/mysql_system_tables_data.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/scripts/mysql_system_tables_data.sql b/scripts/mysql_system_tables_data.sql index 5f0289ab197..c0e3af1c9c8 100644 --- a/scripts/mysql_system_tables_data.sql +++ b/scripts/mysql_system_tables_data.sql @@ -17,5 +17,7 @@ CREATE TEMPORARY TABLE tmp_user LIKE user; 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','','','','',0,0,0,0); REPLACE INTO tmp_user VALUES (@@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','','','','',0,0,0,0); 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','','','','',0,0,0,0); +INSERT INTO tmp_user (host,user) VALUES ('localhost',''); +INSERT INTO tmp_user (host,user) VALUES (@@hostname,''); INSERT INTO user SELECT * FROM tmp_user WHERE @had_user_table=0; DROP TABLE tmp_user; |