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

<< 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 79 `bin' This directory contains client programs and the server You should add the full pathname of this directory to your PATH environment variable so that your shell nds the MySQL programs properly. See Appendix F [Environ- ment variables], page 770. `scripts' This directory contains the mysql_install_db script used to initialise the mysql database containing the grant tables that store the server access permissions. 8. If you would like to use mysqlaccess and have the MySQL distribution in some non- standard place, you must change the location where mysqlaccess expects to nd the mysql client. Edit the `bin/mysqlaccess' script at approximately line 18. Search for a line that looks like this: $MYSQL = '/usr/local/bin/mysql'; # path to mysql executable Change the path to re ect the location where mysql actually is stored on your system. If you do not do this, you will get a Broken pipe error when you run mysqlaccess. 9. Create the MySQL grant tables (necessary only if you haven't installed MySQL before): shell> scripts/mysql_install_db Note that MySQL versions older than Version 3.22.10 started the MySQL server when you run mysql_install_db. This is no longer true! 10. Change ownership of binaries to root and ownership of the data directory to the user that you will run mysqld as: shell> chown -R root /usr/local/mysql/. shell> chown -R mysql /usr/local/mysql/data shell> chgrp -R mysql /usr/local/mysql/. The rst command changes the owner attribute of the les to the root user, the second one changes the owner attribute of the data directory to the mysql user, and the third one changes the group attribute to the mysql group. 11. If you want to install support for the Perl DBI/DBD interface, see Section 2.7 [Perl support], page 139. 12. If you would like MySQL to start automatically when you boot your machine, you can copy support-files/mysql.server to the location where your system has its startup les. More information can be found in the support-files/mysql.server script itself and in Section 2.4.3 [Automatic start], page 98. After everything has been unpacked and installed, you should initialise and test your dis- tribution. You can start the MySQL server with the following command: shell> bin/safe_mysqld --user=mysql & Now proceed to Section 4.7.2 [safe_mysqld], page 274, and See Section 2.4 [Post- installation], page 91. 2.3 Installing a MySQL Source Distribution

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