unable to edit users on MariaDB-1:10.7.4 [enterprise 9.0.897]

[michabbb]

hi,

is MariaDB-1:10.7.4 official supported?
because dbforge does

Code: Select all

SELECT
	*
FROM mysql.User
WHERE is_role = 'N'
AND ('' = ''
OR '' IS NULL
OR CONCAT(User, '@*', Host) IN (''))
ORDER BY User, Host

but server says:

Code: Select all

Error (3,6): Table 'mysql.User' doesn't exist

because there is not table, it´s a view and it´s called "user" (small >u<)

thanks,
micha

[dzhanhira]

Hi Micha,

We would like to ask you to check the menu> database->server variables and check server variable lower_case_table_names

Also, please have a look at https://mariadb.com/docs/reference/mdb/ ... ble_names/

[michabbb]

hi dzhanhira,

thanks, setting that value to 1 seems to work.
good to know !!

thanks,
micha