Author Topic: I can't create databases correctly  (Read 2239 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
I can't create databases correctly
« on: February 19, 2024, 10:22:01 PM »
Help me, please watch my video.  https://youtu.be/Zrv9RjArmvM

Offline
*****
Re: I can't create databases correctly
« Reply #1 on: February 19, 2024, 11:00:36 PM »
What version of MariaDB are you using?

Offline
*
Re: I can't create databases correctly
« Reply #2 on: February 20, 2024, 12:56:25 AM »
How i can know the version ?

Offline
*****
Re: I can't create databases correctly
« Reply #3 on: February 20, 2024, 02:46:28 AM »
It's on the home screen of the CWP Admin panel, under the Application Version box:
Code: [Select]
MySQL version: 10.6.17-MariaDB

Offline
*
Re: I can't create databases correctly
« Reply #4 on: February 20, 2024, 06:31:28 PM »
It's on the home screen of the CWP Admin panel, under the Application Version box:
Code: [Select]
MySQL version: 10.6.17-MariaDB


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

Offline
*****
Re: I can't create databases correctly
« Reply #5 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.

Offline
*
Re: I can't create databases correctly
« Reply #6 on: February 21, 2024, 05:11:42 PM »
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

Offline
*****
Re: I can't create databases correctly
« Reply #7 on: February 22, 2024, 03:00:01 AM »
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.

Offline
*****
Re: I can't create databases correctly
« Reply #8 on: February 22, 2024, 07:52:59 AM »
please check the following file  /usr/local/cwp/.conf/mysql_user_prefix.conf

here you should find something like this

eskuchame:eskucham

Offline
*****
Re: I can't create databases correctly
« Reply #9 on: February 22, 2024, 01:23:23 PM »
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.

Offline
*
Re: I can't create databases correctly
« Reply #10 on: February 22, 2024, 05:44:34 PM »
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?

Offline
*****
Re: I can't create databases correctly
« Reply #11 on: February 22, 2024, 06:03:38 PM »
SSH into you server or access local terminal

Then just enter:
Code: [Select]
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.

Offline
*
Re: I can't create databases correctly
« Reply #12 on: February 22, 2024, 07:30:16 PM »
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?

Offline
*****
Re: I can't create databases correctly
« Reply #13 on: February 22, 2024, 08:05:49 PM »
That looks fine.

It how mine look also just username:
Nothing after.

Offline
*****
Re: I can't create databases correctly
« Reply #14 on: February 22, 2024, 08:56:52 PM »
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