MySQL нужна помощь по установке - Компьютерный форум OSzone.net

По идее, запуск дожен осуществлятся скриптом из /etc/init.d:
Код:
 

#!/bin/sh 

# Copyright Abandoned 1996 TCX DataKonsult AB &amp; Monty Program KB &amp; Detron HB 

# This file is public domain and comes with NO WARRANTY of any kind 

 

# MySQL daemon start/stop script. 

 

# Usually this is put in /etc/init.d (at least on machines SYSV R4 based 

# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. 

# When this is done the mysql server will be started when the machine is 

# started and shut down when the systems goes down. 

 

# Comments to support chkconfig on RedHat Linux 

# chkconfig: 2345 90 20 

# description: A very fast and reliable SQL database engine. 

 

# Comments to support LSB init script conventions 

### BEGIN INIT INFO 

# Provides: mysql 

# Required-Start: $local_fs $network $remote_fs 

# Required-Stop: $local_fs $network $remote_fs 

# Default-Start: &nbsp;2 3 4 5 

# Default-Stop: 0 1 6 

# Short-Description: start and stop MySQL 

# Description: MySQL is a very fast and reliable SQL database engine. 

### END INIT INFO 

 

# If you install MySQL on some other places than /, then you 

# have to do one of the following things for this script to work: 

# 

# - Run this script from within the MySQL installation directory 

# - Create a /etc/my.cnf file with the following information: 

# &nbsp; [mysqld] 

# &nbsp; basedir=&lt;path-to-mysql-installation-directory&gt; 

# - Add the above to any other configuration file (for example ~/.my.ini) 

# &nbsp; and copy my_print_defaults to /usr/bin 

# - Add the path to the mysql-installation-directory to the basedir variable 

# &nbsp; below. 

# 

# If you want to affect other MySQL variables, you should make your changes 

# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. 

 

basedir= 

 

# The following variables are only set for letting mysql.server find things. 

 

# cbelisle@mandrakesoft : We need it to get the functions. 

INITD=/etc/rc.d/init.d 

. $INITD/functions 

 

# Set some defaults 

datadir=/var/lib/mysql 

pid_file= 

if test -z &quot;$basedir&quot; 

then 

 &nbsp;basedir=/ 

 &nbsp;bindir=/usr/bin 

else 

 &nbsp;bindir=&quot;$basedir/bin&quot; 

fi 

 

PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin 

export PATH 

 

if test -z &quot;$pid_file&quot; 

then 

 &nbsp;pid_file=$datadir/`/bin/hostname`.pid 

else 

 &nbsp;case &quot;$pid_file&quot; in 

 &nbsp; &nbsp;/* ) ;; 

 &nbsp; &nbsp;* ) &nbsp;pid_file=&quot;$datadir/$pid_file&quot; ;; 

 &nbsp;esac 

fi 

 

mode=$1 &nbsp; &nbsp;# start or stop 

 

parse_arguments() { 

 &nbsp;for arg do 

 &nbsp; &nbsp;case &quot;$arg&quot; in 

 &nbsp; &nbsp; &nbsp;--basedir=*) &nbsp;basedir=`echo &quot;$arg&quot; | sed -e 's/^[^=]*=//'` ;; 

 &nbsp; &nbsp; &nbsp;--datadir=*) &nbsp;datadir=`echo &quot;$arg&quot; | sed -e 's/^[^=]*=//'` ;; 

 &nbsp; &nbsp; &nbsp;--pid-file=*) pid_file=`echo &quot;$arg&quot; | sed -e 's/^[^=]*=//'` ;; 

 &nbsp; &nbsp;esac 

 &nbsp;done 

} 

 

# Get arguments from the my.cnf file, 

# groups [mysqld] [mysql_server] and [mysql.server] 

if test -x ./bin/my_print_defaults 

then 

 &nbsp;print_defaults=&quot;./bin/my_print_defaults&quot; 

elif test -x $bindir/my_print_defaults 

then 

 &nbsp;print_defaults=&quot;$bindir/my_print_defaults&quot; 

elif test -x $bindir/mysql_print_defaults 

then 

 &nbsp;print_defaults=&quot;$bindir/mysql_print_defaults&quot; 

else 

 &nbsp;# Try to find basedir in /etc/my.cnf 

 &nbsp;conf=/etc/my.cnf 

 &nbsp;print_defaults= 

 &nbsp;if test -r $conf 

 &nbsp;then 

 &nbsp; &nbsp;subpat='^[^=]*basedir[^=]*=\(.*\)$' 

 &nbsp; &nbsp;dirs=`sed -e &quot;/$subpat/!d&quot; -e 's//\1/' $conf` 

 &nbsp; &nbsp;for d in $dirs 

 &nbsp; &nbsp;do 

 &nbsp; &nbsp; &nbsp;d=`echo $d | sed -e 's/[         ]//g'` 

 &nbsp; &nbsp; &nbsp;if test -x &quot;$d/bin/my_print_defaults&quot; 

 &nbsp; &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp; &nbsp;print_defaults=&quot;$d/bin/my_print_defaults&quot; 

 &nbsp; &nbsp; &nbsp; &nbsp;break 

 &nbsp; &nbsp; &nbsp;fi 

 &nbsp; &nbsp; &nbsp;if test -x &quot;$d/bin/mysql_print_defaults&quot; 

 &nbsp; &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp; &nbsp;print_defaults=&quot;$d/bin/mysql_print_defaults&quot; 

 &nbsp; &nbsp; &nbsp; &nbsp;break 

 &nbsp; &nbsp; &nbsp;fi 

 &nbsp; &nbsp;done 

 &nbsp;fi 

 

 &nbsp;# Hope it's in the PATH ... but I doubt it 

 &nbsp;test -z &quot;$print_defaults&quot; &amp;&amp; print_defaults=&quot;my_print_defaults&quot; 

fi 

 

# 

# Test if someone changed datadir; &nbsp;In this case we should also read the 

# default arguments from this directory 

# 

 

extra_args=&quot;&quot; 

if test &quot;$datadir&quot; != &quot;/var/lib/mysql&quot; 

then 

 &nbsp;extra_args=&quot;-e $datadir/my.cnf&quot; 

fi 

 

parse_arguments `$print_defaults $extra_args mysqld mysql_server mysql.server` 

 

# Safeguard (relative paths, core dumps..) 

cd $basedir 

 

case &quot;$mode&quot; in 

 &nbsp;'start') 

 &nbsp; &nbsp;# Start daemon 

 

 &nbsp; &nbsp;TMPDIR=/tmp 

 &nbsp; &nbsp;export TMPDIR 

 &nbsp; &nbsp;TMP=/tmp 

 &nbsp; &nbsp;export TMP 

 

 &nbsp; &nbsp;if test -x $bindir/mysqld_safe 

 &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp;# Give extra arguments to mysqld with the my.cnf file. This script may 

 &nbsp; &nbsp; &nbsp;# be overwritten at next upgrade. 

 &nbsp; &nbsp; &nbsp;gprintf &quot;Starting MySQL Server&quot; &nbsp; &nbsp; &nbsp; 

 &nbsp; &nbsp; &nbsp;$bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file 2&gt;&amp;1 | logger -t mysqld_safe &amp; 

 &nbsp; &nbsp; &nbsp;success 

 &nbsp; &nbsp; &nbsp;# Make lock for RedHat / SuSE 

 &nbsp; &nbsp; &nbsp;if test -w /var/lock/subsys 

 &nbsp; &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp; &nbsp;touch /var/lock/subsys/mysql 

 &nbsp; &nbsp; &nbsp;fi 

 &nbsp; &nbsp; &nbsp;echo 

 &nbsp; &nbsp;else 

 &nbsp; &nbsp; &nbsp;gprintf &quot;Can't execute %s/mysqld_safe from dir %s\n&quot; &quot;$bindir&quot; &quot;$basedir&quot; 

 &nbsp; &nbsp;fi 

 &nbsp; &nbsp;;; 

 

 &nbsp;'stop') 

 &nbsp; &nbsp;# Stop daemon. We use a signal here to avoid having to know the 

 &nbsp; &nbsp;# root password. 

 &nbsp; &nbsp;unset TMPDIR 

 &nbsp; &nbsp;unset TMP 

 &nbsp; &nbsp;gprintf &quot;Stopping MySQL Server\n&quot; &nbsp; &nbsp; 

 &nbsp; &nbsp;if test -s &quot;$pid_file&quot; 

 &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp;mysqld_pid=`cat $pid_file` 

 &nbsp; &nbsp; &nbsp;kill $mysqld_pid 

 &nbsp; &nbsp; &nbsp;gprintf &quot;(pid %s)&quot; &quot;$mysqld_pid&quot; 

 &nbsp; &nbsp; &nbsp;# mysqld should remove the pid_file when it exits, so wait for it. 

 

 &nbsp; &nbsp; &nbsp;sleep 1 

 &nbsp; &nbsp; &nbsp;while [ -s $pid_file -a &quot;$flags&quot; != aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ] 

 &nbsp; &nbsp; &nbsp;do 

 &nbsp; &nbsp; &nbsp; &nbsp;[ -z &quot;$flags&quot; ] &amp;&amp; echo &quot;Wait for mysqld to exit\c&quot; || echo &quot;.\c&quot; 

 &nbsp; &nbsp; &nbsp; &nbsp;flags=a$flags 

 &nbsp; &nbsp; &nbsp; &nbsp;sleep 1 

 &nbsp; &nbsp; &nbsp;done 

 &nbsp; &nbsp; &nbsp;if [ -s $pid_file ] 

 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;then failure &quot; gave up waiting!&quot; 

 &nbsp; &nbsp; &nbsp;elif [ -n &quot;$flags&quot; ] 

 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;then success 

 &nbsp; &nbsp; &nbsp;else 

 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;success 

 &nbsp; &nbsp; &nbsp;fi 

 &nbsp; &nbsp; &nbsp;# delete lock for RedHat / SuSE 

 &nbsp; &nbsp; &nbsp;if test -f /var/lock/subsys/mysql 

 &nbsp; &nbsp; &nbsp;then 

 &nbsp; &nbsp; &nbsp; &nbsp;rm /var/lock/subsys/mysql 

 &nbsp; &nbsp; &nbsp;fi 

 &nbsp; &nbsp; &nbsp;echo &nbsp; 

 &nbsp; &nbsp;else 

 &nbsp; &nbsp; &nbsp;failure &quot;No mysqld pid file found. Looked for %s.&quot; &quot;$pid_file&quot; 

 &nbsp; &nbsp; &nbsp;echo 

 &nbsp; &nbsp;fi 

 &nbsp; &nbsp;;; 

 &nbsp; &nbsp; 

 &nbsp; 'status') 

 &nbsp; &nbsp; status mysqld 

 &nbsp; &nbsp; ;; 

 &nbsp; &nbsp; 

 &nbsp; 'reload') 

 &nbsp; &nbsp; $0 stop 

 &nbsp; &nbsp; $0 start 

 &nbsp; &nbsp; ;; 

 &nbsp; 

 &nbsp;'restart') 

 &nbsp; &nbsp;# Stop the service and regardless of whether it was 

 &nbsp; &nbsp;# running or not, start it again. 

 &nbsp; &nbsp;$0 stop 

 &nbsp; &nbsp;$0 start 

 &nbsp; &nbsp;;; 

 

 &nbsp;*) 

 &nbsp; &nbsp;# usage 

 &nbsp; &nbsp;gprintf &quot;usage: %s {start|stop|status|reload|restart}\n&quot; &quot;$0&quot; 

 &nbsp; &nbsp;exit 1 

 &nbsp; &nbsp;;; 

esac
И запускать его следует из-под суперпользователя, причём, предварительно прочитав manual про конфигурационные файлы.:smoke: