GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Installing MySQL

bullet Introduction
To install MySQL, connect to your Virtual Private Servers via Telnet or SSH and do the following according to your Virtual Private Servers O/S:
  • FreeBSD & Solaris
    Run the MySQL installation program:

    % vinstall mysql

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 Private Servers and configure the Virtual Private Servers to automatically restart the MySQL daemon if your Virtual Private Servers 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 Private Servers O/S:

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

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.

 

bullet 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:

The MySQL client is designed to be able to report errors in numerous languages. While this does not affect the way you use MySQL, having the error messages in your native language could make understanding the errors easier. For more information, see the following:

To make starting MySQL easier, you can create a file with all your start-up options instead of having to type in all the different flags at the command prompt. To do this, create a file in your ~/etc/ directory called my.cnf. The contents of the file would look like this if you wanted MySQL to report error messages in Japanese:

[mysqld]
language = japanese
default-character-set = ujis
    

 

bullet Documentation
Manpages are available and can be accessed by typing the following during a telnet or SSH session with your Virtual Private Servers:
% man -M $HOME/usr/local/mysql/man mysql


Toll Free 1-866-GSP-4400 • 1-301-464-9363 • service@gsp.com
Copyright © 1994-2016 GSP Services, Inc.