New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

problem with database creation

Started by jefersonsens, October 26, 2023, 05:17:17 PM

Previous topic - Next topic

jefersonsens

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.

josemnunez

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

jefersonsens

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