摘要：SuSE11sp3 64位操作系统、MySQL5.6.40rpm安装包

注：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

二、检测是否安装过MySQL

kingtry:~#rpm-qa|grep-imysqllibmysqlclient_r15-5.0.96-0.6.1libqt4-sql-mysql-4.6.3-5.25.4MySQL-client-community-5.1.73-1.sles11MySQL-server-community-5.1.73-1.sles11

注意输出的MySQL-*，表示已经安装过。lib开头的可以忽略。

输入以下命令删除：

kingtry:~#rpm-eMySQL-client-community-5.1.73-1.sles11kingtry:~#rpm-eMySQL-server-community-5.1.73-1.sles11

三、软件准备

MySQL-server-5.6.40-1.sles11.x86_64.rpmMySQL-client-5.6.40-1.sles11.x86_64.rpm

四、安装过程

kingtry:~#rpm-ivhMySQL-*warning:MySQL-client-5.6.40-1.sles11.x86_64.rpm:HeaderV3DSAsignature:NOKEY,keyID5072e1f5Preparing...###########################################[100%]1:MySQL-server###########################################[50%]warning:usermysqldoesnotexist-usingrootwarning:groupmysqldoesnotexist-usingrootwarning:usermysqldoesnotexist-usingrootwarning:groupmysqldoesnotexist-usingrootinsserv:Servicenetworkismissedintherunlevels4touseservicemysqlmysql0:off1:off2:on3:on4:on5:on6:off[......此处省略若干行......]Arandomrootpasswordhasbeenset.Youwillfinditin'/root/.mysql_secret'.2:MySQL-client###########################################[100%]kingtry:~#

注意：上面输出内容中有个文件 /root/.mysql_secret，含有mysql的root用户的默认密码

如果想查询rpm包详细的安装文件列表及每个文件的实际存储路径，可通过命令rpm -ql来查询，如：

kingtry:~#rpm-qlMySQL-server-5.6.40-1.sles11/etc/init.d/mysql/etc/logrotate.d/mysql/etc/my.cnf/etc/my.cnf.d/usr/bin/innochecksum/usr/bin/my_print_defaults/usr/bin/myisam_ftdump/usr/bin/myisamchk/usr/bin/myisamlog/usr/bin/myisampack/usr/bin/mysql_convert_table_format/usr/bin/mysql_fix_extensions/usr/bin/mysql_install_db/usr/bin/mysql_plugin/usr/bin/mysql_secure_installation......

五、安装后配置之迁移数据库目录

rpm这种安装方式默认将数据文件安装到/var/lib/mysql这个目录下面，通常都需要迁移到其他目录下，如迁移到/data目录下

kingtry:~#mkdir-p/data/mysql/{data,tmp}kingtry:~#mv/var/lib/mysql/*/data/mysql/datakingtry:~#touch/data/mysql/mysql.err#此文件需要手工创建，当前版本问题kingtry:~#chown-Rmysql/data/mysql

1，复制my.cnf模板文件

模板文件在/usr/share/mysql/my-default.cnf目录下，

kingtry:~#cp/usr/share/mysql/my-default.cnf/etc/my.cnf

修改相关参数，主要是socket, datadir，如下：

#Foradviceonhowtochangesettingspleasesee#http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[client]#password=your_passwordport=3306socket=/data/mysql/mysql.sockdefault-character-set=utf8#Herefollowsentriesforsomespecificprograms#TheMySQLserver[mysqld]port=3306datadir=/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

六、启动mysql服务即可

kingtry:~#servicemysqlstartdoneStartingMySQL.donekingtry:~#

检查MySQL服务是否已经启动：

kingtry:~#netstat-nat|grep3306

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

root初始密码自动生成，默认存放在/root/.mysql_secret中。修改root密码的方式有以下两种，随便哪个都行：

1、命令方式

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

2、修改库表数据方式

先登陆mysql服务器

mysql>usemysqlmysql>updateusersetpassword=password('root123')whereuser='root';mysql>commit;

八、防火墙允许3306端口

kingtry:~#vi/etc/sysconfig/SuSEfirewall2

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

FW_SERVICES_EXT_TCP="21 22 3306"

重启防火墙：

#rcSuSEfirewall2restart

九、设置远程访问

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

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

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

关于RPM安装方式说明：

显面易见的是简单；

但缺点也比较突出：不灵活，通过RPM管理的单个系统中只能安装一套MySQL