Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

EcommerceSearch
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Specials
Site Map
Support Solutions to help you do business with your Virtual Server.



Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


MySQL

    MySQL Overview
    Installation
    Documentation and Support
MySQL Overview
MySQLMySQL is a relational database management system (rdbms) that provides users with a powerful multi-user, multi-threaded SQL (Structured Query Language) database solution. It is fast, robust, and easy to use. MySQL is provided free of charge on all our Virtual Servers.


Installation

Version 3.23.37 is available for use on all FreeBSD and Solaris Virtual Servers.

Connect to your Virtual Server using Telnet or SSH and run the MySQL installation script by typing:

    % vinstall mysql

This program will install all the necessary files for you to run MySQL in ~/usr/local/mysql.

This command 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.

Restarting MySQL

If you need to restart the MySQL daemon from the command prompt, you may do so using the following command:
    % /usr/local/bin/daemon -f /usr/local/bin/virtual/ /usr/local/mysql/bin/safe_mysqld --pid-file=/usr/local/mysql/var/username.pid 
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 Section 6.8 -- Adding new user privileges in the MySQL users manual.


Documentation and Support


Manpages are also available on each Virtual Server host server 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

Please note: While Blue Reef offers this solution, we do not provide technical support for MySQL beyond the installation procedure which is presented above. Consult the manual or numerous other resources located at the MySQL web site for further assistance.


SEE ALSO:

MS Access & MySQL

PHP Development

Miva/HTMLScript

mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons

BOOKS TO HELP YOU:

MySQL (OTHER NEW RIDERS)
MySQL
(OTHER NEW RIDERS)


Building Database Applications on the Web Using PHP3
Building Database Applications on the Web Using PHP3


The Data Webhouse Toolkit
The Data Webhouse Toolkit


PHP3 and MySQL Web Development

Amazon.com logo
Search for :
Enter keywords...