SOLVED MySQL usernames with no underscore?

[planetjoin]

Hello

I´m using MariaDB 10.2.17, centOS 7 and Cloudlinux 7.5
I don´t know if this is something from MariaDB or CL.

The point is...

I just added a new account in one of my servers, and created a new database and user.
Always the user and dabatase name uses the cpanel account main username, like :
username_database
username_username

But in this new site i added, when i created a new database:
database
username
(without the username_ before)

Is right or i have something bad in the config?
I can´t understand how it works now.. if site1.com create a new database called "db" and site2.com in same server created a new database called "db" ???

Thanks for your comments.
Fabian

 

[sysnishit]

Hello,

You created database from cPanel or mysql prompt ?
-----
I can´t understand how it works now.. if site1.com create a new database called "db" and site2.com in same server created a new database called "db" ???
-----
If you create database named as db for one site then mysql will not allow you to create database with db for any other site.

 

[24x7server]

Hi,

Basically, you can enable and disable this function of using "_" while creating the database. This setting is found in tweak setting. You can refer to the below cPanel documentation for more information:
Tweak Settings - SQL - Version 68 Documentation - cPanel Documentation

 

[cPanelLauren]

Hello @planetjoin


As suggested the databases prefixing feature is something that is able to be modified from tweak settings and is not necessary for the proper functioning of the database. This is noted in our documentation here: MySQL Databases - Version 74 Documentation - cPanel Documentation

Thanks!