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