procedure of intall and setup centos 6.5

1. 
   select webserver install option,and select ,uncheck the postgresql option

selected some “… platform” options

selected all virtualization options

1. setup network and check ssh service

 

ok,now install mysql

开始先下载了mysql的二进制包 发现安装过程各种不顺利，放弃

然后下载源码安装，由于是5.6.15版本 需要cmake，

cmake . 报错

发现gcc也没有，原来是安装系统的时候没有选择Development tools,当时以为是ide之类的 原来是些cmake gcc等之类的开发工具，然后

yum groupinstall "Development tools"

ok搞定，再次cmake

发现报错：Could NOT find Threads  (missing:  Threads_FOUND)

google之，尝试删掉CMakeCache.txt

 

安装msyql(cellar目录是我自己建的，可任意）：

cmake -DMAKE_INSTALL_PREFIX=/usr/local/cellar/mysql-5.6.15 -DMYSQL_DATADIR=/usr/local/cellar/mysql-5.6.15/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/usr/local/cellar/mysql-5.6.15/var/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all

make && make install

 

./scripts/mysql_install_db --user=mysql --basedir=/usr/local/cellar/mysql-5.6.15/ --datadir=/usr/local/cellar/mysql-5.6.15/data/

注意：utf8 不要写成utf-8 否则会启动时候出错

然后出现了2个警告：

1、WARNING: The host 'host01.funplus' could not be looked up with /usr/local/cellar/mysql-5.6.15//bin/resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

2、Installing MySQL system tables...2014-01-26 21:38:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

 

mysql 安装成功后提示内容：

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: 

  /usr/local/cellar/mysql-5.6.15//bin/mysqladmin -u root password 'new-password'

  /usr/local/cellar/mysql-5.6.15//bin/mysqladmin -u root -h host01.funplus password 'new-password'

 

Alternatively you can run:

  /usr/local/cellar/mysql-5.6.15//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 . ; /usr/local/cellar/mysql-5.6.15//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/local/cellar/mysql-5.6.15//my.cnf and

will be used by default by the server when you start it.

You may edit this file to change server settings

 

  

5.1.3. Server Command Options

When you start the mysqld server, you can specify program options using any of the methods described inSection 4.2.3, “Specifying Program Options”. The most common methods are to provide options in an option file or on the command line. However, in most cases it is desirable to make sure that the server uses the same options each time it runs. The best way to ensure this is to list them in an option file. See Section 4.2.3.3, “Using Option Files”. That section also describes option file format and syntax.

mysqld reads options from the [mysqld] and [server] groups. mysqld_safe reads options from the[mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. mysql.server reads options from the[mysqld] and [mysql.server] groups.

 

2.9.4. MySQL Source-Configuration Options

The following table shows the available CMake options. In the Default column, PREFIX stands for the value of the CMAKE_INSTALL_PREFIX option, which specifies the installation base directory. This value is used as the parent location for several of the installation subdirectories.

 

mysql安装总结：

装了N多次，还是经常出问题，不要选择二进制包，用源码安装，如果不需要更方便配置的话可以用yum安装

cmake的参数官网上有详细介绍，网上搜到的很多处理错误的方法可能是针对低版本的，像mysql 5.6这样比较新的版本不一定适用

基本步骤：

1. 下载源码包，解压
2. 建立mysql用户和组，并分配指定目录的权限
3. cmake编译，注意设定合适的参数
4. 到安装后的目录中找到执行./script/mysql_install_db,注意指定user basedir datadir参数
5. 启动mysql 可按照提示信息处理

 

# Preconfiguration setup
shell> groupadd mysql
shell> useradd -r -g mysql mysql
# Beginning of source-build specific instructions
shell> tar zxvf mysql-VERSION.tar.gz
shell> cd mysql-VERSION
shell> cmake .
shell> make
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server

mysql_install_db creates a default option file named my.cnf in the base installation directory. This file is created from a template included in the distribution package named my-default.cnf. For more information, seeSection 5.1.2.2, “Using a Sample Default Server Configuration File”.

 

3、前面由于选了虚拟化相关组件，但是发现版本较低

yum remove kvm

yum install kvm

ok 版本提高了

yum remove libvirt libvirt-client

yum install libvirt libirt-client

发现版本没变 还是0.10.2