ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Subject:   mysqld ended...waaahhh
Date:   2005-06-18 00:46:07
From:   trial_and_error
Response to: mysqld ended...waaahhh

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?