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.

/usr/sbin/mysqld: Table 'plugin' is read only. Cant start my Mysql

Discussion in 'Database Discussions' started by jackaldu, Jul 18, 2014.

  1. jackaldu

    jackaldu Member

    Joined:
    Jul 18, 2014
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Could anybody tell me how can i solve it?

    Code:
    140719 01:22:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140719  1:22:46 [Note] Plugin 'FEDERATED' is disabled.
    /usr/sbin/mysqld: Table 'plugin' is read only
    140719  1:22:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    140719  1:22:46 InnoDB: The InnoDB memory heap is disabled
    140719  1:22:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140719  1:22:46 InnoDB: Compressed tables use zlib 1.2.3
    140719  1:22:46 InnoDB: Using Linux native AIO
    /usr/sbin/mysqld: Can't create/write to file '/tmp/ibOTiTeV' (Errcode: 13)
    140719  1:22:46  InnoDB: Error: unable to create temporary file; errno: 13
    140719  1:22:46 [ERROR] Plugin 'InnoDB' init function returned error.
    140719  1:22:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    140719  1:22:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140719  1:22:46 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140719  1:22:46 [Note] Server socket created on IP: '0.0.0.0'.
    140719  1:22:46 [ERROR] Can't start server : Bind on unix socket: Permission denied
    140719  1:22:46 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    140719  1:22:46 [ERROR] Aborting
    
    140719  1:22:46 [Note] /usr/sbin/mysqld: Shutdown complete
    - - - Updated - - -

    Update still no luck

    Code:
    140719 01:31:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140719  1:31:07 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
    140719  1:31:07 [Note] Plugin 'FEDERATED' is disabled.
    /usr/sbin/mysqld: Table 'plugin' is read only
    140719  1:31:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    140719  1:31:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140719  1:31:07 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140719  1:31:07 [Note] Server socket created on IP: '0.0.0.0'.
    140719  1:31:07 [ERROR] Can't start server : Bind on unix socket: Permission denied
    140719  1:31:07 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    140719  1:31:07 [ERROR] Aborting
    
    140719  1:31:07 [Note] /usr/sbin/mysqld: Shutdown complete
     
  2. jackaldu

    jackaldu Member

    Joined:
    Jul 18, 2014
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I cleared my.cnf and it is now :


    Code:
    root@ns306747 [~]# mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/
    Installing MySQL system tables...
    ERROR: 1036 Table 'db' is read only
    140719 6:53:33 [ERROR] Aborting
    
    140719 6:53:33 [Note] /usr//sbin/mysqld: Shutdown complete
    Still no luck :(
     
  3. jackaldu

    jackaldu Member

    Joined:
    Jul 18, 2014
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator


    Hear is the solution maybe someone will have similar problem.

    Mark from Cpanel solved it. Just have to say to top notch professionalism

    So hear it is

     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page