Home   |   Products   |   Order   |   Support   |   ? !1 UK Web Hosting
 

Installing MySQL
To install MySQL, connect to your Virtual Server via Telnet or SSH and do the following according to your Virtual Server O/S:

These installation programs install all the necessary files for you to run MySQL. The MySQL home directory is ~/usr/local/mysql.

The installation programs also start the MySQL daemon running on your Virtual Server and configure the Virtual Server to automatically restart the MySQL daemon if your Virtual Server host server happens to reboot. Should you ever need to restart the MySQL daemon from the command prompt, you may do so using the following command, depending on your Virtual Server O/S:

  • FreeBSD & Solaris
    % daemon -f virtual /usr/local/mysql/bin/safe_mysqld \
    --pid-file=/usr/local/mysql/var/usrname.pid

  • BSD/OS Upgrade!
    % /usr/local/bin/mysqld &

While the the MySQL daemon is running, the mysql.sock file will be stored in your ~/tmp directory.

NOTE: After you install MySQL it is not necessary to run the mysql_install_db as described in Section 6.7 of the MySQL manual.

The mysql Client
To use the mysql client type:

% virtual /usr/local/mysql/bin/mysql -u root

This command will start the MySQL client as the root user. You can add more users by following the directions in the MySQL Reference Manual:

Documentation
Manpages are available and can be accessed by typing the following during a telnet or SSH session with your Virtual Server:

% man -M $HOME/usr/local/mysql/man mysql


Site Map  |  Contact Us!
Copyright © 1998-2001 Bright Builders, Inc. All rights reserved.
Last Modified: Thu Jun 21 22:25:20 2001 GMT
Page Built: Mon Jul 2 19:57:20 2001 GMT

   
A L S O  S E E
· MySQL ODBC Drivers
· Virtual Server Help