Re: [rock-user] Re : Re : Mysql installation cannot connect, cannot start

Am Donnerstag, 23. November 2006 14:41 schrieb Stefan Fiedler:
> Am Donnerstag, 23. November 2006 11:49 schrieb philippe florent:
> > I don't understand,
> > 1st time i launch mysqld_safe , it gives error, cannot find log file .e=
rr
> > then second time, it cannot find the mysqld
> > now it can find it but i got an error saying I cannot start the mysql
> > daemon as root, i cannot find the security pages in man...
>
...
>
> Running mysqld_safe requires the /var/opt/mysql directory to exist. I used
> the following permissions:
> 	drwxr-xr-x 2 root root 4096 2006-11-23 14:04 /var/opt/mysql/
> Maybe this directory is created by another mysql program, or it should be
> part of the mysql package, I'm not sure.
>
> To run mysqld_safe as root, use the --user=3Droot option, e.g.
> in /etc/rc.d/init.d/mysql change the line:
>        (/opt/mysql/bin/mysqld_safe >/dev/null 2>&1 &) || error=3D$?
> to
>        (/opt/mysql/bin/mysqld_safe --user=3Droot >/dev/null 2>&1 &) ||
> error=3D$? Again I'm not sure whether this is the best option, maybe add =
and
> use a 'mysql' user?
>

Hi there!

One more update to my previous mail: if /var/opt/mysql is owned by mysql us=
er, =

mysql group (try 'chmod mysql:mysql -R /var/opt/mysql'), you can skip =

the --user=3Droot option to mysqld_safe (i.e. keep the original version =

of /etc/rc.d/init.d/mysql).

With best regards,
	Stefan Fiedler

-- =

People demand freedom of speech as a compensation for the freedom of though=
t =

which they seldom use.
  S=F8ren Kierkegaard