224

Appendix B     Getting Started with MySQL

For New Users of MySQL

The MySQL server daemon, mysqld, can be started using the startup script. It listens

to incoming connection requests from clients. The package comes with mysql client

program that you can use to connect to the database and carry out some system admin 

istration tasks as well as add/update/delete records in the database. You can have multi 

ple databases and at the time of connection you can define to which database you want

to connect.

Starting and Stopping MySQL Server

You can start and stop MySQL Server using startup script /etc/init.d/

mysqld on Linux machines. This script is shown below:

#!/bin/bash

#

# mysqld This shell script takes care of starting 

# and stopping

#

the MySQL subsystem (mysqld).

#

# chkconfig:   78 12

# description: MySQL database server.

# processname: mysqld

# config: /etc/my.cnf

# pidfile: /var/run/mysqld/mysqld.pid

# Source function library.

. /etc/rc.d/init.d/functions

# Source networking configuration.

. /etc/sysconfig/network

# Source subsystem configuration.

[  f /etc/sysconfig/subsys/mysqld ] && . /etc/sysconfig/subsys/mysqld

prog="MySQL"

start(){

touch /var/log/mysqld.log

chown mysql.mysql /var/log/mysqld.log 

chmod 0640 /var/log/mysqld.log

if [ !  d /var/lib/mysql/mysql ] ; then

    action $"Initializing MySQL database: " /usr/bin/

mysql_install_db

    ret=$?