Disable MySQL startup in Ubuntu 10.04

[longanduselessname]

I've put in kill scripts in all run levels - K20mysql...it is still running after boot!

Ah so there is a mysql script... wonder why my command didn't return it.

If it is running as another user, it might be getting triggered somewhere else...

Check if there are .rc files in /root/

Check out the init.d mysql sh script to see how mysql operates.

Find out more about the mysqld user and how it gets started.

Maybe run my grep command with the username instead of mysql.

That's all I got mate gl.

[bryanhogan]

Ah so there is a mysql script... wonder why my command didn't return it.

If it is running as another user, it might be getting triggered somewhere else...

Check if there are .rc files in /root/

Check out the init.d mysql sh script to see how mysql operates.

Find out more about the mysqld user and how it gets started.

Maybe run my grep command with the username instead of mysql.

That's all I got mate gl.

The mysql script is in /etc/inid.d

[bryanhogan]

The mysql script is in /etc/inid.d

Removed the mysql script in /etc/inid.d

I have checked the /root/ for any start up files.

The home directory of the mysql user has no scripts that start on login.

I'm at the stage where I'll have to rename/move the mysqld.

Where else can this be loading from on boot?

[Ramage21]

Removed the mysql script in /etc/inid.d

I have checked the /root/ for any start up files.

The home directory of the mysql user has no scripts that start on login.

I'm at the stage where I'll have to rename/move the mysqld.

Where else can this be loading from on boot?

Lucid uses upstart to launch mysql. All the files are in /etc/init (not init.d). Open the mysql.conf script. The instructions for starting mysql are at the top. As a test, you can # the "start on" line to prevent the service starting on boot up.

I am still looking at this to see how I can properly modify the script to do what I want.

See this for more info on upstart http://upstart.ubuntu.com/

[bryanhogan]

Lucid uses upstart to launch mysql. All the files are in /etc/init (not init.d). Open the mysql.conf script. The instructions for starting mysql are at the top. As a test, you can # the "start on" line to prevent the service starting on boot up.

I am still looking at this to see how I can properly modify the script to do what I want.

See this for more info on upstart http://upstart.ubuntu.com/

Wow, I just figured that out in the last 10 minutes too

Found this link quite useful - http://www.linuxplanet.com/linuxplan...orials/7033/1/

I had done exactly what you suggest, comment out the two lines connected with the "start on".

[Ramage21]

Wow, I just figured that out in the last 10 minutes too

Found this link quite useful - http://www.linuxplanet.com/linuxplan...orials/7033/1/

I had done exactly what you suggest, comment out the two lines connected with the "start on".

What I have now done is add runlevel 2 to the stop line of the script which stops mysql prematurely

# MySQL Service

description     "MySQL Server"
author          "Mario Limonciello <superm1@ubuntu.com>"

start on (net-device-up
          and local-filesystems)
stop on runlevel [0126]

I can then start and stop mysql manually using the service command

Thanks for the info ref

[longanduselessname]

Wow, I just figured that out in the last 10 minutes too

Found this link quite useful - http://www.linuxplanet.com/linuxplan...orials/7033/1/

I had done exactly what you suggest, comment out the two lines connected with the "start on".

I've always wondered how ubuntu started my network card, since /etc/network/interfaces by default doesn't have any configuration for eth0.

Showing my noob colors for not thinking about upstart, or really understanding how it works!

EDIT: Sorry for leading you on wrong track bryanhogan ;_;

[TrombaMarina]

Thanks! To summarize:

sudo vim /etc/init/mysql.conf

Edit it to say the following (I move the 2 from the first set of numbers to the second):

start on (net-device-up and local-filesystems and runlevel [345])
stop on runlevel[0126]

Works like a charm!

reboot
...

initctl list
...
mysql stop/waiting