226

Appendix B     Getting Started with MySQL

  start)

    start

    ;;

  stop)

    stop

    ;;

  status)

    status mysqld

    ;;

  reload)

    reload

    ;;

  restart)

    restart

    ;;

  condrestart)

    condrestart

    ;;

  *)

    echo $"Usage: $0 {start|stop|status|reload|condrestart|restart}"

    exit 1

esac

exit $?

To start the server, use the following commands:

/etc/init.d/mysqld start

When you start MySQL for the first time, you will see the following messages on

your screen:

[root@conformix /root]# /etc/init.d/mysqld start

Initializing MySQL database:                      [  OK  ]

Starting MySQL:                                   [  OK  ]

[root@conformix /root]#

The next time you start MySQL, it will not show the first line of output because it

only needs to initialize its own database the first time you start it.

To stop the database, use the following command:

[root@conformix /root]# /etc/init.d/mysqld stop 

Stopping MySQL:                                   [  OK  ]

[root@conformix /root]#

If the script is not available on your platform, you can create a similar script your 

self for your particular UNIX platform.