Is root required to start/stop/restart mysql?

sandrob · 2012-03-09 02:23:01

I'm trying to have all users in the mysql be able to start/stop/restart mysql. I'm currently getting permission denied for the /var/lib/mysql folder even though I'm logged in as a user that is a member of the mysql group (and mysql is the owner of the directory)

Is what I am trying to achieve possible?

I'm not sure if this is related but I am also unable to start mysql from rc.d on bootup, but once I am logged in I can use the root user to start it up.

Thank you!

karol · 2012-03-09 02:29:00

How are you trying to start it on bootup? Did you add mysqld to the DAEMONS array? Are you using systemd?
Have you read https://wiki.archlinux.org/index.php/My … leshooting ?

sandrob · 2012-03-09 03:08:50

Yes, mysqld is the last entry in DAEMONS in /etc/rc.conf.
I do not use systemd.
Do you think that not being able to start mysql at bootup is related to not being able to start it without root?

Gcool · 2012-03-09 09:09:15

Not being able to start the daemon as a non-root user is pretty much the expected behaviour. Why would you want to do this exactly?

As for mysqld not getting started during boot; check /var/log/everything.log for possible clues.

sandrob · 2012-03-09 20:10:11

Well, I guess starting mysql as non root is a non-issue if the darn thing would start at boot. I grepped /var/lob/everything.log for sql but nothing. What should I be looking for?

karol · 2012-03-09 20:13:56

Did you read https://wiki.archlinux.org/index.php/My … nnot_start ?

sandrob · 2012-03-09 20:18:14

Yes, I've gone through all of the documentation. It works when I run it. But it doesn't automatically happen on bootup.

Gcool · 2012-03-09 22:55:22

This is a long shot, but which bind ip do you have configured in your mysqld config? If you for example have it set to your external interface ip and this interface is not up yet during the boot process when mysqld is started; it'll fail to start.

Setting the bind ip to 0.0.0.0 should solve this in that case.

sandrob · 2012-03-10 00:54:14

I added bind-address = 0.0.0.0 to my server config, still nothing.

kaen · 2012-03-10 01:35:37

/etc/rc.d/mysqld wrote:

/usr/bin/mysqld_safe --user=mysql &>/dev/null &

Doesn't mysqld get started as mysql user by default?

Did you modify any of mysql's configuration files while trying to do this? I imagine that would cause troubles for you.
Post anything else you think is relevant, too.

Arch Linux

#1 2012-03-09 02:23:01

Is root required to start/stop/restart mysql?

#2 2012-03-09 02:29:00

Re: Is root required to start/stop/restart mysql?

#3 2012-03-09 03:08:50

Re: Is root required to start/stop/restart mysql?

#4 2012-03-09 09:09:15

Re: Is root required to start/stop/restart mysql?

#5 2012-03-09 20:10:11

Re: Is root required to start/stop/restart mysql?

#6 2012-03-09 20:13:56

Re: Is root required to start/stop/restart mysql?

#7 2012-03-09 20:18:14

Re: Is root required to start/stop/restart mysql?

#8 2012-03-09 22:55:22

Re: Is root required to start/stop/restart mysql?

#9 2012-03-10 00:54:14

Re: Is root required to start/stop/restart mysql?

#10 2012-03-10 01:35:37

Re: Is root required to start/stop/restart mysql?

Board footer