摘要：SuSE11sp3 64位操作系统、 MySQL5.6.40 编译安装、单实例

注：kingtry是我的主机名

一、环境准备

操作系统：SuSE版本11sp3，64位

kingtry:~#uname-aLinuxkingtry3.0.76-0.11-default#1SMPFriJun1408:21:43UTC2013(ccab990)x86_64x86_64x86_64GNU/Linuxkingtry:~#cat/etc/SuSE-releaseSUSELinuxEnterpriseServer11(x86_64)VERSION=11PATCHLEVEL=3

二、依赖包

tack-5.6-90.55.x86_64.rpmncurses-devel-5.6-90.55.x86_64.rpmbison-2.3-127.112.x86_64.rpm

三、编译安装cmake-2.8.4.tar.gz

kingtry:~#tar-xfcmake-2.8.4.tar.gzkingtry:~#cdcmake-2.8.4/kingtry:~/cmake-2.8.4#./configurekingtry:~/cmake-2.8.4#make&&makeinstall

四、软件准备

mysql-5.6.40.tar.gz

五、安装过程

1、创建群组及用户

kingtry:~#groupaddmysqlkingtry:~#useradd-gmysqlmysql

2、创建相关目录

kingtry:~#mkdir-p/data/mysql/{data,tmp}#创建存放数据文件目录，data与tmp之间不能为空格kingtry:~#chown-Rmysql.mysql/data/mysql

3、解压文件，并修改解压后的文件夹的名称

kingtry:~#tar-xfmysql-5.6.40.tar.gz

4、编译安装

kingtry:~#cdmysql-5.6.40/kingtry:~/mysql-5.6.40#cmake.-DCMAKE_INSTALL_PREFIX=/root/mysql\-DSYSCONFDIR=/data/mysql\-DMYSQL_DATADIR=/data/mysql/data\-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock\-DMYSQL_TCP_PORT=3306\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DEXTRA_CHARSETS=allkingtry:~/mysql-5.6.40#make&&makeinstall

六、初始化数据库

注：此处不能使用安装文件下的同名文件（不能使用/root/mysql-5.6.40/scripts/mysql_install_db）

kingtry:~#/root/mysql/scripts/mysql_install_db--basedir=/root/mysql--datadir=/data/mysql/data--user=mysql

七、创建配置文件/data/mysql/my.cnf

my.cnf内容参考如下：

#Foradviceonhowtochangesettingspleasesee#http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html[client]#password=your_passwordport=3306socket=/data/mysql/mysql.sockdefault-character-set=utf8#Herefollowsentriesforsomespecificprograms#TheMySQLserver[mysqld]port=3306basedir=/root/mysqldatadir=/data/mysql/datatmpdir=/data/mysql/tmpsocket=/data/mysql/mysql.sockcharacter-set-server=utf8collation-server=utf8_general_cipid-file=/data/mysql/mysql.piduser=mysqlexplicit_defaults_for_timestamplower_case_table_names=1max_connections=1000back_log=1024open_files_limit=10240table_open_cache=5120#bind-address=127.0.0.1#skip-name-resolveskip-external-lockinglocal-infile=1key_buffer_size=32Mmax_allowed_packet=1Mtable_open_cache=64sort_buffer_size=512Knet_buffer_length=8Kread_buffer_size=256Kread_rnd_buffer_size=512Kmyisam_sort_buffer_size=8M#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement,#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.#NotethatusingthisoptionwithoutenablingnamedpipesonWindows#(viathe"enable-named-pipe"option)willrendermysqlduseless!##skip-networking#ReplicationMasterServer(default)#binaryloggingisrequiredforreplicationlog-bin=/data/mysql/mysql-bin#binaryloggingformat-mixedrecommendedbinlog_format=mixed#requireduniqueidbetween1and2^32-1#defaultsto1ifmaster-hostisnotset#butwillnotfunctionasamasterifomittedserver-id=1#ReplicationSlave(commentoutmastersectiontousethis)##Toconfigurethishostasareplicationslave,youcanchoosebetween#twomethods:##1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-#thesyntaxis:##CHANGEMASTERTOMASTER_HOST=<host>,MASTER_PORT=<port>,#MASTER_USER=<user>,MASTER_PASSWORD=<password>;##whereyoureplace<host>,<user>,<password>byquotedstringsand#<port>bythemaster'sportnumber(3306bydefault).##Example:##CHANGEMASTERTOMASTER_HOST='125.564.12.1',MASTER_PORT=3306,#MASTER_USER='joe',MASTER_PASSWORD='secret';##OR##2)Setthevariablesbelow.However,incaseyouchoosethismethod,then#startreplicationforthefirsttime(evenunsuccessfully,forexample#ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto#connect),theslavewillcreateamaster.infofile,andanylater#changeinthisfiletothevariables'valuesbelowwillbeignoredand#overriddenbythecontentofthemaster.infofile,unlessyoushutdown#theslaveserver,deletemaster.infoandrestarttheslaverserver.#Forthatreason,youmaywanttoleavethelinesbelowuntouched#(commented)andinsteaduseCHANGEMASTERTO(seeabove)##requireduniqueidbetween2and2^32-1#(anddifferentfromthemaster)#defaultsto2ifmaster-hostisset#butwillnotfunctionasaslaveifomitted#server-id=2##Thereplicationmasterforthisslave-required#master-host=<hostname>##Theusernametheslavewilluseforauthenticationwhenconnecting#tothemaster-required#master-user=<username>##Thepasswordtheslavewillauthenticatewithwhenconnectingto#themaster-required#master-password=<password>##Theportthemasterislisteningon.#optional-defaultsto3306#master-port=<port>##binarylogging-notrequiredforslaves,butrecommended#log-bin=mysql-bin#UncommentthefollowingifyouareusingInnoDBtables#innodb_data_home_dir=/var/lib/mysqlinnodb_data_file_path=ibdata1:10M:autoextend#innodb_log_group_home_dir=/var/lib/mysql#Youcanset.._buffer_pool_sizeupto50-80%#ofRAMbutbewareofsettingmemoryusagetoohighinnodb_buffer_pool_size=256M#innodb_additional_mem_pool_size=2M#Set.._log_file_sizeto25%ofbufferpoolsize#innodb_log_file_size=5M#innodb_log_buffer_size=8M#innodb_flush_log_at_trx_commit=1#innodb_lock_wait_timeout=50innodb_buffer_pool_instances=2innodb_read_io_threads=8innodb_write_io_threads=8innodb_purge_threads=1slow_query_log=1long_query_time=10log-queries-not-using-indexeslog-error=/data/mysql/mysql.errexpire-logs-days=10[mysqldump]quickmax_allowed_packet=512Mnet_buffer_length=16384[mysql]auto-rehash#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL#safe-updates[myisamchk]key_buffer_size=20Msort_buffer_size=20Mread_buffer=2Mwrite_buffer=2M[mysqlhotcopy]interactive-timeout

八、配置环境变量

kingtry:~#echo'exportPATH=/root/mysql/bin:$PATH'>>/etc/profilekingtry:~#source/etc/profile

九、启动MySQL服务

kingtry:~#touch/data/mysql/mysql.err#当前版本该文件不会自动创建，需要手工创建kingtry:~#chownmysql.mysql/data/mysql/mysql.errkingtry:~#mysqld_safe--defaults-file=/data/mysql/my.cnf--user=mysql&

十、安装后配置之root密码修改

默认情况下root密码为空，这在生产环境下肯定不行的。修改root密码的方式有以下两种，随便哪个都行：

1、命令方式（注：首次修改密码，修改前密码为空）

kingtry:~#mysqladmin-urootpassword'root123'

要注意如果执行以上步骤之后root密码已经不为空，如果此时想再次修改root密码，上面命令就不行了，需要用到下面的命令：

kingtry:~#mysqladmin-uroot-ppassword'root1234'Enterpassword:

这是交互式方式修改，输入的当前密码，password参数后面跟随的是想要修改成的密码

十一、客户端连接MySQL服务

kingtry:~#mysql-uroot-p

十二、防火墙允许3306端口

kingtry:~#vi/etc/sysconfig/SuSEfirewall2

在FW_SERVICES_EXT_TCP增加3306端口，如果存在其他端口，则空格隔开，如：

FW_SERVICES_EXT_TCP="21223306"

重启防火墙：

kingtry:~#rcSuSEfirewall2restart

十三、设置远程访问

先登陆mysql服务器，授权root用户可以远程登陆

mysql>grantallPRIVILEGESon*.*toroot@'%'identifiedby'root123';QueryOK,0rowsaffected(0.00sec)mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)mysql>

注：生产环境最好只允许root在特定IP的机器上才能远程访问。