Women in Technology

Article:		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 skip-innodb 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 http://www.innodb.com/ibman.html 020313 20:11:08 /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/localhost.pid' (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/localhost.pid' (Errcode: 13) 020313 20:11:08 mysqld ended

Showing messages 1 through 7 of 7.

• MySQL won't start
  2002-03-13 20:28:10  Morbus Iff | [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 localhost.pid 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?
• MySQL won't start - one more thing
  2002-03-13 20:30:31  Morbus Iff | [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!