stopping mysqld on bot

[wolf_core]

Hi, I have installed php5 (ver 5.3.3) "on bot" and i have always /usr/local/libexec/mysqld --based running, is possible avoid  to load mysql  when tiny core start, because i only need php5 and mysql use a lot of memory.

Thanks Luca

[curaga]

The mysql startup script starts it. You'd need to edit that, or kill it in bootlocal.sh.

[wolf_core]

HI curaga, i try to do as suggested in an old post adding
mysqladmin --user=root shutdowng
to /opt/bootlocal.sh but the command was rejected.
I look for mysql startup script in /etc/init.d/ services and in /usr/local/etc/init.d/services but it wasn't  there, there is a file my.cnf referred to mysql in /usr/local/etc.

Thanks Luca

[curaga]

/usr/local/tce.installed/mysql inside mysql.tcz.

[wolf_core]

Hi curaga, modify a tcz is to difficult for me  . If i run from console

Code: [Select]

sudo mysqladmin shutdown  all sql process were killed, so i try to added this command to /opt/bootlocal.sh with and without sudo but there are an error and mysql process runs.

Thanks in advance Luca

[Rich]

Hi wolf_core
When someone looking for help states that there is an error, it's customary to share what the error is.
My guess is that mysql has not yet started when the shutdown command executes, of course, that's
just a guess.

[wolf_core]

Hi Rich, the error is shown on system startup before the graphic gui start only for a second, so i can't read it  . Damn I can read it on system boot log    when i come home from office i can post it.

Thanks Luca

[wolf_core]

If i run from console

Code: [Select]

tc@box:/$ sudo mysqladmin shutdownall sql process were killed; so i copy the command in /opt/bootlocal.sh with and without sudo but there is the error

mysqladmin: shutdown failed; error: 'Access denied'; you need the shutdown PRIVILEGE for this operation

Thanks Luca

[Rich]

Hi wolf_core
The bootlocal script runs a s root, so I would think it should adequate permission to perform that operation.
Out of curiosity, what happens if you execute  sudo mysqladmin shutdown  a second time after you've shut it
down from the command line? What message does it give then?

[wolf_core]

Hi Rich,  if i run the command twice it say

Code: [Select]

tc@box:/$ sudo mysqladmin shutdown
tc@box:/$
tc@box:/$ sudo mysqladmin shutdown
tc@box:/$ mysqladmin: connect to server at 'localhost' failed  error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check mysql is running and then the socket '/tmp/mysql.sock' exists!
tc@box:/$

Thanks Luca

[Rich]

Hi wolf_core
OK, I just wanted to be sure the shutdown command wasn't spitting out some bogus error message when it was
run from bootlocal.sh. It looks like it might really be a permission problem, though I'm at a loss to explain it.