Author Topic: Issue creating database with Mysql Manager  (Read 133 times)

0 Members and 2 Guests are viewing this topic.

Offline
*
Issue creating database with Mysql Manager
« on: February 26, 2025, 09:54:51 AM »
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!!

Offline
*****
Re: Issue creating database with Mysql Manager
« Reply #1 on: February 26, 2025, 10:11:35 AM »
Please review and edit the following file

Code: [Select]
/usr/local/cwp/.conf/mysql_user_prefix.conf


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

Offline
*
Re: Issue creating database with Mysql Manager
« Reply #2 on: February 26, 2025, 12:08:35 PM »
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.