Women in Technology

Article:		Apache Web-Serving With Mac OS X, Part 5
Subject:		mysqld ended...waaahhh
Date:		2003-12-15 06:01:03
From:		anonymous2
Response to: mysqld ended...waaahhh
To me it was enough the chown command.. anyway thanx a lot i was getting crazy with it!!! Bye Massimo

Showing messages 1 through 1 of 1.

• mysqld ended...waaahhh
  2005-06-18 00:46:07  trial_and_error [View]
  
  
  Hiya
  
  I wrestled with this same problem for hours (Mac Powerbook/Unix).
  
  When I eventually did get it working, after following dozens of threads, I'm not even sure how I did it. For a start, downgrading to PHP 4.0.24 might have helped (restarting after wiping the old version, then again after new install).
  
  I thought I'd paste my last few steps below in the hope you'll be able to decipher it:
  
  
lepadouen:/usr/local/mysql root# ./bin/mysqld_safe
Starting mysqld daemon with databases from /Library/MySQL/var
STOPPING server from pid file /Library/MySQL/var/lepadouen.plus.com.pid
050523 22:31:49 mysqld ended

lepadouen:/usr/local/mysql root# sudo chown -R mysql data/
lepadouen:/usr/local/mysql root# sudo echo

lepadouen:/usr/local/mysql root# ./bin/mysqld_safe &
[1] 573
lepadouen:/usr/local/mysql root# Starting mysqld daemon with databases from /Library/MySQL/var
STOPPING server from pid file /Library/MySQL/var/lepadouen.plus.com.pid
050523 22:32:59 mysqld ended

<root# sudo find /usr/local/mysql/data -type f -exec rm {} ';'
[1]+ Done ./bin/mysqld_safe
<root# sudo find /usr/local/mysql/data -type f -exec rm {} ';'
lepadouen:/usr/local/mysql root# sudo hostname 127.0.0.1
lepadouen:/usr/local/mysql root# cd /usr/local/mysql
lepadouen:/usr/local/mysql root# sudo ./scripts/mysql_install_db
sudo: ./scripts/mysql_install_db: command not found
lepadouen:/usr/local/mysql 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
050523 22:34:55 Warning: Setting lower_case_table_names=2 because file system for /Library/MySQL/var/ is case insensitive
050523 22:34:55 /Library/MySQL/libexec/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/Library/MySQL/bin/mysqladmin -u root password 'new-password'
/Library/MySQL/bin/mysqladmin -u root -h 127.0.0.1 password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /Library/MySQL ; /Library/MySQL/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /Library/MySQL/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

lepadouen:/usr/local/mysql root# sudo echo

lepadouen:/usr/local/mysql root# /Library/MySQL/bin/mysqld_safe &
[1] 608
lepadouen:/usr/local/mysql root# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/127.0.0.1.pid
050523 22:35:21 mysqld ended

sudo chown -R mysql data/
[1]+ Done /Library/MySQL/bin/mysqld_safe
lepadouen:/usr/local/mysql root#
lepadouen:/usr/local/mysql root# /Library/MySQL/bin/mysqld_safe &
[1] 627
lepadouen:/usr/local/mysql root# Starting mysqld daemon with databases from /usr/local/mysql/var
</code>


Hope that helps?