Help me, please watch my video. https://youtu.be/Zrv9RjArmvM
What version of MariaDB are you using?
How i can know the version ?
It's on the home screen of the CWP Admin panel, under the Application Version box:
MySQL version: 10.6.17-MariaDB
Quote from: overseer on February 20, 2024, 02:46:28 AM
It's on the home screen of the CWP Admin panel, under the Application Version box:
MySQL version: 10.6.17-MariaDB
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
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.
Quote from: overseer on February 21, 2024, 03:06:36 AM
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
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.
please check the following file /usr/local/cwp/.conf/mysql_user_prefix.conf
here you should find something like this
eskuchame:eskucham
Quote from: overseer on February 21, 2024, 03:06:36 AM
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.
Quote from: Starburst on February 22, 2024, 01:23:23 PM
Quote from: overseer on February 21, 2024, 03:06:36 AM
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?
SSH into you server or access local terminal
Then just enter:
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.
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?
That looks fine.
It how mine look also just username:
Nothing after.
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
The file /usr/local/cwp/.conf/mysql_user_prefix.conf is blank on my servers, but are migrated from cPanel originally and I still follow the convention of ≤8 chars for a username when I set up new accounts, even though longer is now possible.