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:

  • FreeBSD & Solaris [ MySQL 3.23.38 ]
    Run the MySQL installation program: 

    % vinstall mysql

  • BSD/OS Upgrade! [ MySQL 3.22.25 ]
    Run the MySQL installation program: 

    % installmysql-3.22.25

  • Huh?
    If you don't know the Virtual Server O/S, try the following:

 

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