Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-670

LP:1002402 - mysql_install_db still creates users with case sensitive hostname

        Details

          Description

          Description:
          Since the fix of MySQL bug http://bugs.mysql.com/36742 GRANT, CREATE USER and DROP USER all lowercase the host name portion of user name argument before going to the mysql.user table, so ensuring that the actually stored host name part is always lowercase.

          The mysql_system_tables_data.sql template used by mysql_install_db doesn't take into account yet that the system hostname may use upper case characters in its set hostname

          How to repeat:
          On the shell do "hostname FOOBAR"
          then do a fresh server installation using mysql_install_db
          check the mysql.user table to see that entries with the
          uppercase FOOBAR were created instead of the expected lowercase foobar

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5899 Merge problem in scripts/mysql_system_tables_data.sql disabled recent bugfixes

                • Major - Major loss of function.
                • Open
                links to

                Web Link Bug #62254 mysql_install_db still creates users with case sensitive hostname

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 1002402

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1002402
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  The upstream bug was fixed in MySQL 5.1.73 / 5.5.35 / 5.6.15.

                  Show
                  elenst Elena Stepanova added a comment - The upstream bug was fixed in MySQL 5.1.73 / 5.5.35 / 5.6.15.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  See also MDEV-5899 which blocks the change in MariaDB 5.2/5.3.

                  Show
                  elenst Elena Stepanova added a comment - See also MDEV-5899 which blocks the change in MariaDB 5.2/5.3.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      hholzgra Hartmut Holzgraefe
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: