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!

MySQL Error With Usernames With A -

Discussion in 'General Discussion' started by InsaneContender, Jul 10, 2003.

  1. InsaneContender

    InsaneContender Registered

    Joined:
    Apr 4, 2003
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    Apparently there is a problem with the new build regaurding MySQL with users who have a - in their usernames. It will not show the MySQL information in the admin. Is there a way to make a fix for this and release it immediately?

    cPanel.net Support Ticket Number:
     
  2. tAzMaNiAc

    tAzMaNiAc Well-Known Member

    Joined:
    Feb 16, 2003
    Messages:
    559
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Sachse, TX
    If you submitted a ticket.. Yes.

    Brenden

    cPanel.net Support Ticket Number:
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
    Its already resolved in the latest EDGE releases. Please see the ChangeLog on layer1

    cPanel.net Support Ticket Number:
     
  4. DTX

    DTX Member

    Joined:
    Mar 16, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Issue is still ongoing for me, even after upgrade of Cpanel to WHM 7.1.0 & Cpanel 7.1.9-R73

    Databases now show in Admin when created, user names too are added and with correct '-' however the database itself when created still omits the '-' therefore connection to the database is not possible.

    cPanel.net Support Ticket Number:
     
  5. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    166
    Perhaps you should just modify the username so that it doesn't have a hyphen in it--problem solved.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. nat

    nat Well-Known Member

    Joined:
    Jan 16, 2003
    Messages:
    210
    Likes Received:
    0
    Trophy Points:
    166
    perhaps cpanel should fix this.

    it use to work.

    now i'm getting a client every few days (that was setup long time ago with a - in thier username) telling me their databases no longer work.

    Now that I must changed the username, because it can't handle a - in the username, the clients is going to have to change the absolute path in some of their scripts.

    cPanel.net Support Ticket Number:
     
  7. DTX

    DTX Member

    Joined:
    Mar 16, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Up Grading to the latest Version of Cpanel cured this problem,

    Mysql databases are now created correctly, however some pre-installed scripts like Advanced Guestbook still cause problems. Even though Data Bases are now made correctly, I think the install routine for some of the scripts needs a looking at.

    End of the day, in future I won't allow user names with a - in them just in case (I set all mine up manually by choice)

    But I too, have clients with long established web sites and installed scripts with path names all with a - in them. these in particular do not currently require any Mysql, but should they in future I think it would mean a fair bit of work.

    So for me, Mysql is making databases ok even with a - in username, just can't use some preinstalled scripts using auto install, as the install script is confused by the -

    I'm sure it will be fixed, but at the moment it's not perfect.

    Cheers

    cPanel.net Support Ticket Number:
     
  8. nickn

    nickn Well-Known Member
    PartnerNOC

    Joined:
    Jun 15, 2003
    Messages:
    619
    Likes Received:
    1
    Trophy Points:
    168
    Not everyone is at liberty to change usernames...especially when a company uses a billing manager along side the control panel.

    cPanel.net Support Ticket Number:
     
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