Merge lp:~hartmut-php/maria/bug1002404 into lp:~maria-captains/maria/trunk

Proposed by Hartmut Holzgraefe
Status: Needs review
Proposed branch: lp:~hartmut-php/maria/bug1002404
Merge into: lp:~maria-captains/maria/trunk
Diff against target: 20 lines (+11/-0)
1 file modified
scripts/mysql_system_tables_fix.sql (+11/-0)
To merge this branch: bzr merge lp:~hartmut-php/maria/bug1002404
Reviewer Review Type Date Requested Status
Maria-captains Pending
Review via email: mp+106785@code.launchpad.net

Description of the change

let mysql_upgrade take care of upper case host names (bug #1002402)

To post a comment you must log in.
Revision history for this message
Michael Widenius (monty) wrote :

Hi!

>>>>> "Hartmut" == Hartmut Holzgraefe <email address hidden> writes:

Hartmut> Hartmut Holzgraefe has proposed merging lp:~hartmut-php/maria/bug1002404 into lp:maria.
Hartmut> Requested reviews:
Hartmut> Maria-captains (maria-captains)
Hartmut> Related bugs:
Hartmut> Bug #1002404 in Maria: "DROP USER can't drop users with legacy upper case host name anymore"
Hartmut> https://bugs.launchpad.net/maria/+bug/1002404

Hartmut> For more details, see:
Hartmut> https://code.launchpad.net/~hartmut-php/maria/bug1002404/+merge/106785

Hartmut> let mysql_upgrade take care of upper case host names (bug #1002402)
Hartmut> --
Hartmut> https://code.launchpad.net/~hartmut-php/maria/bug1002404/+merge/106785
Hartmut> Your team Maria-captains is requested to review the proposed merge of lp:~hartmut-php/maria/bug1002404 into lp:maria.

Thanks, will apply this to MariaDB 5.3 tomorrow.

Regards,
Monty

Unmerged revisions

3368. By Hartmut Holzgraefe

let mysql_upgrade take care of legacy host name entries with upper case
letters in mysql.* privilege tables (launchpad bug #1002404)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'scripts/mysql_system_tables_fix.sql'
2--- scripts/mysql_system_tables_fix.sql 2012-01-13 14:50:02 +0000
3+++ scripts/mysql_system_tables_fix.sql 2012-05-22 11:36:21 +0000
4@@ -228,6 +228,17 @@
5 MODIFY type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL;
6
7 #
8+# host name handling changed to "always lower case" in 5.1.53
9+#
10+UPDATE columns_priv SET Host = LOWER(Host);
11+UPDATE db SET Host = LOWER(Host);
12+UPDATE host SET Host = LOWER(Host);
13+UPDATE procs_priv SET Host = LOWER(Host);
14+UPDATE servers SET Host = LOWER(Host);
15+UPDATE tables_priv SET Host = LOWER(Host);
16+UPDATE user SET Host = LOWER(Host);
17+
18+#
19 # Modify log tables.
20 #
21

Subscribers

People subscribed via source and target branches