madman
January 25th, 2003, 20:22
Hey guys, my first post here, hopefully if nobody minds I could really use some help!!!!

Ok, I'm trying to get MySQL running on my OBSD... everything seems fine, except I've seen everywhere on the net the problems with safe_mysqld and its seeming inability to work properly without some reconaissance (sp?). Anyways, I try to run safe_mysqld and it:

bash-2.05b# safe_mysqld
Starting mysqld daemon with databases from /var/mysql
030126 01:34:20 mysqld ended

ends instantly. However, before a reinstal the safe_mysqld was locking me up completely, though I was still able to access mysql. However, root couldn't access.

Sorry about the jumbled email, I'm gettting a cold and fever from sitting in front of my PC for the past day trying to figure out this crapola. If anyone knows a good resource for installing mysql and getting it to work that would be awesome... or any tips/commands that I might try to get the daemon to run.

Thanks in advance guys. Have a wonderfull morning/day/evening!

elmore
January 25th, 2003, 20:29
Hey madman welcome. First things to check is /var/mysql/errorlog or whatever. Read it and post it up here. We'll get you squared away quickly.

madman
January 25th, 2003, 20:39
OK its almost 900 lines cant page up that high, but hopefully the last logs might provide an answer... who knows, I've been working on this so long I could have dug quite the ditch...


030126 01:42:30 mysqld started
030126 1:42:30 Can't start server: Bind on TCP/IP port: Address already in use
030126 1:42:30 Do you already have another mysqld server running on port: 3306 ?
030126 1:42:30 Aborting

030126 1:42:30 /usr/local/libexec/mysqld: Shutdown Complete

030126 01:42:30 mysqld ended

030126 01:44:09 mysqld started
/usr/local/libexec/mysqld: Too many parameters
/usr/local/libexec/mysqld Ver 3.23.54 for unknown-openbsd3.2 on i386
Use '--help' or '--no-defaults --help' for a list of available options
030126 01:44:09 mysqld ended

Thanks a bunch for all your help!

madman
January 25th, 2003, 20:53
ok so i rebooted... now Im getting locked up again, it seems its trying to start the daemon but never does... grr

madman
January 25th, 2003, 20:56
and the log says its started... break commands dont work, the lockup requires closing, as far as i can tell, anyone know a better solution?

v902
January 25th, 2003, 21:00
do netstat -an and post the results also do ps aux|grep mysqld

bsdjunkie
January 25th, 2003, 22:13
I was seeing this on OS X> run safe_mysql with options for user and pass.

./safe_mysqld -user blah -p

madman
January 25th, 2003, 23:02
hey guys thanks so much for your help... actually a restart fixed it... i don't know if thats the best but whatever i guess, its working!!! sounds good to me!

Thanks again for all your help!!