Installing MySQL
	What's New in IT IT Consulting Phones/VoIP Internet Security About Us Home

	Web Site Hosting	Web Design	Broadband/Access	E-Mail Solutions	Accept Credit Cards	Hosting Support

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

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

  % vinstall mysql

• If you don't know your Virtual Private Server O/S, please contact ITS Technical Support for assistance.
  

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 server and configure the Virtual Private Server to automatically restart the MySQL daemon if the host server happens to reboot. Should you ever need to restart the MySQL daemon from the command prompt, you can do so using the following command for FreeBSD and Solaris servers:

/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.

The mysql Client

To use the mysql client, connect to your server via SSH or Telnet and 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:

• MySQL Documentation: 4.3.5 Adding New Users to MySQL

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:

• MySQL Documentation: 4.6.2 Non-English Error Messages

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

Documentation

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

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

There is also a considerable volume of documentation on the MySQL web site:

• MySQL Online Documentation

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!

Copyright © 1996-2024, Integrated Technical Solutions, Inc., all rights reserved. See Terms/Legal for trademarks, copyright, and terms of use.