OK - I am trying to work with MySql, having all sorts of probs. I got phpmyadmin installed, but realized I forgot the root pwd. Searched threads here, learned much. Followed instr at http://www.mysql.com/articles/ddws/56.html to try and reset pwd, no luck.

When I do a ps -e I get like 4 mysqld process numbers. I killed them all, went to restart safe_mysqld --skip-grant-tables and the process hung - - - meaning that my cursor just blinked and blinked.

Rebooted machine - now I show 3 msqld and one safe_mysqld process. kill -9 all 4 proc. Try to restart safe_myslfd and same thing - blinking cursor.

Tried to connect using safe_mysqld - got an error that said "rm failed - couldn't remove yourdomain.com.pid . Remove the file manually and restart safe_mysqld ". I found the file, deleted it, went through the whole process again and still nothing!!

BTW - I have a RaQ 3 and Cobalt MySQL Release 3.23.37-1 .

Please Help!!!

Mark

:angry:

OK - my head has cleared a little - I have gone from :angry: to :bawling: and now I am back to :confused: !!

A couple of more direct questions:

1) How can I kill all mysql processes so I can try another re-start of safe_mysql?

2) If I un-install and re-install the pkg will I have to re-compile php so they will interact properly?

Thanks!

OK - for the sake of posterity and effective forum searching, I got MySql and PhPmyAdmin running smoothly. I'm not sure if what I did was the easiest or the best way to do it, but here is the process:

I did all commands as the root user.

1) Locate any running mysqld proccesses with #ps -e
2) Kill the proccesses with #kill [proc number]
3) Uninstalled the package /var/lib/cobalt/uninstallers# ./RaQ3-RaQ4-MySQL-3.23.37-1.uninstall
(you may need to verify your pkg. Go to the above directory and run #ls to get the correct uninstaller)
4) Went to home/mysql ran #ls
5) Did #rm -r on all files & directories listed in above ls .
**WARNING** this will delete and databases you have installed!
6) Re installed pkg from http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-3.23.37-1.pkg (actually, I used wget to move it to a local directory, but you don't HAVE to do that.
7) Ran #mysqladmin -uroot -pcobalt-mysql password NEWPASSWORD
8) Went to PhPmyAdmin directory , #PICO config.inc.php and changed user/password variables

TADA!!

I'm all happy.

Hope this helps someone else.