The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Username must be alphanumeric characters

Discussion in 'Database Discussions' started by jimhermann, Sep 10, 2011.

  1. jimhermann

    jimhermann Active Member

    Joined:
    Jan 20, 2008
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Folks,

    When I try to create a MySQL Username with an underscore, I receive this error message: "Username must be alphanumeric characters."

    Fantastico also is having problems when it tries to create a username with the same name as the database: xxxxx_test

    The MySQL has a few existing usernames that contain underscores. The usernames appear to work correctly.

    Is this a new cPanel requirement?

    Jim

    cPanel Version 11.30.2 (build 1)
    Theme x3
    Apache version 2.2.19
    PHP version 5.2.17
    MySQL version 5.0.92-community-log
    Architecture x86_64
    Operating system linux
    ----
    Database Prefixing is turned OFF
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,446
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    If I understand you correctly, when you create a new user with this name: xxxxx_test

    It's actually going to be cpanelusername_xxxxx_test
     
  3. jimhermann

    jimhermann Active Member

    Joined:
    Jan 20, 2008
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Infopro,

    No. I have Database Prefixing turned OFF.

    If I try to create MySQL username xxxxxtest, then username xxxxxtest is created. PHPMyAdmin confirms that the username is xxxxxtest, not xxxxx_xxxxxtest.

    If I try to create MySQL username xxxxx_test, I get an error message. The xxxxx is the same as the actual cPanel username. The cPanel username has only 5 characters.

    Jim
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,446
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    When you go to cPanel > Databases > MySQL Databases, where it says Add new user, Below that where it says Username: and then theres a text box, what do you see in front of that text box? Does it show your cPanel username_
     
  5. jimhermann

    jimhermann Active Member

    Joined:
    Jan 20, 2008
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Infopro,

    No. There is nothing in the front of that text box.

    /http://www.uuism.net/MySQLAddUser.JPG


    According to this document, as of cPanel 11.28, turning Database Prefixing OFF will also turn MySQL Username Prefixing OFF:

    http://www.cpanel.net/DBMappingWhitePaper_r12.pdf

    Jim
     
    #5 jimhermann, Sep 11, 2011
    Last edited: Sep 11, 2011
Loading...

Share This Page