Can't create DB User

vincentg

• March 30, 2014 16:47

For one account the create db user stopped working. I tried to install Joomla via Softaculous which failed. I then tried to create a database - worked fine. Dropped the database - also worked fine. Tried to create a user - failed. Error stated : You, "xxxxxx," may not create user "xxxxx_test" because it contains unsupported characters. Supported characters include A-Z, a-z, 0-9, and _. Password used was test1234 Viewing log errors shows nothing of interest. So what could cause this for only one account on this server? I say one account because I do not know of any others but have tested create user on other accounts and it works.

• 

  vincentg

  • March 31, 2014 14:08

  I notice that this non ascii char is within the html files of the X3 theme "" I see this several times in adduser.html I see it in a few other files also. What kind of editor was used that created that?

  0
• 

  vincentg

  • March 31, 2014 14:32

  The user name and host name need not be quoted if they are legal as unquoted identifiers. Quotes are necessary to specify a user_name string containing special characters (such as "-"), or a host_name string containing special characters or wildcard characters (such as "%"); for example, 'test-user'@'%.com'. This is the problem! It seems that somewhere down the road they changed the way users are created!!! So in my case the user has a dash in the name. I think this should be thought out better before a change is made such as this. Where do we fix this???

  0
• 

  Audiopro

  • March 31, 2014 14:37

  Can I just confirm something? [QUOTE]I then tried to create a database - worked fine. Dropped the database - also worked fine. Tried to create a user - failed.
  That leaves you with no database

  0
• 

  vincentg

  • March 31, 2014 15:11

  Since I didn't know why the application installer failed to create the database I created a test db. I just wanted to see if it would create a DB so i created a db named test. Having done that I then tried to create a user which failed. From what I see a recent update March 19th took place which caused this problem. From what I have checked it looks to be a MySql error and this is most likely due to passing it without quotes which MySql states will only allow standard chars.

  0
• 

  vincentg

  • March 31, 2014 15:34

  Looking into it I find that at some point Cpanel had changed the way they create users. Long ago it would create a user from a domain named my-host.com as my-host whereas now they remove the dash. So I have a website that has the dash in the user name. It would be nice if cpanel would tell me how to remove the dash without too much pain or how to fix the script to allow the dash

  0
• 

  vincentg

  • March 31, 2014 22:43

  Solved it. I never noticed that Cpanel added to modify user the ability to change the user name. I changed the user name to remove the dash within the name Next problem was to alter any scripts config files Also had to alter the Database user names in two tables in the MYSQL db All works proper now.

  0
• 

  cPanelMichael

  • April 01, 2014 19:21

  Hello :) I am happy to see you were able to successfully modify the account username to a supported format. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.