Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SOLVED MySQL usernames with no underscore?

Discussion in 'Database Discussion' started by planetjoin, Aug 22, 2018.

  1. planetjoin

    planetjoin Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    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
     
  2. sysnishit

    sysnishit Active Member

    Joined:
    Aug 13, 2018
    Messages:
    25
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Internet
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,890
    Likes Received:
    91
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,161
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice