Merge problem in scripts/mysql_system_tables_data.sql disabled recent bugfixes

revno: 4059

revision-id: venkata.sidagam@oracle.com-20131031173244-9vf8hy0y4jepgkcj

parent: balasubramanian.kandasamy@oracle.com-20131030030707-3qurl7q3l0qb8afc

committer: Venkata Sidagam <venkata.sidagam@oracle.com>

branch nick: 5.1

timestamp: Thu 2013-10-31 23:02:44 +0530

message:

  Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY 

      UPPER CASE HOST NAME ANYMORE

  Description:

  It is not possible to drop users with host names with upper case

  letters in them. i.e DROP USER 'root'@'Tmp_Host_Name'; is failing

  with error.

  Analysis: Since the fix 11748570 we came up with lower case hostnames

  as standard. But in the current bug the hostname is created by

  mysql_install_db script is still having upper case hostnames. 

  So, if we have the hostname with upper case letters like(Tmp_Host_Name)

  then we will have as it is stored in the mysql.user table. 

  In this case if use "'DROP USER 'root'@'Tmp_Host_Name';" it gives 

  error because we do compare with the lower case of hostname since the 

  11748570 fix.

  Fix: We need to convert the hostname to lower case before storing into 

  the mysql.user table when we run the mysql_install_db script.

revno: 3953

revision-id: sujatha.sivakumar@oracle.com-20130219090111-98apjsj6myi5yrm1

parent: harin.vadodaria@oracle.com-20130219064731-ggrchazff766r4gu

committer: Sujatha Sivakumar <sujatha.sivakumar@oracle.com>

branch nick: Bug11746817_mysql-5.1

timestamp: Tue 2013-02-19 14:31:11 +0530

message:

  Bug#11746817:MYSQL_INSTALL_DB CREATES WILDCARD GRANTS WHEN

  HOST HAS '_' IN THE HOSTNAME

  Problem:

  =======

  '_' and '%' are treated as a wildcards by the ACL code and

  this is documented in the manual. The problem with

  mysql_install_db is that it does not take this into account

  when creating the initial GRANT tables:

  --- cut ---

  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','','','','',

  0,0,0,0 FROM dual WHERE LOWER( @current_hostname) != 'localhost';

  --- cut ---

  If @current_hostname contains any wildcard characters, then 

  a wildcard entry will be defined for the 'root' user, 

  which is a flaw.

  Analysis:

  ========

  As per the bug description when we have a hostname with a

  wildcard character in it, it allows clients from several other

  hosts with similar name pattern to connect to the server as root.

  For example, if the hostname is like 'host_.com' then the same

  name is logged in mysql.user table. This allows 'root' users

  from other hosts like 'host1.com', 'host2.com' ... to connect

  to the server as root user.

  While creating the intial GRANT tables we do not have a check

  for wildcard characters in hostname.

  Fix:

  ===

  As part of fix escape character "\" is added before wildcard

  character to make it a plain character, so that the one and

  only host with the exact name will be able to connect to the

  server.

revision-id: sergii@pisem.net-20140316125944-vcz27criv3mboxo1

date: 2014-03-16 13:59:44 +0100

build-date: 2014-03-19 04:02:43 +0400

revno: 3230

branch-nick: 5.2

revision-id: sergii@pisem.net-20140316200301-s6v5h1t6d9feqwo9

date: 2014-03-16 21:03:01 +0100

build-date: 2014-03-19 04:03:03 +0400

revno: 3773

branch-nick: 5.3