[MYSQL MODULE] Databases with underscores stored incorrectly [#25303]

Submitted by jasongayson on Thu, 02/07/2013 - 21:25

Whenever you create or add a database in Virtualmin, it mangles the name.

prefix_suffix (like sitename_mydatabase) becomes stored in the actual MySQL database as prefix_suffix

There's most likely an extra escape char somewhere.

Status:

Closed (works as designed)

Comments

Submitted by JamieCameron on Thu, 02/07/2013 - 23:33 Comment #1

Do you mean the database is being named prefix\_suffix , or that permissions in the db table have an backslash before the underscore?

The latter is (I think) needed, because an _ in SQL is a wildcard character that has to be escaped. See http://jordanjr.com/articles/watch-out-underscore-setting-privileges-usi...