alright. i have a clean install of mysql 3.23.33 on a red hat 7 workstation running apache. now, when i try to start the mysql server it starts and then ends. upon looking in the error log file this is the error it reports:

mysqld started
/usr/libexec/mysqld: can't find file './mysql/host.frm' (errno 13)
mysqld ended

so i did a search to find the location of the host.frm file and it is located at /var/lib/mysql/mysql/host.frm

from the error message, i gather that it is looking for the host.frm file at this location: /usr/libexec/mysql/host.frm

is that right or do i have it wrong? can i create a directory there and just copy the host.frm file into it or is there a config file somewhere that i don't know about that i have to change the location? any help would be great.

thanks in advance.

chris

    The path is right, it needs to be in /var/lib/mysql/mysql, but from my experience the permissions are probably wrong on the file.

    If you chown the files under /var/lib/mysql to the mysql user and group it should work.

    This has been my experience using 3.23.32 on RH 7.

    Hope that helps!

      thank you. i found this in a post in the mysql section as well. it solved a lot of head pounding into my desk

        2 months later
        19 days later

        Thanx, you saved me. I was banging my head.
        bye.

          yes...
          cd /var/www/mysql
          chown -R mysql.mysql ./*

            19 days later

            You guys are the best ...thanks .....

              7 days later
              16 days later

              Worked great for me too.
              Thanks.

                Hi,

                It works fine ! Thank you !!!

                Davi Silva

                  15 days later

                  SEI UN GRANDEEEEEEEEEEEE !!!!!!!!!! GRAZIEEEEEEEEEEEEEEEEEE TI AMIAMO FORTE E DURO !!!!!!!!!

                    a month later

                    cd /var/lib/mysql
                    chown -R mysql.mysql ./*

                    in slackware ...

                    thanx for the help ...

                    /Björn

                      hallelujah!
                      Thanks for the good advice.

                        2 months later

                        Many many many tanks... errr... thanks guys. It solved my problem too. 😉

                          5 days later

                          thanks a lot! it worked

                            11 days later

                            I use SUSE LINUX 7.3 Prof.
                            There is no group \"mysql\".

                            So it worked with:

                            cd /var/lib/mysql
                            chown -R mysql.daemon ./*

                            Thanx for the
                            solution of it.

                              Months later, you are still saving the world from crappy permissions/ownership issues in mysql! Kudos!

                              --juggler

                                5 days later

                                it was the case for the mysql 3.23.41 package in the SuSE 7.3 distro too...

                                  Thanks! This helped me as well. (Slackware 8.0)