Control Web Panel

WebPanel => MySQL => Topic started by: jefersonsens on October 26, 2023, 05:17:17 PM

Title: problem with database creation
Post by: jefersonsens 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.

Title: Re: problem with database creation
Post by: josemnunez 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

Title: Re: problem with database creation
Post by: jefersonsens on October 27, 2023, 11:18:55 AM

Solved✅
Thanks for the reply!

Quote from: josemnunez 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