MySQL Source package manual installation, configuration and testing (pro-test feasible)

Note Editor: wavelet/qq463431476 Blog Home: http://www.cnblogs.com/xiaobo-Linux/

Make a note of this MySQL note and look forward to useful later!

REDHAT6 uses the CentOS yum source to explain MySQL's source installation and configuration. Here continue on to the blog Php,apache configuration, now write MySQL configuration. Lamp built to this success!

Apache Source Installation Notes: http://www.cnblogs.com/xiaobo-Linux/p/4637056.html

PHP Source Installation Notes: http://www.cnblogs.com/xiaobo-Linux/p/4637775.html

Now start to write MySQL source installation and configuration:

1. Install MySQL dependency:

Yum install Cmakeyum install ncurses-devel

2, download the MySQL source installation package and unzip:

MySQL:  http://distfiles.macports.org/mysql5/ 

TAR-ZXVF  mysql-5.5.  tar.gz.

3. Create MySQL installation directory and database storage directory

Mkdir-p/work/installed/mysql   installation directory               -p/work/installed/mysql/data  Database storage Directory

4. Create MySQL users and user groups

Groupadd MySQL
Useradd-r-G MySQL MySQL

5. Install MySQL:

Go to unpack folder to execute:

CMake. -dcmake_install_prefix=/work/installed/mysql -dmysql_datadir=/work/installed/mysql/data  - Ddefault_charset=utf8-ddefault_collation=utf8_general_ci-dextra_charsets=all-denabled_local_infile=1

CMake. -dcmake_install_prefix=/work/installed/mysql-dmysql_datadir=/work/installed/mysql/data-ddefault_charset= Utf8-ddefault_collation=utf8_general_ci-dextra_charsets=all-denabled_local_infile=1

Where:/work/installed/mysql for the installation directory of MySQL, this can be customized, you like to install where to install.

parameter Description:-dcmake_install_prefix=/usr/local/mysql        // installation directory -dinstall_datadir=/ usr/local/mysql/data         // Database storage directory -ddefault_charset=utf8                    //  Use the UTF8 character -ddefault_collation=utf8_general_ci            // check character -dextra_charsets=all                        // Install all extended character sets -denabled_local_infile=1  // allow import of data from local　　　　　　　　　　

Follow the following sequence:

Makemake Install

If an error occurs:

File

Error:./bin/mysqld:character set ' Utf8-ddefault_collation=utf8_general_ci ' is not a compiled Character set and was not speci Fied in the '/work/installed/mysql/share/charsets/index.xml ' file

is a character set and character conflict, so when compiling the character and character set options are added, and to be compatible! To modify the compilation parameters:

Then execute this command:

Cmake-dcmake_install_prefix=/work/installed/mysql-dextra_charsets=all-denabled_local_infile=1-dwith_readline=1 -ddefault_charset=utf8-ddefault_collation=utf8_general_ci-dwith_embedded_server=1-dwith_ssl=system

Cmake-dcmake_install_prefix=/work/installed/mysql-dextra_charsets=all-denabled_local_infile=1-dwith_readline=1 -ddefault_charset=utf8-ddefault_collation=utf8_general_ci-dwith_embedded_server=1-dwith_ssl=system

Note that if you recompile or compile an error:

Note: When recompiling, you need to clear the old object file and cache information. # make clean# rm-f cmakecache.txt# rm-rf/etc/my.cnf

Then: make, make install.

6. Set directory Permissions

Execute the command under the installed MySQL directory:

-R root:mysql.  // Set the owner owner of all files in the current directory to root, and the owning group is MySQL-R mysql:mysql Data

7. Add the MySQL startup service to the system service

CP SUPPORT-FILES/MY-MEDIUM.CNF/ETC/MY.CNF

8. Create a table of system databases

scripts/mysql_install_db--user=mysql

9. Setting Environment variables

# Vi/root/.bash_profile

In Path=$PATH:$HOME/bin add parameters as:

Path=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/lib

Source/root/.bash_profile

10. Start MySQL

Act 1:
 execute in MySQL-installed directory to start MySQL: 
./bin/mysqld_safe-- User=mysql & 
  
 Startup log is written under this file:/work/installed/mysql/data/localhost.err directory varies by person , your own installation directory 
 
 Method 2: 
 CP support-files/mysql.server /etc/init.d/mysql //< Span style= "color: #008000;" > add the MySQL startup service to the system service   
 # service Mysql.server start  
  
 # Service mysql.server Stop 
  
 # service mysql.server Restart         
 
 Additionally, the command to close the MySQL service is: 
 mysqladmin-u root-p shutdown   

11. Modify the password of the root user of MySQL and open the remote connection

# Mysql-u Root MySQL

Mysql>use MySQL;
Mysql>desc user;
Mysql> GRANT All privileges on * * to [email protected]"%"root "; The ability to add remote connections for root.
Mysql>update user Set Password = Password (' xxxxxx ') where user= ' root '; Here xxxx for their own input MySQL password, the root user

Mysql>flush privileges;
Mysql>exit

Re-login: Mysql-u root-p

If remote connections are not yet in progress, turn off the firewall
[[email protected] rhel5~] # /etc/rc.d/init.d/iptables stop 

12, 12-1, test MySQL and combine MySQL with PHP

Login Mysql:mysql-u Root-p

Enter password: MySQL (enter the MySQL password you set)

Set up a database, create a table, insert data:

mysql> CREATE DATABASE Test1;mysql> Use test1;mysqlint(4null  Char(()); MySQL> INSERT into student (name) VALUES ('Tom');    

Tom's name is inserted here, then PHP is configured, and the page content of the publication is written:

Reconfigure PHP:

./configure--prefix=/work/installed/php  --with-apxs2=/work/installed/apache/bin/apxs--with-mysqli=/work/ Installed/mysql/bin/mysql_config

Here the PHP installation path is the original configuration installed, according to their own circumstances. Previous PHP Configuration: http://www.cnblogs.com/xiaobo-Linux/p/4637775.html

Apache Configuration: http://www.cnblogs.com/xiaobo-Linux/p/4637056.html

Then in the PHP source code decompression package to execute:

Make

Make install

Last reboot Apache: Execute restart in Apache installed directory:/work/installed/apache/bin/apachectl restart

12-2. Write index.php This file in the directory of Apache's publishing home page.

My publishing directory is:/home/web/index.php

Write Php:vim index.php:

The purpose of this is to show the data that Tom has just inserted:

<?PHP $mysql=NewMySQL (); $mysql->connect ('localhost','Root','MySQL','test1'); //Create a query$sqlstr ='SELECT * FROM Student'; //send a query to MySQL$result = $mysqlquery ($SQLSTR);  while($row = $resultFetch_object ()) {$name= $rowname;    Echo $name; }?>

Restart Apache again:

./apachectl Restart

If Tom's words show that MySQL is successful!

To this MySQL installation is complete! Lamp===apache+mysql+php also build success!

MySQL Source package manual installation, configuration and testing (pro-test feasible)