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.

Having Problems to Create a New Database

Discussion in 'Database Discussions' started by ketan2net, Nov 5, 2015.

  1. ketan2net

    ketan2net Registered

    Joined:
    Nov 5, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ahmedabad
    cPanel Access Level:
    Root Administrator
    I've Shared Linux Hosting but Having problem for creating Database.


    Error : - The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely: The subprocess reported error 255 when it ended.


    Error :- DBD::mysql::db selectall_arrayref failed: Table './mysql/user' is marked as crashed and should be repaired


    Please Resolve the issue - Immediately..
     

    Attached Files:

  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,145
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    Can you please perform the below command on your server to repair "mysql/user" tables.

    Code:
    service mysql start –skip-grant-tables
    
    mysqlcheck -r mysql user
    
    service mysql stop
    
    service mysql start
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You will need to report this issue to your web hosting provider if you do not have root access to the server. The message indicates the user table in the "mysql" database is corrupted.

    Thank you.
     

Share This Page