Author Topic: problem with database creation  (Read 991 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
problem with database creation
« on: October 26, 2023, 05:17:17 PM »
Hello everybody,
I'm having a problem with creating mysql databases.
When trying to create banks using the panel, the banks are created without the username preceding them, just being
_database
when it should be
user_database

This causes the database to not be displayed on the panel to the user.
The same happens when trying to create users.

Offline
*****
Re: problem with database creation
« Reply #1 on: October 26, 2023, 10:39:24 PM »
This may happen when the account comes from a cpanel or cwp migration.

To solve it, run the following command cat /usr/local/cwp/.conf/mysql_user_prefix.conf and only leave in that file the users whose name has more than 8 characters, the rest must be eliminated

This will solve the problem

Offline
*
Re: problem with database creation
« Reply #2 on: October 27, 2023, 11:18:55 AM »
Solved✅
Thanks for the reply!


This may happen when the account comes from a cpanel or cwp migration.

To solve it, run the following command cat /usr/local/cwp/.conf/mysql_user_prefix.conf and only leave in that file the users whose name has more than 8 characters, the rest must be eliminated

This will solve the problem