Dyntex.net Support Centre: MySQL Reference Manual p.81

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 81 shell> make install shell> scripts/mysql_install_db shell> chown -R root /usr/local/mysql shell> chown -R mysql /usr/local/mysql/var shell> chgrp -R mysql /usr/local/mysql shell> cp support-files/my-medium.cnf /etc/my.cnf shell> /usr/local/mysql/bin/safe_mysqld --user=mysql & or shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & if you are running MySQL 4.x. If you want to have support for InnoDB tables, you should edit the /etc/my.cnf le and remove the # character before the parameter that starts with innodb_.... See Section 4.1.2 [Option les], page 186, and Section 7.5.2 [InnoDB start], page 507. If you start from a source RPM, do the following: shell> rpm --rebuild MySQL-VERSION.src.rpm This will make a binary RPM that you can install. You can add new users using the bin/mysql_setpermission script if you install the DBI and Msql-Mysql-modules Perl modules. A more detailed description follows. To install a source distribution, follow these steps, then proceed to Section 2.4 [Post- installation], page 91, for post-installation initialisation and testing: 1. Pick the directory under which you want to unpack the distribution, and move into it. 2. Obtain a distribution le from one of the sites listed in Section 2.2.1 [Getting MySQL], page 69. 3. If you are interested in using Berkeley DB tables with MySQL, you will need to obtain a patched version of the Berkeley DB source code. Please read the chapter on Berkeley DB tables before proceeding. See Section 7.6 [BDB], page 533. MySQL source distributions are provided as compressed tar archives and have names like `mysql-VERSION.tar.gz', where VERSION is a number like 4.0.3-beta. 4. Add a user and group for mysqld to run as: shell> groupadd mysql shell> useradd -g mysql mysql These commands add the mysql group and the mysql user. The syntax for useradd and groupadd may dier slightly on dierent versions of Unix. They may also be called adduser and addgroup. You may wish to call the user and group something else instead of mysql. 5. Unpack the distribution into the current directory: shell> gunzip < /path/to/mysql-VERSION.tar.gz | tar xvf - This command creates a directory named `mysql-VERSION'. 6. Change into the top-level directory of the unpacked distribution: shell> cd mysql-VERSION Note that currently you must congure and build MySQL from this top-level directory. You cannot build it in a dierent directory.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide