Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.27, 10.4.17, 10.5.8, 10.5.9
-
None
-
None
-
Debian buster
Linux
Virtual machines
kvm
Description
When skip_name_resolve is ON if a user is created with hostname 'show create user' statement for users with host = <hostname> return 'Can't find any matching row in the user table'.
Steps to reproduce:
mysql
|
MariaDB [(none)]> show global variables like 'skip_name_resolve';
|
+-------------------+-------+
|
| Variable_name | Value |
|
+-------------------+-------+
|
| skip_name_resolve | ON |
|
+-------------------+-------+
|
|
MariaDB [(none)]> create user 'nikosp'@'hostname' identified by 'pass';
|
MariaDB [(none)]> show create user 'nikosp'@'hostname';
|
+-----------------------------------------------------------------------------------------------------------------+
|
| CREATE USER for nikosp@hostname |
|
+-----------------------------------------------------------------------------------------------------------------+
|
| CREATE USER `nikosp`@`hostname` IDENTIFIED BY PASSWORD '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7' |
|
+-----------------------------------------------------------------------------------------------------------------+
|
MariaDB [(none)]> exit
|
mariadb-upgrade -s -f
|
mysql
|
|
MariaDB [(none)]> show create user 'nikosp'@'hostname';
|
ERROR 1133 (28000): Can't find any matching row in the user table
|