Issue creating database with Mysql Manager

Started by breonet, February 26, 2025, 09:54:51 AM

Previous topic - Next topic

breonet

Hi all!!

I'm facing one issue with some concrete users, not with all of them, when creating a new database or user under Mysql Manager.

For example, with some users it works fine, but with one called, for example, user1, when creating a database called database1 or user through its panel, the result is like this: it creates a new database called "_database1" without the username before like "user1_database1" . It makes those databases not appear under the user mysql manager panel.

It's like if username variable were not attached when creating the new database.

Someone knows where can I take a look to it? Maybe some user config file that is not complete?

Thanks!!

josemnunez

Please review and edit the following file


/usr/local/cwp/.conf/mysql_user_prefix.conf



And only leave the users where the name is greater than 8 digits

breonet

Thanks a lot, the user appeared listed but without any prefix, listed like:

user1:
user2:user2
user3:user3
........ etc

so deleting the user1: line fixed it.

I don't know why it appeared listed in this file anyway, but the solution is correct.