Error managing names with underscores like 'web_default'

[devpacdd]

When a user is created (MySQL/MariaDB), the current command is generated:

CREATE USER 'test_user'@'localhost' IDENTIFIED BY '123123123';
GRANT ALL PRIVILEGES ON web\_default.* TO 'test_user'@'localhost';

The grant privileges command escapes the underscores and the privileges was not set correctly.

Thanks for your great work.

[peterpp]

I don't see a problem. It works for me correctly with MySQL 9.2.0 and MariaDB 11.7.2 with that escaped underscore.

[adrianbj]

On mobile so not sure if this is related but I recall a similar situation with Sequel-Ace. Sorry if it's not relevant/helpful.

Sequel-Ace/Sequel-Ace#1538

[peterpp]

Wildcards in table names are deprecated, but still present in MySQL 9.3: https://dev.mysql.com/doc/refman/9.3/en/grant.html#grant-quoting

The _ and % wildcards are permitted when specifying database names in GRANT statements that grant privileges at the database level (GRANT ... ON db_name.*). This means, for example, that to use a _ character as part of a database name, specify it using the \ escape character as \_ in the GRANT statement, to prevent the user from being able to access additional databases matching the wildcard pattern (for example, GRANT ... ON `foo\_bar`.* TO ...).

There is no mention of wildcards in the MariaDB documentation, but as far as I know they work as well. So they should be escaped.

[peterpp]

@devpacdd What is your environment?

• MySQL/MariaDB version
• your database or some cloud service
• PHP version
• mysqli or PDO extension