| 2012-05-21 17:54:11 |
Hartmut Holzgraefe |
bug |
|
|
added bug |
| 2012-05-21 17:54:36 |
Hartmut Holzgraefe |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=62255 |
|
| 2012-05-21 17:54:36 |
Hartmut Holzgraefe |
bug task added |
|
mysql-server |
|
| 2012-05-22 11:12:20 |
Hartmut Holzgraefe |
description |
Description:
As DROP USER lowercases the host name part of the user name now (see bug #36742) it is not possible to drop users with host names with upper case letters in them (either from pre-5.1.53 installations or due to bug #62254)
Such users either need to be removed by either removing them from the mysql.user table using DELETE or by first converting the host name part in mysql.user to all lower case using UPDATE and LOWER
(See also bug #61525)
How to repeat:
(assuming that bug #62254 has not been fixed yet)
on the shell do
hostname FOOBAR
in the mysql command line client
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
DROP USER 'root'@'FOOBAR';
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
the DROP will report "0 rows affected" and both SELECTs will return the same result, proving that no user was deleted by the DROP statement
Suggested fix:
Make DROP USER really case insensitive regarding to the host name part |
Description:
As DROP USER lowercases the host name part of the user name now (see bug #36742) it is not possible to drop users with host names with upper case letters in them (either from pre-5.1.53 installations or due to bug #1002404)
Such users either need to be removed by either removing them from the mysql.user table using DELETE or by first converting the host name part in mysql.user to all lower case using UPDATE and LOWER
(See also bug #61525)
How to repeat:
(assuming that bug #1002404 has not been fixed yet)
on the shell do
hostname FOOBAR
in the mysql command line client
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
DROP USER 'root'@'FOOBAR';
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
the DROP will report "0 rows affected" and both SELECTs will return the same result, proving that no user was deleted by the DROP statement
Suggested fix:
Make DROP USER really case insensitive regarding to the host name part |
|
| 2012-05-22 11:14:05 |
Hartmut Holzgraefe |
description |
Description:
As DROP USER lowercases the host name part of the user name now (see bug #36742) it is not possible to drop users with host names with upper case letters in them (either from pre-5.1.53 installations or due to bug #1002404)
Such users either need to be removed by either removing them from the mysql.user table using DELETE or by first converting the host name part in mysql.user to all lower case using UPDATE and LOWER
(See also bug #61525)
How to repeat:
(assuming that bug #1002404 has not been fixed yet)
on the shell do
hostname FOOBAR
in the mysql command line client
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
DROP USER 'root'@'FOOBAR';
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
the DROP will report "0 rows affected" and both SELECTs will return the same result, proving that no user was deleted by the DROP statement
Suggested fix:
Make DROP USER really case insensitive regarding to the host name part |
Description:
As DROP USER lowercases the host name part of the user name now (see MySQL bug http://bugs.mysql.com/36742) it is not possible to drop users with host names with upper case letters in them (either from pre-5.1.53 installations or due to bug #1002404)
Such users either need to be removed by either removing them from the mysql.user table using DELETE or by first converting the host name part in mysql.user to all lower case using UPDATE and LOWER
(See also MySQL bug htt://bugs.mysql.com/61525)
How to repeat:
(assuming that bug #1002404 has not been fixed yet)
on the shell do
hostname FOOBAR
in the mysql command line client
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
DROP USER 'root'@'FOOBAR';
SELECT User, Hostname FROM mysql.user WHERE Host = 'FOOBAR';
the DROP will report "0 rows affected" and both SELECTs will return the same result, proving that no user was deleted by the DROP statement
Suggested fix:
Make DROP USER really case insensitive regarding to the host name part |
|
| 2012-05-22 11:29:19 |
Hartmut Holzgraefe |
branch linked |
|
lp:~hartmut-php/maria/bug1002404 |
|
| 2012-05-30 23:28:31 |
Elena Stepanova |
tags |
|
upstream |
|
