[packages/percona-server.git] / mysql.init

#!/bin/sh
#
# mysql		A very fast and reliable SQL database engine
#
# chkconfig:	2345 84 25
#
# description:	A very fast and reliable SQL database engine.
#
# pidfile:	/var/lib/mysql/mysqld.pid

# Source function library
. /etc/rc.d/init.d/functions

# Get network config
. /etc/sysconfig/network

# Check that networking is up
if is_no "${NETWORKING}"; then
	msg_network_down MySQL
	exit 1
fi

MYSQLD_ERRLOG=/var/log/mysql/err
MYSQLD_CONFIG=/etc/mysqld.conf 

# Get service config
if [ -f /etc/sysconfig/mysql ] ; then
	. /etc/sysconfig/mysql
fi

# Daemon doesn't die if config doesn't exist
if [ ! -f $MYSQLD_CONFIG ]; then 
	nls "MySQL config $MYSQLD_CONFIG does not exist"
	exit 1
fi

eval `awk '
/^[ \t]*\[.*\][ \t]*$/ {
	match($0,/\[.*\]/)
	section=substr($0,RSTART+1,RSTART+RLENGTH-3)
}
section=="mysqld" && $2~"=" {
	if ($1=="datadir") {
		printf("MYSQL_DATA_DIR=%s;", $3)
	} else if ($1=="user") {
		printf("MYSQL_USER=%s;", $3)
	} else if ($1=="pid-file") {
		printf("MYSQL_PIDFILE=%s;", $3)
	}
}
END {
	print "export MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE"
}
' /etc/mysqld.conf`

if [ -z $MYSQL_DATA_DIR ]; then 
	nls "MySQL datadir $MYSQL_DATA_DIR not configured properly!"
	nls "Edit $MYSQLD_CONFIG and configure it."
	exit 1
fi

if [ -z $MYSQL_USER ]; then 
	nls "MySQL user not configured properly!"
	nls "Edit $MYSQLD_CONFIG and configure it."
	exit 1
fi


case "$1" in
  start)
	if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
		nls "MySQL database not initialized. Try \"$0 init\" before start."
		exit 1
	fi

	# Check if the service is already running?		
	if [ -f /var/lock/subsys/mysql ]; then
		msg_already_running MySQL
	else 	
		msg_starting MySQL
		busy
		
		if [ ! -f $MYSQLD_ERRLOG ]; then 
			touch $MYSQLD_ERRLOG
		fi
		chown mysql.mysql $MYSQLD_ERRLOG
		chmod 640 $MYSQLD_ERRLOG

		[ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
		TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} /usr/sbin/mysqld --defaults-file=$MYSQLD_CONFIG >>$MYSQLD_ERRLOG 2>&1 &
		sleep 1
		deltext
		if ps -C mysqld >/dev/null 2>&1; then
			RETVAL=0
			ok
		else
			RETVAL=1
			fail
		fi
		[ $RETVAL -eq 0 ] && touch /var/lock/subsys/mysql
	fi
	;;
  stop)
	if [ -f /var/lock/subsys/mysql ]; then
		msg_stopping MySQL
		killproc mysqld
		sleep 1
		rm -f /var/lock/subsys/mysql $MYSQLD_PIDFILE >/dev/null 2>&1
	else
		msg_not_running MySQL
		exit 1
	fi
	;;
  status)
	status mysqld
	exit $?
	;;
  restart|reload)
	$0 stop
	$0 start
	;;
  init)
	# Check if not exist init database
	if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
		nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
		nls "before initializing database."
		exit 1;
	fi

	show "Creating privilege mysql tables"
	busy
	TMP=/tmp TMPDIR=/tmp 
	
	# Install this in the user table, too
	hostname="`hostname --fqdn | tr -d '[:space:]'`"
		
	# Check if hostname is valid
	if [ -z "$hostname" ]; then
		deltext
		fail
		nls "Sorry, the host name is not configured."
		nls "Please configure the 'hostname' command to return a hostname."
		exit 1
	elif ! hostname -i >/dev/null 2>&1; then 
		deltext
		fail
		nls "Sorry, the host '%s' could not be looked up." "$hostname"
		nls "Please configure the 'hostname' command to return a correct hostname."
		exit 1
	fi

	# Initialize variables
	c_d="" i_d=""
	c_h="" i_h=""
	c_u="" i_u=""
	c_f="" i_f=""
	c_t="" c_c=""
	
	# Check for old tables
	if test ! -f $mdata/db.frm
	then
	  # mysqld --bootstrap wants one command/line
	  c_d="$c_d CREATE TABLE db ("
	  c_d="$c_d   Host char(60) DEFAULT '' NOT NULL,"
	  c_d="$c_d   Db char(64) DEFAULT '' NOT NULL,"
	  c_d="$c_d   User char(16) DEFAULT '' NOT NULL,"
	  c_d="$c_d   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
	  c_d="$c_d KEY User (User)"
	  c_d="$c_d )"
	  c_d="$c_d comment='Database privileges';"
	  
	  i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
	  INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');"
	fi
	
	if test ! -f $mdata/host.frm
	then
	  c_h="$c_h CREATE TABLE host ("
	  c_h="$c_h  Host char(60) DEFAULT '' NOT NULL,"
	  c_h="$c_h  Db char(64) DEFAULT '' NOT NULL,"
	  c_h="$c_h  Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_h="$c_h  PRIMARY KEY Host (Host,Db)"
	  c_h="$c_h )"
	  c_h="$c_h comment='Host privileges;  Merged with database privileges';"
	fi
	
	if test ! -f $mdata/user.frm
	then
	  c_u="$c_u CREATE TABLE user ("
	  c_u="$c_u   Host char(60) DEFAULT '' NOT NULL,"
	  c_u="$c_u   User char(16) DEFAULT '' NOT NULL,"
	  c_u="$c_u   Password char(16) DEFAULT '' NOT NULL,"
	  c_u="$c_u   Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   File_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	  c_u="$c_u   PRIMARY KEY Host (Host,User)"
	  c_u="$c_u )"
	  c_u="$c_u comment='Users and global privileges';"
	
	  i_u="INSERT INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
	  INSERT INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
	  
	  REPLACE INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
	  REPLACE INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
	  
	  INSERT INTO user VALUES ('localhost','mysql_logrotate','','N','N','N','N','N','N','Y','N','N','N','N','N','N','N');"
	fi
	
	if test ! -f $mdata/func.frm
	then
	  c_f="$c_f CREATE TABLE func ("
	  c_f="$c_f   name char(64) DEFAULT '' NOT NULL,"
	  c_f="$c_f   ret tinyint(1) DEFAULT '0' NOT NULL,"
	  c_f="$c_f   dl char(128) DEFAULT '' NOT NULL,"
	  c_f="$c_f   type enum ('function','aggregate') NOT NULL,"
	  c_f="$c_f   PRIMARY KEY (name)"
	  c_f="$c_f )"
	  c_f="$c_f   comment='User defined functions';"
	fi
	
	if test ! -f $mdata/tables_priv.frm
	then
	  c_t="$c_t CREATE TABLE tables_priv ("
	  c_t="$c_t   Host char(60) DEFAULT '' NOT NULL,"
	  c_t="$c_t   Db char(64) DEFAULT '' NOT NULL,"
	  c_t="$c_t   User char(16) DEFAULT '' NOT NULL,"
	  c_t="$c_t   Table_name char(60) DEFAULT '' NOT NULL,"
	  c_t="$c_t   Grantor char(77) DEFAULT '' NOT NULL,"
	  c_t="$c_t   Timestamp timestamp(14),"
	  c_t="$c_t   Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,"
	  c_t="$c_t   Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
	  c_t="$c_t   PRIMARY KEY (Host,Db,User,Table_name),"
	  c_t="$c_t   KEY Grantor (Grantor)"
	  c_t="$c_t )"
	  c_t="$c_t   comment='Table privileges';"
	fi
	
	if test ! -f $mdata/columns_priv.frm
	then
	  c_c="$c_c CREATE TABLE columns_priv ("
	  c_c="$c_c   Host char(60) DEFAULT '' NOT NULL,"
	  c_c="$c_c   Db char(60) DEFAULT '' NOT NULL,"
	  c_c="$c_c   User char(16) DEFAULT '' NOT NULL,"
	  c_c="$c_c   Table_name char(60) DEFAULT '' NOT NULL,"
	  c_c="$c_c   Column_name char(60) DEFAULT '' NOT NULL,"
	  c_c="$c_c   Timestamp timestamp(14),"
	  c_c="$c_c   Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
	  c_c="$c_c   PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
	  c_c="$c_c )"
	  c_c="$c_c   comment='Column privileges';"
	fi

	if /usr/sbin/mysqld --bootstrap --skip-grant-tables \
	    --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER << END_OF_DATA
CREATE DATABASE mysql;
use mysql;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c
END_OF_DATA
	then 
	    deltext
	    ok
	    cat << END_OF_MSG

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
This is done with:

/usr/bin/mysqladmin -u mysql password 'password'
/usr/bin/mysqladmin -h $hostname -u mysql password 'password'
/usr/bin/mysqladmin -u mysql_logrotate password 'password'

NOTE: mysql_logrotate password should be placed to /etc/mysqld.conf in
mysqladmin section. See the manual for more instructions.

END_OF_MSG
      else  
	    deltext
	    fail
	    cat << END_OF_MSG
Installation of grant tables FAILED!

Examine the logs in $MYSQL_DATA_DIR for more information.  You can
also try to start the mysqld demon with:

/usr/sbin/mysqld --skip-grant &

You can use the command line tool /usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u mysql mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Setting on
logging in /etc/mysqld.conf gives you a log in /var/log/mysql/log that
may be helpful. The latest information about MySQL is available on the
web at http://www.mysql.com/.

Please check PLD ftp site for newer versions of this package.

Please consult the MySQL manual section: 'Problems running
mysql_install_db', and the manual section that describes problems on
your OS.  Another information source is the MySQL email archive.
Please check all of the above before mailing us!  And if you do mail
us, you MUST use the /usr/bin/mysqlbug script!  

END_OF_MSG

	exit 1 
	fi
	;;
  *)
	msg_usage "$0 {start|stop|restart|reload||status|init}"
	exit 1
	;;
esac

exit $RETVAL
Commit	Line	Data
53a28f77	1	#!/bin/sh
	2	#
	3	# mysql A very fast and reliable SQL database engine
	4	#
f9004b9d	5	# chkconfig: 2345 84 25
53a28f77	6	#
	7	# description: A very fast and reliable SQL database engine.
	8	#
c42b39b6	9	# pidfile: /var/lib/mysql/mysqld.pid
53a28f77	10
	11	# Source function library
	12	. /etc/rc.d/init.d/functions
	13
	14	# Get network config
	15	. /etc/sysconfig/network
	16
ac28c610	17	# Check that networking is up
e9ca44ab	18	if is_no "${NETWORKING}"; then
cf4aa290	19	msg_network_down MySQL
e9ca44ab	20	exit 1
	21	fi
	22
	23	MYSQLD_ERRLOG=/var/log/mysql/err
	24	MYSQLD_CONFIG=/etc/mysqld.conf
40c36bca	25
53a28f77	26	# Get service config
860cd80c	27	if [ -f /etc/sysconfig/mysql ] ; then
860cd80c	28	. /etc/sysconfig/mysql
860cd80c	29	fi
53a28f77	30
ac28c610	31	# Daemon doesn't die if config doesn't exist
e9ca44ab	32	if [ ! -f $MYSQLD_CONFIG ]; then
b92e5cd1	33	nls "MySQL config $MYSQLD_CONFIG does not exist"
78b16243	34	exit 1
53a28f77	35	fi
53a28f77	36
823c13f7 SZ	37	eval `awk '
	38	/^[ \t]\[.\][ \t]*$/ {
	39	match($0,/\[.*\]/)
	40	section=substr($0,RSTART+1,RSTART+RLENGTH-3)
	41	}
	42	section=="mysqld" && $2~"=" {
	43	if ($1=="datadir") {
	44	printf("MYSQL_DATA_DIR=%s;", $3)
	45	} else if ($1=="user") {
	46	printf("MYSQL_USER=%s;", $3)
	47	} else if ($1=="pid-file") {
	48	printf("MYSQL_PIDFILE=%s;", $3)
	49	}
	50	}
	51	END {
	52	print "export MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE"
	53	}
	54	' /etc/mysqld.conf`
e9ca44ab	55
e9ca44ab	56	if [ -z $MYSQL_DATA_DIR ]; then
b92e5cd1	57	nls "MySQL datadir $MYSQL_DATA_DIR not configured properly!"
b92e5cd1	58	nls "Edit $MYSQLD_CONFIG and configure it."
78b16243	59	exit 1
e9ca44ab	60	fi
	61
	62	if [ -z $MYSQL_USER ]; then
b92e5cd1	63	nls "MySQL user not configured properly!"
b92e5cd1	64	nls "Edit $MYSQLD_CONFIG and configure it."
78b16243	65	exit 1
e9ca44ab	66	fi
	67
	68
83fddc12	69	case "$1" in
b92e5cd1	70	start)
860cd80c	71	if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
b92e5cd1	72	nls "MySQL database not initialized. Try \"$0 init\" before start."
573e1dcc	73	exit 1
860cd80c	74	fi
e9ca44ab	75
	76	# Check if the service is already running?
	77	if [ -f /var/lock/subsys/mysql ]; then
cf4aa290	78	msg_already_running MySQL
e9ca44ab	79	else
e9ca44ab	80	msg_starting MySQL
5678822f	81	busy
e9ca44ab	82
e9ca44ab	83	if [ ! -f $MYSQLD_ERRLOG ]; then
b92e5cd1	84	touch $MYSQLD_ERRLOG
e9ca44ab	85	fi
	86	chown mysql.mysql $MYSQLD_ERRLOG
	87	chmod 640 $MYSQLD_ERRLOG
1024bc72 AM	88
1024bc72 AM	89	[ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
b7986924	90	TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} /usr/sbin/mysqld --defaults-file=$MYSQLD_CONFIG >>$MYSQLD_ERRLOG 2>&1 &
8a2b6620	91	sleep 1
40c36bca AF	92	deltext
40c36bca AF	93	if ps -C mysqld >/dev/null 2>&1; then
b92e5cd1	94	RETVAL=0
40c36bca	95	ok
8a2b6620	96	else
e9ca44ab	97	RETVAL=1
40c36bca	98	fail
8a2b6620	99	fi
ee9b6a50	100	[ $RETVAL -eq 0 ] && touch /var/lock/subsys/mysql
53a28f77	101	fi
53a28f77	102	;;
53a28f77	103	stop)
b92e5cd1	104	if [ -f /var/lock/subsys/mysql ]; then
	105	msg_stopping MySQL
	106	killproc mysqld
e9ca44ab	107	sleep 1
b92e5cd1	108	rm -f /var/lock/subsys/mysql $MYSQLD_PIDFILE >/dev/null 2>&1
	109	else
	110	msg_not_running MySQL
	111	exit 1
	112	fi
53a28f77	113	;;
53a28f77	114	status)
83fddc12	115	status mysqld
ee9b6a50	116	exit $?
53a28f77	117	;;
	118	restart\|reload)
	119	$0 stop
	120	$0 start
	121	;;
573e1dcc	122	init)
573e1dcc	123	# Check if not exist init database
e9ca44ab	124	if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
b92e5cd1	125	nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
	126	nls "before initializing database."
	127	exit 1;
e9ca44ab	128	fi
	129
	130	show "Creating privilege mysql tables"
	131	busy
	132	TMP=/tmp TMPDIR=/tmp
f19b03aa	133
ac28c610	134	# Install this in the user table, too
823c13f7	135	hostname="`hostname --fqdn \| tr -d '[:space:]'`"
40c36bca	136
e9ca44ab	137	# Check if hostname is valid
	138	if [ -z "$hostname" ]; then
	139	deltext
b92e5cd1	140	fail
	141	nls "Sorry, the host name is not configured."
	142	nls "Please configure the 'hostname' command to return a hostname."
	143	exit 1
	144	elif ! hostname -i >/dev/null 2>&1; then
	145	deltext
	146	fail
	147	nls "Sorry, the host '%s' could not be looked up." "$hostname"
	148	nls "Please configure the 'hostname' command to return a correct hostname."
e9ca44ab	149	exit 1
e9ca44ab	150	fi
e9ca44ab	151
823c13f7 SZ	152	# Initialize variables
	153	c_d="" i_d=""
	154	c_h="" i_h=""
	155	c_u="" i_u=""
	156	c_f="" i_f=""
	157	c_t="" c_c=""
	158
	159	# Check for old tables
	160	if test ! -f $mdata/db.frm
	161	then
	162	# mysqld --bootstrap wants one command/line
	163	c_d="$c_d CREATE TABLE db ("
	164	c_d="$c_d Host char(60) DEFAULT '' NOT NULL,"
	165	c_d="$c_d Db char(64) DEFAULT '' NOT NULL,"
	166	c_d="$c_d User char(16) DEFAULT '' NOT NULL,"
	167	c_d="$c_d Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	168	c_d="$c_d Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	169	c_d="$c_d Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	170	c_d="$c_d Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	171	c_d="$c_d Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	172	c_d="$c_d Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	173	c_d="$c_d Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	174	c_d="$c_d References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	175	c_d="$c_d Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	176	c_d="$c_d Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	177	c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
	178	c_d="$c_d KEY User (User)"
	179	c_d="$c_d )"
	180	c_d="$c_d comment='Database privileges';"
	181
	182	i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
	183	INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');"
	184	fi
	185
	186	if test ! -f $mdata/host.frm
	187	then
	188	c_h="$c_h CREATE TABLE host ("
	189	c_h="$c_h Host char(60) DEFAULT '' NOT NULL,"
	190	c_h="$c_h Db char(64) DEFAULT '' NOT NULL,"
	191	c_h="$c_h Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	192	c_h="$c_h Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	193	c_h="$c_h Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	194	c_h="$c_h Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	195	c_h="$c_h Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	196	c_h="$c_h Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	197	c_h="$c_h Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	198	c_h="$c_h References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	199	c_h="$c_h Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	200	c_h="$c_h Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	201	c_h="$c_h PRIMARY KEY Host (Host,Db)"
	202	c_h="$c_h )"
	203	c_h="$c_h comment='Host privileges; Merged with database privileges';"
	204	fi
	205
	206	if test ! -f $mdata/user.frm
	207	then
	208	c_u="$c_u CREATE TABLE user ("
	209	c_u="$c_u Host char(60) DEFAULT '' NOT NULL,"
	210	c_u="$c_u User char(16) DEFAULT '' NOT NULL,"
	211	c_u="$c_u Password char(16) DEFAULT '' NOT NULL,"
	212	c_u="$c_u Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	213	c_u="$c_u Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	214	c_u="$c_u Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
	215	c_u="$c_u Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
216	c_u="$c_u Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
217	c_u="$c_u Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
218	c_u="$c_u Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
219	c_u="$c_u Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
220	c_u="$c_u Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
221	c_u="$c_u File_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
222	c_u="$c_u Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
223	c_u="$c_u References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
224	c_u="$c_u Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
225	c_u="$c_u Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
226	c_u="$c_u PRIMARY KEY Host (Host,User)"
227	c_u="$c_u )"
228	c_u="$c_u comment='Users and global privileges';"
229
230	i_u="INSERT INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
231	INSERT INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
232
233	REPLACE INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
234	REPLACE INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
235
1b6aa76d	236	INSERT INTO user VALUES ('localhost','mysql_logrotate','','N','N','N','N','N','N','Y','N','N','N','N','N','N','N');"
823c13f7 SZ	237	fi
	238
	239	if test ! -f $mdata/func.frm
	240	then
	241	c_f="$c_f CREATE TABLE func ("
	242	c_f="$c_f name char(64) DEFAULT '' NOT NULL,"
	243	c_f="$c_f ret tinyint(1) DEFAULT '0' NOT NULL,"
	244	c_f="$c_f dl char(128) DEFAULT '' NOT NULL,"
	245	c_f="$c_f type enum ('function','aggregate') NOT NULL,"
	246	c_f="$c_f PRIMARY KEY (name)"
	247	c_f="$c_f )"
	248	c_f="$c_f comment='User defined functions';"
	249	fi
	250
	251	if test ! -f $mdata/tables_priv.frm
	252	then
	253	c_t="$c_t CREATE TABLE tables_priv ("
	254	c_t="$c_t Host char(60) DEFAULT '' NOT NULL,"
	255	c_t="$c_t Db char(64) DEFAULT '' NOT NULL,"
	256	c_t="$c_t User char(16) DEFAULT '' NOT NULL,"
	257	c_t="$c_t Table_name char(60) DEFAULT '' NOT NULL,"
	258	c_t="$c_t Grantor char(77) DEFAULT '' NOT NULL,"
	259	c_t="$c_t Timestamp timestamp(14),"
	260	c_t="$c_t Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,"
	261	c_t="$c_t Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
	262	c_t="$c_t PRIMARY KEY (Host,Db,User,Table_name),"
	263	c_t="$c_t KEY Grantor (Grantor)"
	264	c_t="$c_t )"
	265	c_t="$c_t comment='Table privileges';"
	266	fi
	267
	268	if test ! -f $mdata/columns_priv.frm
	269	then
	270	c_c="$c_c CREATE TABLE columns_priv ("
	271	c_c="$c_c Host char(60) DEFAULT '' NOT NULL,"
119ef1d0	272	c_c="$c_c Db char(60) DEFAULT '' NOT NULL,"
823c13f7	273	c_c="$c_c User char(16) DEFAULT '' NOT NULL,"
119ef1d0	274	c_c="$c_c Table_name char(60) DEFAULT '' NOT NULL,"
119ef1d0	275	c_c="$c_c Column_name char(60) DEFAULT '' NOT NULL,"
823c13f7 SZ	276	c_c="$c_c Timestamp timestamp(14),"
	277	c_c="$c_c Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
	278	c_c="$c_c PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
	279	c_c="$c_c )"
	280	c_c="$c_c comment='Column privileges';"
	281	fi
	282
e9ca44ab	283	if /usr/sbin/mysqld --bootstrap --skip-grant-tables \
823c13f7 SZ	284	--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER << END_OF_DATA
823c13f7 SZ	285	CREATE DATABASE mysql;
e9ca44ab	286	use mysql;
823c13f7 SZ	287	$c_d
	288	$i_d
	289
	290	$c_h
	291	$i_h
e9ca44ab	292
823c13f7 SZ	293	$c_u
	294	$i_u
	295
	296	$c_f
	297	$i_f
	298
	299	$c_t
	300	$c_c
	301	END_OF_DATA
e9ca44ab	302	then
	303	deltext
	304	ok
	305	cat << END_OF_MSG
6a46c354	306
6a46c354	307	PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
e9ca44ab	308	This is done with:
6a46c354	309
e9ca44ab	310	/usr/bin/mysqladmin -u mysql password 'password'
f19b03aa	311	/usr/bin/mysqladmin -h $hostname -u mysql password 'password'
e9ca44ab	312	/usr/bin/mysqladmin -u mysql_logrotate password 'password'
6a46c354	313
	314	NOTE: mysql_logrotate password should be placed to /etc/mysqld.conf in
	315	mysqladmin section. See the manual for more instructions.
e9ca44ab	316
	317	END_OF_MSG
	318	else
	319	deltext
	320	fail
	321	cat << END_OF_MSG
	322	Installation of grant tables FAILED!
	323
	324	Examine the logs in $MYSQL_DATA_DIR for more information. You can
	325	also try to start the mysqld demon with:
	326
	327	/usr/sbin/mysqld --skip-grant &
	328
	329	You can use the command line tool /usr/bin/mysql to connect to the mysql
	330	database and look at the grant tables:
	331
	332	shell> /usr/bin/mysql -u mysql mysql
	333	mysql> show tables
	334
	335	Try 'mysqld --help' if you have problems with paths. Setting on
	336	logging in /etc/mysqld.conf gives you a log in /var/log/mysql/log that
	337	may be helpful. The latest information about MySQL is available on the
78b16243	338	web at http://www.mysql.com/.
e9ca44ab	339
	340	Please check PLD ftp site for newer versions of this package.
	341
	342	Please consult the MySQL manual section: 'Problems running
	343	mysql_install_db', and the manual section that describes problems on
	344	your OS. Another information source is the MySQL email archive.
	345	Please check all of the above before mailing us! And if you do mail
	346	us, you MUST use the /usr/bin/mysqlbug script!
	347
	348	END_OF_MSG
	349
	350	exit 1
823c13f7	351	fi
573e1dcc	352	;;
53a28f77	353	*)
b92e5cd1	354	msg_usage "$0 {start\|stop\|restart\|reload\|\|status\|init}"
53a28f77	355	exit 1
83fddc12	356	;;
53a28f77	357	esac
40c36bca	358
ee9b6a50	359	exit $RETVAL