Internet Express for Tru64 UNIX Version 6.8 Administration Guide (14233)

17.7.1 Directories and Files Established by MySQL Installation
The MySQL installation procedure includes compiling, initializing, starting the server, and
creating a database. MySQL is installed in /usr/internet/mysql/. A /usr/local/mysql
symbolic link is created to duplicate the MySQL default installation path.
The MySQL installation creates an account called mysql and the daemon is started by the mysql
user.
By default, the installation step installs files under /usr/local/mysql, in the following
subdirectories:
Table 17-2 MySQL Directories
ContentsDirectory
Client programs and scriptsbin
Include (header) filesinclude/mysql
Documentation in Info formatinfo
Librarieslib/mysql
The “mysqld” serverlibexec
Error message filesshare/mysql
Benchmarks and “crash-me” testsql-bench
Databases and log filesvar
The installation procedure also runs the mysql_install_db script to set up the initial MySQL
grant tables containing the privileges that determine how users are allowed to connect to the
server The mysql_install_db script creates the server's data directory. Under the data directory,
it creates directories for the MySQL database that holds all database privileges and the test
database that you can use to test MySQL. The script also creates privilege table entries for root
and anonymous user accounts.
17.7.2 Starting and Stopping MySQL
You can start or stop MySQL as follows:
1. From the Manage Components menu, choose MySQL Database Management System. The
Manage MYSQL menu is displayed.
2. From the Manage MYSQL menu, choose Start/Stop MYSQL. The current state of the MYSQL
server is displayed:
• To start a stopped server, click on the Start button.
• If the server is running, click on Stop to stop the server or Restart to stop and restart
the server.
A status message is displayed after each action.
17.7.3 Starting and Stopping the MySQL Server Using a Command Line
Internet Express provides a startup script for MySQL in /sbin/init.d/mysql.
Use the following command to start MySQL on the command line:
# /sbin/init.d/mysql start
Use the following command to stop MySQL on the command line:
# /sbin/init.d/mysql stop
262 PostgreSQL Database and MySQL Administration