Can't create new user with mariadb 10.4.4 - user column not found #645
Description
I'm using mariadb 10.4.4 and trying to include a new user
The problem is the gui interface running the background SQL.
Mariadb 10.4.4 don't have "user" column, it have "User" column Maybe a strtolower() in some where could help here
SHOW COLUMNS FROM mysql.user;
COLUMNS
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| Host | char(60) | NO | |||
| User | char(80) | NO | |||
| Password | longtext | YES | \N | ||
| Select_priv | varchar(1) | YES | \N | ||
| Insert_priv | varchar(1) | YES | \N | ||
| Update_priv | varchar(1) | YES | \N | ||
| Delete_priv | varchar(1) | YES | \N | ||
| Create_priv | varchar(1) | YES | \N | ||
| Drop_priv | varchar(1) | YES | \N | ||
| Reload_priv | varchar(1) | YES | \N | ||
| Shutdown_priv | varchar(1) | YES | \N | ||
| Process_priv | varchar(1) | YES | \N | ||
| File_priv | varchar(1) | YES | \N | ||
| Grant_priv | varchar(1) | YES | \N | ||
| References_priv | varchar(1) | YES | \N | ||
| Index_priv | varchar(1) | YES | \N | ||
| Alter_priv | varchar(1) | YES | \N | ||
| Show_db_priv | varchar(1) | YES | \N | ||
| Super_priv | varchar(1) | YES | \N | ||
| Create_tmp_table_priv | varchar(1) | YES | \N | ||
| Lock_tables_priv | varchar(1) | YES | \N | ||
| Execute_priv | varchar(1) | YES | \N | ||
| Repl_slave_priv | varchar(1) | YES | \N | ||
| Repl_client_priv | varchar(1) | YES | \N | ||
| Create_view_priv | varchar(1) | YES | \N | ||
| Show_view_priv | varchar(1) | YES | \N | ||
| Create_routine_priv | varchar(1) | YES | \N | ||
| Alter_routine_priv | varchar(1) | YES | \N | ||
| Create_user_priv | varchar(1) | YES | \N | ||
| Event_priv | varchar(1) | YES | \N | ||
| Trigger_priv | varchar(1) | YES | \N | ||
| Create_tablespace_priv | varchar(1) | YES | \N | ||
| Delete_history_priv | varchar(1) | YES | \N | ||
| ssl_type | varchar(9) | YES | \N | ||
| ssl_cipher | longtext | NO | |||
| x509_issuer | longtext | NO | |||
| x509_subject | longtext | NO | |||
| max_questions | bigint(20) unsigned | NO | 0 | ||
| max_updates | bigint(20) unsigned | NO | 0 | ||
| max_connections | bigint(20) unsigned | NO | 0 | ||
| max_user_connections | bigint(21) | NO | 0 | ||
| plugin | longtext | NO | |||
| authentication_string | longtext | NO | |||
| password_expired | varchar(1) | NO | |||
| is_role | varchar(1) | YES | \N | ||
| default_role | longtext | NO | |||
| max_statement_time | decimal(12,6) | NO | 0.000000 |