Lockedunable to create database user on mysql/linux

Author
agermose
Senior Member
2009/11/03 02:47:59 (permalink)

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?
#1

5 Replies Related Threads

    HC Team
    Hosting Controller
    Re:unable to create database user on mysql/linux 2009/11/03 03:06:40 (permalink)
    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


    #2
    agermose
    Senior Member
    Re:unable to create database user on mysql/linux 2009/11/03 03:19:07 (permalink)
    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.
    #3
    Tahir
    HC Staff
    Re:unable to create database user on mysql/linux 2009/11/03 19:52:04 (permalink)
    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

    #4
    agermose
    Senior Member
    Re:unable to create database user on mysql/linux 2009/11/04 00:11:14 (permalink)
    it already has. Its also creating the initial user correct as written.
    #5
    Tahir
    HC Staff
    Re:unable to create database user on mysql/linux 2009/11/04 00:55:04 (permalink)
    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;


    #6
    Jump to: