[MDEV-670] LP:1002402 - mysql_install_db still creates users with case sensitive hostname Created: 2012-05-21  Updated: 2014-04-29  Resolved: 2014-04-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.35, 10.0.8, 5.1.73, 5.2.15, 5.3.13

Type: Bug Priority: Minor
Reporter: Hartmut Holzgraefe Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad, upstream

Attachments: XML File LPexportBug1002402.xml    
Issue Links:
Blocks
is blocked by MDEV-5899 Merge problem in scripts/mysql_system... Closed

 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

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-05-30 ]

Launchpad bug id: 1002402

Comment by Elena Stepanova [ 2014-04-14 ]

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

Comment by Elena Stepanova [ 2014-04-29 ]

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

Generated at Thu Feb 08 06:30:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.