I can't create databases correctly

[mkaioh2]

Help me, please watch my video.  https://youtu.be/Zrv9RjArmvM

[overseer]

What version of MariaDB are you using?

[mkaioh2]

How i can know the version ?

[overseer]

It's on the home screen of the CWP Admin panel, under the Application Version box:

Code Select Expand

MySQL version: 10.6.17-MariaDB


[mkaioh2]

It's on the home screen of the CWP Admin panel, under the Application Version box:

Code Select Expand

MySQL version: 10.6.17-MariaDB


Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $

[overseer]

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

[mkaioh2]

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

Server version: 10.4.33-MariaDB - MariaDB Server

[overseer]

Can you put in a support ticket? You may have uncovered a bug, but difficult to say from here as I haven't encountered this on my servers.

[josemnunez]

please check the following file  /usr/local/cwp/.conf/mysql_user_prefix.conf

here you should find something like this

eskuchame:eskucham

[Starburst]

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

@overseer, for some reason the CWP Admin Panel shows the client version.
Found this bug when testing MariaDB 11.x with how it queried the version running.

[mkaioh2]

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

@overseer, for some reason the CWP Admin Panel shows the client version.
Found this bug when testing MariaDB 11.x with how it queried the version running.

where i can find it?
/usr/local/cwp/.conf/mysql_user_prefix.con

in FTP? or ROOT?

[Starburst]

SSH into you server or access local terminal

Then just enter:

Code Select Expand

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

You will see a list of the username prefixes. Which should match the Username under User Accounts.

[mkaioh2]

I FOUND IT =D what i should be there?

image -> https://i.ibb.co/YbCP6D0/Sin-t-tulo3.jpg

look at my image please, you will see that eskuchame does not have eskuchame:eskuchame so what should I do there?

[Starburst]

That looks fine.

It how mine look also just username:
Nothing after.

[josemnunez]

Delete the empty lines, here there should only be the users who have more than 8 characters as a username and the prefix only with 8, as shown in the example