MySQL usernames with no underscore?

planetjoin

• August 22, 2018 23:38

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

  • August 23, 2018 05:19

  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.

  0
• 

  24x7server

  • August 23, 2018 05:28

  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

  0
• 

  cPanelLauren

  • August 23, 2018 14:42

  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!

  0

Please sign in to leave a comment.