3 # mysql A very fast and reliable SQL database engine
5 # chkconfig: 2345 84 25
7 # description: A very fast and reliable SQL database engine.
9 # pidfile: /var/lib/mysql/mysqld.pid
11 # Source function library
12 . /etc/rc.d/init.d/functions
15 . /etc/sysconfig/network
17 # Check that networking is up.
18 if is_no "${NETWORKING}"; then
19 msg_network_down MySQL
23 MYSQLD_ERRLOG=/var/log/mysql/err
24 MYSQLD_CONFIG=/etc/mysqld.conf
27 if [ -f /etc/sysconfig/mysql ] ; then
28 . /etc/sysconfig/mysql
31 # Daemon don't dies if config doesn't exists
32 if [ ! -f $MYSQLD_CONFIG ]; then
33 echo "MySQL config $MYSQLD_CONFIG not exists"
37 if [ ! -f $MYSQLD_CONFIG ]; then
38 echo "MySQL config $MYSQLD_CONFIG not exists"
43 /^[ \t]*\[.*\][ \t]*$/ {
45 section=substr($0,RSTART+1,RSTART+RLENGTH-3)
47 section=="mysqld" && $2~"=" {
49 printf("MYSQL_DATA_DIR=%s;", $3)
50 } else if ($1=="user") {
51 printf("MYSQL_USER=%s;", $3)
52 } else if ($1=="pid-file") {
53 printf("MYSQL_PIDFILE=%s;", $3)
57 print "export MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE"
61 if [ -z $MYSQL_DATA_DIR ]; then
62 echo "MySQL datadir $MYSQL_DATA_DIR not configured propely!"
63 echo "Edit $MYSQLD_CONFIG and configure it."
67 if [ -z $MYSQL_USER ]; then
68 echo "MySQL user not configured propely!"
69 echo "Edit $MYSQLD_CONFIG and configure it."
76 if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
77 echo "MySQL database not initialized. Try \"$0 init\" before start."
81 # Check if the service is already running?
82 if [ -f /var/lock/subsys/mysql ]; then
83 msg_already_running MySQL
88 if [ ! -f $MYSQLD_ERRLOG ]; then
91 chown mysql.mysql $MYSQLD_ERRLOG
92 chmod 640 $MYSQLD_ERRLOG
94 [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
95 TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} /usr/sbin/mysqld --defaults-file=$MYSQLD_CONFIG >>$MYSQLD_ERRLOG 2>&1 &
98 if ps -C mysqld >/dev/null 2>&1; then
105 [ $RETVAL -eq 0 ] && touch /var/lock/subsys/mysql
109 if [ -f /var/lock/subsys/mysql ]; then
113 rm -f /var/lock/subsys/mysql $MYSQLD_PIDFILE >/dev/null 2>&1
115 msg_not_running MySQL
128 # Check if not exist init database
129 if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
130 echo "Seems that database is initialized now. Remove by hand $MYSQL_DATA_DIR/mysql"
131 echo "before initialize database."
135 show "Creating privilege mysql tables"
139 # Install this too in the user table
140 hostname="`hostname --fqdn | tr -d '[:space:]'`"
142 # Check if hostname is valid
143 if [ -z "$hostname" ]; then
146 echo "Sorry, the host name is not configured."
147 echo "Please configure the 'hostname' command to return a hostname."
149 elif ! hostname -i >/dev/null 2>&1; then
152 echo "Sorry, the host '$hostname' could not be looked up."
153 echo "Please configure the 'hostname' command to return a correct hostname."
157 # Initialize variables
164 # Check for old tables
165 if test ! -f $mdata/db.frm
167 # mysqld --bootstrap wants one command/line
168 c_d="$c_d CREATE TABLE db ("
169 c_d="$c_d Host char(60) DEFAULT '' NOT NULL,"
170 c_d="$c_d Db char(64) DEFAULT '' NOT NULL,"
171 c_d="$c_d User char(16) DEFAULT '' NOT NULL,"
172 c_d="$c_d Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
173 c_d="$c_d Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
174 c_d="$c_d Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
175 c_d="$c_d Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
176 c_d="$c_d Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
177 c_d="$c_d Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
178 c_d="$c_d Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
179 c_d="$c_d References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
180 c_d="$c_d Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
181 c_d="$c_d Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
182 c_d="$c_d PRIMARY KEY Host (Host,Db,User),"
183 c_d="$c_d KEY User (User)"
185 c_d="$c_d comment='Database privileges';"
187 i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
188 INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');"
191 if test ! -f $mdata/host.frm
193 c_h="$c_h CREATE TABLE host ("
194 c_h="$c_h Host char(60) DEFAULT '' NOT NULL,"
195 c_h="$c_h Db char(64) DEFAULT '' NOT NULL,"
196 c_h="$c_h Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
197 c_h="$c_h Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
198 c_h="$c_h Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
199 c_h="$c_h Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
200 c_h="$c_h Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
201 c_h="$c_h Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
202 c_h="$c_h Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
203 c_h="$c_h References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
204 c_h="$c_h Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
205 c_h="$c_h Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
206 c_h="$c_h PRIMARY KEY Host (Host,Db)"
208 c_h="$c_h comment='Host privileges; Merged with database privileges';"
211 if test ! -f $mdata/user.frm
213 c_u="$c_u CREATE TABLE user ("
214 c_u="$c_u Host char(60) DEFAULT '' NOT NULL,"
215 c_u="$c_u User char(16) DEFAULT '' NOT NULL,"
216 c_u="$c_u Password char(16) DEFAULT '' NOT NULL,"
217 c_u="$c_u Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
218 c_u="$c_u Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
219 c_u="$c_u Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
220 c_u="$c_u Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
221 c_u="$c_u Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
222 c_u="$c_u Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
223 c_u="$c_u Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
224 c_u="$c_u Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
225 c_u="$c_u Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
226 c_u="$c_u File_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
227 c_u="$c_u Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
228 c_u="$c_u References_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
229 c_u="$c_u Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
230 c_u="$c_u Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,"
231 c_u="$c_u PRIMARY KEY Host (Host,User)"
233 c_u="$c_u comment='Users and global privileges';"
235 i_u="INSERT INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
236 INSERT INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
238 REPLACE INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
239 REPLACE INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
241 INSERT INTO user VALUES ('localhost','mysql_logrotate','','N','N','N','N','N','N','Y','N','N','N','N','N','N','N');"
244 if test ! -f $mdata/func.frm
246 c_f="$c_f CREATE TABLE func ("
247 c_f="$c_f name char(64) DEFAULT '' NOT NULL,"
248 c_f="$c_f ret tinyint(1) DEFAULT '0' NOT NULL,"
249 c_f="$c_f dl char(128) DEFAULT '' NOT NULL,"
250 c_f="$c_f type enum ('function','aggregate') NOT NULL,"
251 c_f="$c_f PRIMARY KEY (name)"
253 c_f="$c_f comment='User defined functions';"
256 if test ! -f $mdata/tables_priv.frm
258 c_t="$c_t CREATE TABLE tables_priv ("
259 c_t="$c_t Host char(60) DEFAULT '' NOT NULL,"
260 c_t="$c_t Db char(64) DEFAULT '' NOT NULL,"
261 c_t="$c_t User char(16) DEFAULT '' NOT NULL,"
262 c_t="$c_t Table_name char(60) DEFAULT '' NOT NULL,"
263 c_t="$c_t Grantor char(77) DEFAULT '' NOT NULL,"
264 c_t="$c_t Timestamp timestamp(14),"
265 c_t="$c_t Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,"
266 c_t="$c_t Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
267 c_t="$c_t PRIMARY KEY (Host,Db,User,Table_name),"
268 c_t="$c_t KEY Grantor (Grantor)"
270 c_t="$c_t comment='Table privileges';"
273 if test ! -f $mdata/columns_priv.frm
275 c_c="$c_c CREATE TABLE columns_priv ("
276 c_c="$c_c Host char(60) DEFAULT '' NOT NULL,"
277 c_c="$c_c Db char(60) DEFAULT '' NOT NULL,"
278 c_c="$c_c User char(16) DEFAULT '' NOT NULL,"
279 c_c="$c_c Table_name char(60) DEFAULT '' NOT NULL,"
280 c_c="$c_c Column_name char(60) DEFAULT '' NOT NULL,"
281 c_c="$c_c Timestamp timestamp(14),"
282 c_c="$c_c Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,"
283 c_c="$c_c PRIMARY KEY (Host,Db,User,Table_name,Column_name)"
285 c_c="$c_c comment='Column privileges';"
288 if /usr/sbin/mysqld --bootstrap --skip-grant-tables \
289 --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER << END_OF_DATA
290 CREATE DATABASE mysql;
312 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
315 /usr/bin/mysqladmin -u mysql password 'password'
316 /usr/bin/mysqladmin -h $hostname -u mysql password 'password'
317 /usr/bin/mysqladmin -u mysql_logrotate password 'password'
319 NOTE: mysql_logrotate password should be placed to /etc/mysqld.conf in
320 mysqladmin section. See the manual for more instructions.
327 Installation of grant tables FAILED!
329 Examine the logs in $MYSQL_DATA_DIR for more information. You can
330 also try to start the mysqld demon with:
332 /usr/sbin/mysqld --skip-grant &
334 You can use the command line tool /usr/bin/mysql to connect to the mysql
335 database and look at the grant tables:
337 shell> /usr/bin/mysql -u mysql mysql
340 Try 'mysqld --help' if you have problems with paths. Setting on
341 logging in /etc/mysqld.conf gives you a log in /var/log/mysql/log that
342 may be helpful. The latest information about MySQL is available on the
343 web at <http://www.mysql.com>.
345 Please check PLD ftp site for newer versions of this package.
347 Please consult the MySQL manual section: 'Problems running
348 mysql_install_db', and the manual section that describes problems on
349 your OS. Another information source is the MySQL email archive.
350 Please check all of the above before mailing us! And if you do mail
351 us, you MUST use the /usr/bin/mysqlbug script!
359 msg_usage "$0 {start|stop|status|restart|reload|init}"