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

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
michabbb
Posts: 211
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

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

Post by michabbb » Sat 18 Jun 2022 20:10

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
Devart Team
Posts: 182
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » 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/

michabbb
Posts: 211
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

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

Post by michabbb » Thu 23 Jun 2022 09:18

hi dzhanhira,

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

thanks,
micha

Post Reply