Mysql-5.5.32 cmake安装 -

cancer_sun
浏览: 32258 次
性别:
最近访客更多访客>>

love_and_love
beyondi18n
hehaipo
wjm_00
博主相关

博客
微博
相册
留言
关于我
文章分类

社区版块

存档分类

Mysql-5.5.32 cmake安装

1.拷贝cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz至/opt文件夹下
2.安装步骤：
--切换到opt目录
[root@mysql ~]# cd /opt
[root@mysql opt]# ls
cmake-2.8.8.tar.gz  mysql-5.5.32.tar.gz  rh

--解压cmake文件
[root@mysql opt]# tar xf cmake-2.8.8.tar.gz
[root@mysql opt]# cd cmake-2.8.8
[root@mysql cmake-2.8.8]# ls
bootstrap                   CompileFlags.cmake    doxygen.config
ChangeLog.manual            configure             Example
ChangeLog.txt               Copyright.txt         Modules
CMakeCPack.cmake            CTestConfig.cmake     Readme.txt
CMakeCPackOptions.cmake.in  CTestCustom.cmake.in  Source
CMakeGraphVizOptions.cmake  CTestCustom.ctest.in  Templates
CMakeLists.txt              DartConfig.cmake      Tests
CMakeLogo.gif               DartLocal.conf.in     Utilities
cmake_uninstall.cmake.in    Docs

--进行cmake的安装
[root@mysql cmake-2.8.8]# ./configure
CMake has bootstrapped.  Now run gmake.

[root@mysql cmake-2.8.8]# gmake
[root@mysql cmake-2.8.8]# gmake install

--添加mysql用户和组
[root@mysql cmake-2.8.8]# groupadd mysql
[root@mysql cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql

--yum安装ncurses-devel
[root@mysql /]# yum install ncurses-devel -y

--解压mysql文件
[root@mysql /]# cd /opt
[root@mysql opt]# tar xf mysql-5.5.32.tar.gz
[root@mysql opt]# cd mysql-5.5.32
[root@mysql mysql-5.5.32]# ls
BUILD        CMakeLists.txt   COPYING  include             libmysqld    mysys      regex      sql-common     tests     win
BUILD-CMAKE  cmd-line-utils   dbug     INSTALL-SOURCE      libservices  packaging  scripts    storage        unittest  zlib
client       config.h.cmake   Docs     INSTALL-WIN-SOURCE  man          plugin     sql        strings        VERSION
cmake        configure.cmake  extra    libmysql            mysql-test   README     sql-bench  support-files  vio

--安装之前编译mysql
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 \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-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 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

--mysql安装
[root@mysql mysql-5.5.32]# make && make install



[root@mysql mysql-5.5.32]# ln -s /application/mysql-5.5.32/ /application/mysql

--以下为单实例安装配置所需执行步骤，多实例可暂时跳过
[root@mysql mysql-5.5.32]# ls
BUILD                CMakeLists.txt           CTestTestfile.cmake   INSTALL-SOURCE      man         scripts        tests
BUILD-CMAKE          cmd-line-utils           dbug                  INSTALL-WIN-SOURCE  mysql-test  sql            unittest
client               config.h.cmake           Docs                  libmysql            mysys       sql-bench      VERSION
cmake                configure.cmake          extra                 libmysqld           packaging   sql-common     VERSION.dep
CMakeCache.txt       COPYING                  include               libservices         plugin      storage        vio
CMakeFiles           CPackConfig.cmake        info_macros.cmake     make_dist.cmake     README      strings        win
cmake_install.cmake  CPackSourceConfig.cmake  install_manifest.txt  Makefile            regex       support-files  zlib

--选择配置文件
[root@mysql mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf'? y

--查看是否有mysql/data目录
[root@mysql mysql-5.5.32]# ll /application/mysql/data/
total 4
drwxr-xr-x. 2 root root 4096 Aug 15 15:38 test


[root@mysql mysql-5.5.32]# chown -R mysql.mysql /application/mysql/data/
[root@mysql mysql-5.5.32]# chmod -R 1777 /tmp/
[root@mysql mysql-5.5.32]# cd /application/mysql/scripts/
[root@mysql scripts]# ls
mysql_install_db
[root@mysql scripts]# cd /application/mysql/scripts/
[root@mysql scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/application/mysql//bin/mysqladmin -u root password 'new-password'
/application/mysql//bin/mysqladmin -u root -h mysql password 'new-password'

Alternatively you can run:
/application/mysql//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /application/mysql/ ; /application/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /application/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems with the /application/mysql//scripts/mysqlbug script!

[root@mysql scripts]# cd ..
[root@mysql mysql]# ls
bin  COPYING  data  docs  include  INSTALL-BINARY  lib  man  mysql-test  README  scripts  share  sql-bench  support-files
[root@mysql mysql]# cd /opt/mysql-5.5.32
[root@mysql mysql-5.5.32]# ls
BUILD                CMakeLists.txt           CTestTestfile.cmake   INSTALL-SOURCE      man         scripts        tests
BUILD-CMAKE          cmd-line-utils           dbug                  INSTALL-WIN-SOURCE  mysql-test  sql            unittest
client               config.h.cmake           Docs                  libmysql            mysys       sql-bench      VERSION
cmake                configure.cmake          extra                 libmysqld           packaging   sql-common     VERSION.dep
CMakeCache.txt       COPYING                  include               libservices         plugin      storage        vio
CMakeFiles           CPackConfig.cmake        info_macros.cmake     make_dist.cmake     README      strings        win
cmake_install.cmake  CPackSourceConfig.cmake  install_manifest.txt  Makefile            regex       support-files  zlib
[root@mysql mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld
[root@mysql mysql-5.5.32]# chmod +x /etc/init.d/mysqld
[root@mysql mysql-5.5.32]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!
[root@mysql mysql-5.5.32]# netstat -lntup|grep 3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      28462/mysqld

--配置环境变量
[root@mysql mysql-5.5.32]# echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile
[root@mysql mysql-5.5.32]# tail -1 /etc/profile
export PATH=/application/mysql/bin:$PATH
[root@mysql mysql-5.5.32]# source /etc/profile
[root@mysql mysql-5.5.32]# echo $PATH
/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

[root@mysql mysql-5.5.32]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.32 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is 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> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1       |
|      | localhost |
| root | localhost |
|      | mysql     |
| root | mysql     |
+------+-----------+
6 rows in set (0.00 sec)

mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.00 sec)

mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
| root | mysql     |
+------+-----------+
4 rows in set (0.00 sec)

mysql> delete from mysql.user where host='mysql';
Query OK, 1 row affected (0.00 sec)

mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
+------+-----------+
3 rows in set (0.00 sec)

mysql> delete from mysql.user where host='::1';
Query OK, 1 row affected (0.00 sec)

mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

[root@mysql mysql-5.5.32]# /application/mysql//bin/mysqladmin -u root password 'cancer'
[root@mysql mysql-5.5.32]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@mysql mysql-5.5.32]# mysql -uroot -pcancer
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.32 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is 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> exit
Bye
[root@mysql mysql-5.5.32]# chkconfig mysqld on
[root@mysql mysql-5.5.32]# chkconfig --list mysqld
mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off
[root@mysql mysql-5.5.32]# cat /etc/sysconfig/i18n
LANG="en_US.UTF-8"
SYSFONT="latarcyrheb-sun16"