MySQL
  Home arrow MySQL arrow Page 2 - MySQL Configuration and Installation
Dev Shed Forums  
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Smartphone Development  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Mobile Linux  
App Generation ROI  
IBM® developerWorks  
Forums Sitemap  
E-Commerce Hosting  
Linux Web Hosting  
Managed Hosting  
Small Business Hosting  
VPS Hosting  
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid  
Request Media Kit
Contact Us  
Site Map  
Privacy Policy  
Support  
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MYSQL

MySQL Configuration and Installation
By: McGraw-Hill/Osborne
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: starstarstarstarstar / 87
    2005-06-02


    Table of Contents:
  • MySQL Configuration and Installation
  • Installing and Configuring MySQL on UNIX
  • Installing MySQL on UNIX from a Binary Tarball Distribution
  • Installing MySQL on UNIX from a Source Distribution
  • Installing and Configuring MySQL on Windows
  • Installing MySQL on Windows from a Source Distribution
  • Testing MySQL

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      error-file:tidyout.log Del.ici.ous error-file:tidyout.log Digg
      error-file:tidyout.log Blink error-file:tidyout.log Simpy
      error-file:tidyout.log Google error-file:tidyout.log Spurl
      error-file:tidyout.log Y! MyWeb error-file:tidyout.log Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article

     
     
    ADVERTISEMENT


    MySQL Configuration and Installation - Installing and Configuring MySQL on UNIX
    ( Page 2 of 7 )

    MySQL is available in binary form for almost all versions of UNIX and can even be compiled for those UNIX variants for which no binary distribution exists. This section will discuss installing and configuring MySQL on Linux using both source and binary distributions; the process for other UNIX variants is similar, although you should refer to the documentation included with the MySQL distribution for platform-specific notes.

    Installing MySQL from a Binary RPM Distribution

    The recommended way to install MySQL on a Linux system is via RPM. MySQL AB makes the following RPMs available for download on its web site:

    • MySQL The MySQL database server, which manages databases and tables, controls user access, and processes SQL queries

    • MySQL-client MySQL client programs, which makes it possible to connect to, and interact with, the server

      Needful Things
      MySQL software distributions are usually packaged in Zip, tar (tape archive), or RPM (RPM Package Manager) format, and they can range from 7 to 20 MB in size
      in compressed form, and up to 100 MB in size in uncompressed form. Depending on the format you select, you will need appropriate unpackaging tools to extract the files from the source archive. For Zip and tar files, you will need GNU tar and GNU gunzip, available from http://www.gnu.org.
      For RPM files, you will need rpm, available from http://www.rpm.org.
      Additionally, if youre planning on compiling and installing MySQL from a source distribution, you will need a C++ compiler like gcc on UNIX or Visual C++ on
      Windows. The gcc compiler is available from http://www.gnu.org/software/
      gcc, while Visual C++ is available from http://msdn.microsoft.com/visualc.
    • MySQL-devel Libraries and header files that come in handy when compiling other programs that use MySQL

    • MySQL-shared Shared libraries for the MySQL client

    • MySQL-bench Benchmark and performance testing tools for the MySQL database server

    The MySQL RPMs listed here are all built on a SuSE Linux system, but they’ll usually work on other Linux variants with no difficulty.

    Installing an RPM distribution of MySQL is extremely simple, and it involves running only a single command—the rpm command—for each RPM you wish to install. Here’s how you go about doing it:

    1. First ensure that you’re logged in as root:

       [user@host] # su – root

    2. Switch to the directory containing the RPMs: 

        [root@host] # cd /tmp

    3. Install the MySQL database server by executing the following 
        command (remember to replace the filename in italics with 
        the  file name of your RPM):

       [root@host] # rpm -i MySQL-4.0.9-0.i386.rpm


    RPM does the following things to get MySQL up and running on your system:

    • Copies the MySQL binaries to appropriate locations on your system (usually, binaries go to /usr/bin and /usr/sbin, while databases and tables are stored in /var/lib/mysql)

    • Adds a mysql user/group to the system to handle all MySQL-related operational and administrative tasks

    • Alters ownership of the MySQL binaries so that they are owned by the mysql user/group

    • Creates and initializes the MySQL grant tables

    • Adds appropriate entries to your system’s startup scripts so that the MySQL server starts up automatically at boot time

    • Starts the server so that you can begin using it immediately Figure 3-1 shows a snippet of what you might see during the installation process:

    4. Now install the remaining RPMs in a similar manner:

      [root@host]# rpm -i MySQL-client-4.0.9-0.i386.rpm 
      [root@host]# rpm -i MySQL-devel-4.0.9-0.i386.rpm

      [root@host]# rpm -i MySQL-shared-4.0.9-0.i386.rpm  
      [root@host]# rpm -i MySQL-bench-4.0.9-0.i386.rpm

    Figure 3-2 displays what you should see while performing this task. 

     
    Figure 3-1.  Installation of the MySQL server via RPM

    Note that it’s necessary to install only the server; however, I would recommend that you install the client as well so that you can interact with the server from the system console. The benchmark utilities should be installed only if you plan to test MySQL performance, while the libraries and header files come in handy when you’re compiling other utilities or tools that use MySQL (for example, the PHP scripting language).

    Once installation has been successfully completed, you should move later in the chapter to the section titled “Testing MySQL” to verify that everything is working as it should.


    Figure 3-2.  Installation of ancillary MySQL tools and utilities via RPM



     
     
    >>> More MySQL Articles          >>> More By McGraw-Hill/Osborne
     

       

    MYSQL ARTICLES

    - MySQL Security Tips
    - Designing a MySQL Database: Tips and Techniq...
    - The Three Most Important MySQL Queries
    - Null and Empty Strings
    - MySQL Server Tuning Tips and Tricks
    - MySQL Query Optimizations and Schema Design
    - MySQL Benchmarking Tools and Utilities
    - MySQL Benchmarking Concepts and Strategies
    - Take Some Load off MySQL with MemCached
    - MySQL Table Prefix Changer Tool in PHP
    - Using the SIGNAL Statement for Error Handling
    - Error Handling Examples
    - Error Handling
    - Completing a Search Engine with MySQL and PH...
    - Paginating Result Sets for a Search Engine B...





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 6 Hosted by Hostway
    Stay green...Green IT