MySQL Source code compilation

Cmake-dcmake_install_prefix=/opt/mysql \

-ddefault_charset=utf8 \

-DDEFAULT_COLLATION=UTF8_GENERAL_CI \

-DWITH_EXTRA_CHARSETS:STRING=UTF8,GBK \

-dwith_myisam_storage_engine=1 \

-dwith_innobase_storage_engine=1 \

-dwith_readline=1 \

-denabled_local_infile=1 \

-dmysql_datadir=/opt/data/mysql \

-dmysql_tcp_port=3306 \

Source Installation Mysql5.6,os (Ubuntu 14.04Lts)

2. Download the source package to MySQL website for example: mysql-5.6.16.tar.gz

4. Decompression TAR-XVF mysql-5.6.16.tar.gz

6. Necessary environment preparation

1. install CMake

1. sudo apt-get install cmake

2. Best is up-to-date, if the software center is not up-to-date, you can go to CMake's official download source package to compile and install

2. install g++ compiler     sudo apt-get install g++

3. install dependent libraries Libncurses    sudo Apt-get install Libncurses5-dev

8. Create two directories, the MySQL home directory (basedir) and MySQL Data directory (mysqldata)

   Example: sudo mkdir/opt/mysql_5.6 sudo mkdir/opt/mysqldata

9. into the source directory of the newly unzipped MySQL, using CMake for the configuration of the compilation environment

   With the following parameters:

   sudo cmake.

   -dcmake_install_prefix=/opt/mysql_5.6 (Specifies the directory to install to)

   -dmysql_datadir=/opt/mysqldata (Specify Data directory)

   -ddefault_charset=utf8 (Specifies the DB character set)

   -ddefault_collation=utf8_general_ci (key sentence for solving Chinese garbled characters)

   -dextra_charsets=all

   -denabled_local_infile=1
   

   This step is only for the compilation of the configuration, not the actual installation, just in the current directory generated makefile

   
   

11. sudo make sudo make install (these two are the actual compilation installation)

    
    

13. The above steps are complete, MySQL is already installed, but not yet initialized

15. To MySQL installed Basedir, execute sudo scripts/mysql_install_db--user=root

    Perform initialization of the database, generate some db (such as test,mysql, etc.), followed by the specified user

17.   generate MySQL configuration file
    sudo cp support-files/my-default.cnf/etc/my.cnf

    After you specify the corresponding parameters in the mysqld, for example:

      DataDir =/ Opt/mysqldata

      Port = 3306

19. Finally can start the database, because the password has not been specified, so the first time not to enter a password, a safe mode to start the database

    sudo bin/mysqld_safe--user=root
    

21. Set a password for the root user to enter the database in Safe mode

    Use MySQL;

    UPDATE user SET Password=password (' 123456 ') WHERE user= ' root ';
    FLUSH privileges;

    Alternatively, enable the script directly in the bin directory: mysqladmin-u root-p password Password

22. Register MySQL for Ubuntu system service

    sudo cp $MYSQL _home/support-files/mysql.server/etc/init.d/mysql.server

    sudo chmod +x/etc/init.d/mysql.server

24. Let MySQL boot up

    sudo update-rc.d-f mysql.server defaults

    Cancel boot up sudo update-rc.d-f mysql.server remove

26. Modify MY.CNF, specify MySQL's startup user to modify MY.CNF, and add "User=root" line under the [MYSQLD] block.
    
27. Use of services
    

    Start MySQL:service mysql.server start;

    Stop MySQL:service MySQL. Server stop;

    check MySQL running status: service MySQL. SERVER   status .

29. Add the MySQL startup script to the PATH environment variable,

    sudo gedit/etc/environment

    After the environment variable, add:/opt/mysql_5.6/bin

    That's the bin directory inside your MySQL basedir.

    Source/etc/environment (Let it take effect immediately)

From for notes (Wiz)

MySQL Source code compilation