Devart Forums

Posted: **Sat 18 Jun 2022 20:10**

hi,

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

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

Posted: **Thu 23 Jun 2022 06:54**

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/

Posted: **Thu 23 Jun 2022 09:18**

hi dzhanhira,

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

thanks,
micha

Devart Forums

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

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

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

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