|
Installing MySQL
To install MySQL, connect to your Virtual Server via
Telnet or SSH and
run the MySQL installation script that matches your Virtual Server O/S:
|
FreeBSD MySQL 3.22.32
% vinstall mysql
|
BSD/OS MySQL 3.22.25
% installmysql-3.22.25
|
|
NOTE: If your Virtual Server was ordered after Nov 22, 1999, you are likely
running FreeBSD. To find out which O/S your Virtual Server is running, use the
uname command:
% uname
If your Virtual Server is not already running FreeBSD,
Upgrade to a New FreeBSD Virtual Server
today!
|
These commands automatically install all the necessary files for you to
run MySQL.
They will also start the mysql daemon running on your
Virtual Server and setup the Virtual Server to restart the mysql daemon
whenever your Virtual Server's host server reboots.
While the the mysql daemon is running the mysql.sock file will
be stored in your ~/tmp directory.
The MySQL home directory is ~/usr/local/mysql.
|
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.
|
Starting MySQL
To use the MySQL client type:
% mysql -u root
This command will start the MySQL client as the root user. You can add
more users by following the directions in section
4.3 MySQL User Account Management of the MySQL Reference Manual.
Should you ever need to restart mysql from the command prompt, you may
do so using the following command:
% /usr/local/bin/mysqld &
Documentation
Manpages are available
on each Virtual Server host server and can be accessed by typing the
following during a telnet session with your Virtual Server:
% man mysql
|
