Apache Web-Serving With Mac OS X, Part 5
Subject:   MySQL won't start
Date:   2002-03-13 17:16:40
From:   saywake
Here's the 'localhost.err' lines everytime I try to start it....I'm pretty certain that I've done all the steps (including adding the mysql user). Thoughts?

020313 20:11:08 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add for example,
innodb_data_file_path = ibdata1:30M
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
020313 20:11:08 /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/' (Errcode: 13)
020313 20:11:08 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
020313 20:11:08 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/' (Errcode: 13)
020313 20:11:08 mysqld ended

Full Threads Oldest First

Showing messages 1 through 7 of 7.

  • Morbus Iff photo MySQL won't start
    2002-03-13 20:28:10  Morbus Iff | O'Reilly Author [View]

    Hmm. I'm wondering if one of the steps needs a slight modification. Do this for me and let me know if it works for you, please. If so, I'll get the article corrected.

    sudo chown -R mysql /usr/local/var

    This is a minor change from the article currently says, but may be crucial to what your problem is. Let me know.
    • MySQL won't start
      2002-08-16 12:52:59  syn_raziel [View]

      Hi, i'm getting the same errors dealing with and stuff. I tried
      sudo chown -R mysql /usr/local/var
      but it didn't work either
      • MySQL won't start
        2005-01-20 16:26:14  jsswg0 [View]

        Try looking at the permissions in the data directory. I had a similar problem because I ran the mysql_install_db script as root. Once I changed the owner and group of the files in the data direcotry to the mysql user and group, mysqld started just fine:
        chown mysql data/*
        chgrp mysql data/*
  • MySQL won't start
    2002-03-13 18:42:34  andycrim1 [View]

    It looks like we have the same problem. I followed the instructions to the letter, and I am puzzled that I can't get mysql to work. I have been trying to get it installed for about a week. I've tried fink and the binary distro from Marc Liyanage, but to no avail.

    I'll probably try one more time from source code.
  • MySQL won't start - one more thing
    2002-03-13 18:32:08  saywake [View]

    when I first run the mysql_install_db, I get this error:
    [localhost:/usr/local] root# ./bin/mysql_install_db
    Preparing db table
    Preparing host table
    Preparing user table
    Preparing func table
    Preparing tables_priv table
    Preparing columns_priv table
    Installing all prepared tables
    ERROR: 1062 Duplicate entry 'localhost-root' for key 1
    ERROR: 1062 Duplicate entry 'localhost-root' for key 1
    020313 21:26:36 /usr/local/libexec/mysqld: Shutdown Complete

    This has happened on 2 separate attempts on 2 different machines...what am I doing wrong?
    • Morbus Iff photo MySQL won't start - one more thing
      2002-03-13 20:30:31  Morbus Iff | O'Reilly Author [View]

      The "Duplicate entry" error message isn't too worrisome - I saw it on my own machine initially as well. Basically, one of the things that the install_db script does is to give the local user (you) access to the database. This error message is saying you already have access to the database. It's nothing you're doing wrong, and the error message you reported in an earlier message wouldn't be affected by this.
      • MySQL won't start - one more thing
        2002-03-13 21:58:06  andycrim1 [View]

        After reinstalling from source everything is now working. Thanks!