Cmake compilation and installation of mysql5.5
Compile and install Mysql5.5 in CMAKE mode
1. Compile and install MySQL5.5.32 in source code cmake mode
Install before installation:
Yum install ncurses-devel-y
Download the Mysql and cmake installation packages:
Wget http://wwwNaNake.org/files/v2.8/cmake-2.8.8.tar.gz
1.2 View the system environment
Cat / etc/redhat-release
Uname-r
Uname-m
1.3 install the cmakepackage
Tar zxf cmake-2.8.8.tar.gz
Cd cmake-2.8.8
. / configure
Gmake
Gmake install
Cd.. /
1.4 start installing mysql
1.4.1 create users and groups
Groupadd mysql
Useradd mysql-s / sbin/nologin-M-g mysql
Yum install ncurses-devel-y
1.4.2 decompress and compile MySQL
Tar zxf mysql-5.5.32.tar.gz
Cd mysql-5.5.32
Cmake-DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32\
-DMYSQL_DATADIR=/application/mysql-5.5.32/data\
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock\
-DDEFAULT_CHARSET=gbk\
-DDEFAULT_COLLATION=gbk_chinese_ci\
-DENABLED_LOCAL_INFILE=ON\
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DWITH_FEDERATED_STORAGE_ENGINE=1\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1\
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
Make
Make install
Ln-s / application/mysql-5.5.32/ / application/mysql
If there is no error in the above operation, the installation of the MySQL software is considered successful.
1.4.3 initialization configuration MySQL
1. View the default template profile
[root@Mysqlmysql-5.5.32] # ll support-files/my*.cnf
-rw-r--r--1 root root 4759 Apr 25 18:19support-files/my-huge.cnf
-rw-r--r--1 root root 19809 Apr 25 18:19 support-files/my-innodb-heavy-4G.cnf
-rw-r--r--1 root root 4733 Apr 25 18:19support-files/my-large.cnf
-rw-r--r--1 root root 4744 Apr 25 18:19support-files/my-medium.cnf
-rw-r--r--1 root root 2908 Apr 25 18:19support-files/my-small.cnf
two。 Select a profile
/ bin/cpsupport-files/my-small.cnf / etc/my.cnf
The test environment is small, and the production environment can choose support-files/my-innodb-heavy-4G.cnf according to the hardware.
3. Configure environment variables
Echo 'export PATH=/application/mysql/bin:$PATH' > > / etc/profile
Tail-1 / etc/profile
Source / etc/profile
Echo $PATH
4. Initialize data files (error-prone steps)
# create a directory of mysql data files
Mkdir-p / application/mysql/data
# authorize mysql users to access the installation directory of mysql
Chown-R mysql.mysql / application/mysql/*
Chmod-R 1777 / tmp
# initialize the database file (if you reinitialize the database file, you must first execute: rm-fr / application/mysql/data/*)
/ application/mysql/scripts/mysql_install_db-basedir=/application/mysql--datadir=/application/mysql/data-user=mysql
Special hint:
a. An error will occur if you omit the specified datadir with mysql 5.0. 5. 1.
5. Set the normal way to start the shutdown script
Cd / application/tools/mysql-5.5.32/
# copy the mysql startup script to / etc/init.d/
Cp support-files/mysql.server / etc/init.d/mysqld
# Grant 700 permissions, that is, the script can be executed
Chmod 700 / etc/init.d/mysqld
/ etc/init.d/mysqldstart
Chkconfig mysqld on
Chkconfig-list mysqld
6. Log in to mysql
7. Simple optimization of mysql
a. Delete the test library:
Mysql > show databases
+-+
| | Database |
+-+
| | information_schema |
| | mysql |
| | performance_schema |
| | test |
+-+
4 rowsin set (0.03 sec)
Mysql > drop database test
Query OK, 0 rows affected (0.04 sec)
Mysql > show databases
+-+
| | Database |
+-+
| | information_schema |
| | mysql |
| | performance_schema |
+-+
3 rowsin set (0.00 sec)
b. Clear and modify administrator users
Mysql > select user,host from mysql.user
+-+ +
| | user | host |
+-+ +
| | root | 127.0.0.1 | |
| | root |:: 1 |
| | Mysql |
| | root | Mysql |
| | localhost |
| | root | localhost |
+-+ +
6 rowsin set (0.00 sec)
Mysql > delete from mysql.user
QueryOK, 6 rows affected (0.07 sec)
Mysql > select user,host from mysql.user
Emptyset (0.00 sec)
Mysql > grant all privileges on *. * to system@'localhost' identified by '1234' withgrant option
QueryOK, 0 rows affected (0.00 sec)
Mysql > flush privileges
QueryOK, 0 rows affected (0.00 sec)
Mysql > grant all privileges on *. * to system@'127.0.0.1' identified by '1234' withgrant option
QueryOK, 0 rows affected (0.00 sec)
Mysql > select user,host from mysql.user
+-+ +
| | user | host |
+-+ +
| | system | 127.0.0.1 | |
| | system | localhost |
+-+ +
2 rowsin set (0.00 sec)
Operation procedure:
[root@mysqltools] # cat / etc/redhat-release
CentOSrelease 6.4 (Final)
[root@mysqltools] # uname-r
2.6.32-358.el6.x86_64
[root@mysqltools] # uname-m
X86_64
[root@mysqltools] # tar zxf cmake-2.8.8.tar.gz
[root@mysqltools] # cd cmake-2.8.8
[root@mysqlcmake-2.8.8] #. / configure
CMakehas bootstrapped. Now run gmake.
[root@Mysqlcmake-2.8.8] # gmake
[root@Mysqlcmake-2.8.8] # gmake install
[root@Mysqlapplication] # groupadd mysql
[root@Mysqlapplication] # useradd mysql-s / sbin/nologin-M-g mysql
[root@Mysqltools] # tar zxf mysql-5.5.32.tar.gz
[root@Mysqltools] # cd mysql-5.5.32
[root@Mysqlmysql-5.5.32] # cmake. -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32\
Cmake. -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32\
-DMYSQL_DATADIR=/application/mysql-5.5.32/data\
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock\
-DDEFAULT_CHARSET=gbk\
-DDEFAULT_COLLATION=gbk_chinese_ci\
-DENABLED_LOCAL_INFILE=ON\
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DWITH_FEDERATED_STORAGE_ENGINE=1\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1\
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
# Build files have been written to: / application/tools/mysql-5.5.32 if this indicates that cmake is successful
[root@Mysqlmysql-5.5.32] # make
[root@Mysqlmysql-5.5.32] # make install
[root@Mysqlmysql-5.5.32] # ln-s / application/mysql-5.5.32//application/mysql
[root@Mysqlmysql-5.5.32] # ll support-files/my*.cnf
-rw-r--r--1 root root 4759 Apr 25 18:19support-files/my-huge.cnf
-rw-r--r--1 root root 19809 Apr 25 18:19 support-files/my-innodb-heavy-4G.cnf
-rw-r--r--1 root root 4733 Apr 25 18:19support-files/my-large.cnf
-rw-r--r--1 root root 4744 Apr 25 18:19support-files/my-medium.cnf
-rw-r--r--1 root root 2908 Apr 25 18:19support-files/my-small.cnf
[root@Mysqlmysql-5.5.32] # cp support-files/my-small.cnf / etc/my.cnf
[root@Mysqlmysql-5.5.32] # echo 'export PATH=/application/mysql/bin:$PATH' > > / etc/profile
[root@Mysqlmysql-5.5.32] # tail-1 / etc/profile
ExportPATH=/application/mysql/bin:$PATH
[root@Mysqlmysql-5.5.32] # source / etc/profile
[root@Mysqlmysql-5.5.32] # echo $PATH
/ application/mysql/bin:/application/mysql/bin/:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
[root@Mysqlmysql-5.5.32] # mkdir-p / application/mysql/data
[root@Mysqlmysql-5.5.32] # chown-R mysql.mysql / application/mysql/*
[root@Mysqlmysql-5.5.32] # chmod-R 1777 / tmp
[root@Mysqlmysql-5.5.32] # / application/mysql/scripts/mysql_install_db--basedir=/application/mysql-- datadir=/application/mysql/data--user=mysql
[root@Mysqlmysql-5.5.32] # cp support-files/mysql.server / etc/init.d/mysqld
[root@Mysqlmysql-5.5.32] # chmod 700 / etc/init.d/mysqld
[root@Mysqlmysql-5.5.32] # chkconfig mysqld on
[root@Mysqlmysql-5.5.32] # chkconfig-- list mysqld
Mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
Root@Mysqlmysql-5.5.32] # mysql
Welcometo the MySQL monitor. Commands end with; or\ g.
YourMySQL connection id is 2
Serverversion: 5.5.32 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracleis a registered trademark of Oracle Corporation and/or its
Affiliates.Other names may be trademarks of their respective
Owners.
Type'help;' or'\ h' for help. Type'\ c'to clear the current input statement.
Mysql >
Simple optimization of mysql
a. Delete the test library:
Mysql > show databases
+-+
| | Database |
+-+
| | information_schema |
| | mysql |
| | performance_schema |
| | test |
+-+
4 rowsin set (0.03 sec)
Mysql > drop database test
QueryOK, 0 rows affected (0.04 sec)
Mysql > show databases
+-+
| | Database |
+-+
| | information_schema |
| | mysql |
| | performance_schema |
+-+
3 rowsin set (0.00 sec)
b. Clear and modify administrator users
Mysql > select user,host from mysql.user
+-+ +
| | user | host |
+-+ +
| | root | 127.0.0.1 | |
| | root |:: 1 |
| | Mysql |
| | root | Mysql |
| | localhost |
| | root | localhost |
+-+ +
6 rowsin set (0.00 sec)
Mysql > delete from mysql.user
Query OK, 6 rows affected (0.07 sec)
Mysql > select user,host from mysql.user
Emptyset (0.00 sec)
Mysql > grant all privileges on *. * to system@'localhost' identified by '1234' withgrant option
Query OK, 0 rows affected (0.00 sec)
Mysql > flush privileges
Query OK, 0 rows affected (0.00 sec)
Mysql > grant all privileges on *. * to system@'127.0.0.1' identified by '1234' withgrant option
Query OK, 0 rows affected (0.00 sec)
Mysql > select user,host from mysql.user
+-+ +
| | user | host |
+-+ +
| | system | 127.0.0.1 | |
| | system | localhost |
+-+ +
2 rowsin set (0.00)
1. Problems encountered when CMAKE installs Mysql:
-- Check size of wint_t-done
-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMakeError at cmake/readlineNaNake:83 (MESSAGE):
Curses library not found. Please install appropriate package
Remove CMakeCache.txt and rerun cmake.OnDebian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it isncurses-devel.
CallStack (most recent call first):
Cmake/readlineNaNake:127 (FIND_CURSES)
Cmake/readlineNaNake:217 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:269 (MYSQL_CHECK_READLINE)
Configuring incomplete, errors occurred!
Solution:
Rm CMakeCache.txt
Yum install ncurses-devel-y
And then cmake.
