mysql5.5的安装步骤

好久没有安装mysql了，今天装了下，还有点不流畅，把详细的安装的流程写下来~，后续把mysql日常操作都写成checklist

1.创建mysql组和mysql用户

groupadd mysql

useradd -g mysql mysql

2.创建相关的目录(根据自己的规则设置目录)

mkdir

/data/dbdata

/usr/local/mysql

/usr/local/mysql/tmp

或者(推荐使用下面的)

mkdir

/data/dbdata/mysqldata  ---表结构文档，ibdata,logfie，errlog,

/data/dbdata/mysqllog  --主要包括binlog目录，slow-log，relay-log目录

/data/dbdata/mysqllog/binlog  --存放binlog

/data/dbdata/mysqllog/relay-log

3.更改目录的owner,group

chown -R mysql /data/dbdata /usr/local/mysql /usr/local/mysql/tmp

chgrp -R mysql /data/dbdata /usr/local/mysql /usr/local/mysql/tmp

4.安装cmake

5.编译配置

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/dbdata -DWITH_EXTRA_CHARSETS=complex -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_USER=mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_DEBUG=0 -DWITH_PARTITION_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=usr/local/mysql/tmp/mysql.sock -DWITH_MEMORY_STORAGE_ENGINE=1
----------------------
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 -DMYSQL_DATADIR=/data/mysql3307/mysqldata/data -DINSTALL_SBINDIR=sbin -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci-DWITH_SS
L=system -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1

  cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/dbdata/mysqldata -DWITH_EXTRA_CHARSETS=complex -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_DEBUG=0 -DWITH_SSL=system  -DWITH_PARTITION_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=usr/local/mysql/tmp/mysql.sock 

 

  

./configure	Cmake .	解释说明
--prefix	-DCMAKE_INSTALL_PREFIX	指定安装目录，默认安装在/usr/local
--with-extra-charsets	-DEXTRA_CHARSETS	Use charsets in addition to default (none, complex,all, or a list selected from the above sets)
--enable-assembler	none	允许使用汇编模式(优化性能)
--with-charset	-DDEFAULT_CHARSET	Default character set
--enable-thread-safe-client	none	以线程方式端编译客户端,如果是 all-static，静态链接可以提高性能
--with-big-tables	none	Support tables with more than 4 G rows even on 32 bit platforms
--with-readline	-DWITH_READLIN=1	--Use system readline instead of bundled copy
--with-ssl	-DWITH_SSL=system	Include SSL support
--enable-local-infile	DENABLED_LOCAL_INFILE=1	Enable LOAD DATA LOCAL INFILE (default: disabled)
--with-plugins	archive,blackhole在cmake中没有直接对应的相同选项。对于csv,myisam,myisammrg,heap在cmake中是不需要明确指定存储引擎的名称，因为它们是强制性安装。可以使用以下选择来安装innodb,archive,blackhole存储引擎 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -WIHTOUT_PARTITION_STORAGE_ENGINE=1	Available configurations are: none max max-no-ndb all. Mysql5.1开始，编译添加innodb插件就从--with-innodb改成了--with-plugins=innobase，如果多个插件,可以写成：-with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster用逗号分开
--localstatedir	-DMYSQL_DATADIR	数据的目录，缺省会在安装目录下的var目录

 

6.初始化系统数据库

cp mysql_install_db ../bin

./bin/mysql_install_db --basedir=/usr/local/mysql --defaults-file=/etc/my.cnf --datadir=/data/dbdata --user=mysql ;

 

7.启动数据库

./bin/mysqld_safe --defaults-file=/etc/my.cnf  --user=mysql &

 

8.制作启动程序

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 2345 mysqld on