Trouble installing MySQL on Mac OS X Tiger (10.4)

[rockstardub]

I have searched all over the internet, and tried to learn how to do this. It's not really up my alley, so please someone tell me what to do! Here are some of the things I type and the messages I get with them.

kirk:/usr/local/mysql kirkstrobeck$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

kirk:~ kirkstrobeck$ cd /usr/local/mysql
kirk:/usr/local/mysql kirkstrobeck$ sudo echo
Password:

kirk:/usr/local/mysql kirkstrobeck$ sudo ./bin/mysqld_safe &
[1] 461
kirk:/usr/local/mysql kirkstrobeck$ Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/kirk.pid
050601 13:09:08  mysqld ended

It looks like it starts up, then simply quits! I don't know, please help.

 

[macubergeek]

The problem is you have not assigned a password to the root account. Mysqld won't start up with a blank root password.
do:
$mysqladmin -u root -p
Enter password: <enter the root password you want here> <enter>
then as root do:
mysqld_safe &
this will start the mysqld server.

Depending on how you installed this, I believe the official Macos X binary distribution includes a Preferences Panel from which you can start and stop mysqld as well as set it to start on boot up.

 

[rockstardub]

Doesn't Work.

 Last login: Thu Jun  9 20:41:44 on console
Welcome to Darwin!
kirk:~ kirkstrobeck$ cd /usr/local/mysql
kirk:/usr/local/mysql kirkstrobeck$ bin/mysql -u root
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
kirk:/usr/local/mysql kirkstrobeck$

 

[rockstardub]

This works to start it though

cd /usr/local/mysql; 
sudo echo 
sudo ./bin/mysqld_safe &

 

[rockstardub]

Please help me solve this problem.
I have tried so many things, and still this is what happens...

Last login: Fri Jun 10 18:32:02 on ttyp1
Welcome to Darwin!
kirk:~ kirkstrobeck$ cd /usr/local/mysql/bin
kirk:/usr/local/mysql/bin kirkstrobeck$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
kirk:/usr/local/mysql/bin kirkstrobeck$

 

[rockstardub]

I tried exactly what "macubergeek" said and this is what I got

kirk:~ kirkstrobeck$ mysqld_safe &
[1] 2363
kirk:~ kirkstrobeck$ touch: /usr/local/mysql/data/kirk.local.err: Permission denied
chown: /usr/local/mysql/data/kirk.local.err: Permission denied
Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 311: /usr/local/mysql/data/kirk.local.err: Permission denied
rm: /usr/local/mysql/data/kirk.local.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 317: /usr/local/mysql/data/kirk.local.err: Permission denied
STOPPING server from pid file /usr/local/mysql/data/kirk.local.pid
tee: /usr/local/mysql/data/kirk.local.err: Permission denied
050620 14:45:54  mysqld ended
tee: /usr/local/mysql/data/kirk.local.err: Permission denied