hi,

i am having loads of problems with mysql

i am running sles 9 but i dont think that should be to much of a problem.

i have just installed the rpms for the mysql server, max and client version 4.1 but i was having the sam problem with the default instalation of mysql that sles comes with. when ever i try to start my sql it failes. i have tried reinstalling the default packages several times plus the ones from mysql.

what is wors i have had mysql working before on the same machine with the the same os installed, this is getting very time consuming as i have been trying for over a day now by googleing but still no look. what is worse i cant realy do anything els untill i have got mysql installed as i need to install php5, apache2 modssl and open ssl but i cant compile php untill sql is working. can anybody please help.

when i su to root and try running mysqld i gt the following output


050418 11:11:16 [Warning] Asked for 196608 thread stack, but got 126976
050418 11:11:16 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

050418 11:11:16 [ERROR] Aborting

050418 11:11:16 [Note] mysqld: Shutdown complete


so now wile i am ritting this post i tried mysqld -u root and it works GREAT (why did i think of this now and not the other day)

any way i still could do with some help with getting it running by itself without the -u root option

thanks for any help

as root, have you tried 'mysqld_safe &' ?