unable to create database user on mysql/linux

hi

after creating the database we try to add a extra user but get the error: 73100420

(by the way - whats with the number error mesg. - why not provide something humanreable)

what does 73100420 mean?

Have tried to replicate this issue locally but couldn't, make sure the user you are trying to create not already existed in the Database server.

73100420 :- <Error Error-Code="73100420">Database user could not be added.</Error>

Some common error with code plus description located in C:\Program Files\Advanced Communications\HostingController\INI.

You can also enable logging for database creation issue in HCadmin :: My Server :: Debug setting. After that error time when you will encounter error on db , a log file will generate in db server path C:\Program Files\Advanced Communications\HostingController\log

under

My Server :: Debug Settings

I only have access to the windows servers in the dropdown so no change of altering debug settings for the linux server

There is no user in mysql with the names we are using.

also: found the file of the error mesg. They are not saying any different from what is on the webpage when the error happens - guess its just for easy reference in a ticket to HC then? No indepth info about what actually happend.

First of all Logging option available only for windows panel activities. Secondly if mysql db user is not creating in the linux box then follow these steps

 Access Linux machine and connect mySQL server using following command:
# mysql –u root –p
Once you get connected to mySQL then execute following command:
# grant all privileges on *.* to root@localhost identified by ‘root-password’,root identified by ‘root-password’ with grant option;

or
                OR
# grant all privileges on *.* to root@Server-IP identified by ‘root-password’ with grant option;

Note:
Root-password =  mySQL root user password
Server-IP =  Linux Server IP address

it already has. Its also creating the initial user correct as written.

If you have followed below command and it didn't work then please contact our support department and provide them linux server/HC/mysql root credentials.
# grant all privileges on *.* to root@localhost identified by ‘root-password’,root identified by ‘root-password’ with grant option;