Announcement

Collapse
No announcement yet.

MySQL service could not get started in Linux server.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL service could not get started in Linux server.

    MySQL service could not get started in Linux server.


  • #2
    Hello Nikhil,

    It might be Due to junk characters in 'my.cnf', MySQL service could not get started.

    Upon checking we have noticed following error logs InnoDB at/var/log/mysql.
    InnoDB: Error: trying to add tablespace 325 of name './database_name/core_session.ibd'
    InnoDB: to the tablespace memory cache, but tablespaceInnoDB: 325 of name './databasename/phpfox_pages_perm.ibd' already exists in the tablespaceInnoDB: memory cache.

    Regards,
    David

    Comment


    • #3
      Hello Nikhil,
      Even with correct ownership, MySQL might fail to start up if there is other security software running on your system that manages application access to various parts of the file system. In this case, reconfigure that software to enable mysql to access the directories it uses during normal operation.

      Regards,
      Nora Kirk

      Comment


      • #4
        Hello Nikhil_1996,

        First, make sure that MySQL is installed on your server by the below steps-

        Step1:

        cat /etc/my.cnf
        get data directory from here suppose it is /var/lib/mysql

        Step2: Check if all related Mysql files are there-

        ls -lh /var/lib/mysql
        You can also check by the below command:

        ls /etc/init.d | grep MySQL
        If everything is ok and still showing unrecognized. Then you have to check if the same IP allotted to some other server.

        Regards,
        Vineeta.

        Comment

        Working...
        X