[ILUG] Mysql

[Ciaran Johnston]

Linux ilug wrote:

>Fixed it for some reason, i had to use this command:
>
>bin/mysqld_safe --user=mysql &
>
>where as the exact same setup in college works with:
>
>./mysqld &
>  
>
It's obviously not the same setup, since it doesn't work the same way :-)

mysqld_safe is a shell script, so it's easy enough to check what options 
it takes. You can "ps -ef | grep mysql" to figure out what options were 
actually passed to the mysqld command, and you can edit / create a 
my.cnf file to set some default values (you can probably find examples 
in /usr/local/mysql/share, or check the one used in college).

Glad to hear it's working, anyway.

>And the best part about it is I have absolutely no idea why! God Linux hates me
>  
>
I don't believe Linux has any feelings towards you, good or bad. The 
trouble is it usually does what you tell it to, which isn't always what 
you mean.

/Ciaran.