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 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:
    1
    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:
    16
    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,426
    Likes Received:
    2
    Trophy Points:
    38
    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:
    1
    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:
    36
    Perhaps you should just modify the username so that it doesn't have a hyphen in it--problem solved.

    cPanel.net Support Ticket Number:
     
  6. nat

    nat Well-Known Member

    Joined:
    Jan 16, 2003
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    16
    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:
    1
    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:
    18
    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