摘要:SuSE11sp3 64位操作系统、MySQL5.6.40rpm安装包
注:kingtry是我的主机名
一、环境准备
操作系统:SuSE版本11sp3,64位kingtry:~#uname-a
Linuxkingtry3.0.76-0.11-default#1SMPFriJun1408:21:43UTC(ccab990)x86_64x86_64x86_64GNU/Linux
kingtry:~#cat/etc/SuSE-release
SUSELinuxEnterpriseServer11(x86_64)
VERSION=11
PATCHLEVEL=3
二、检测是否安装过MySQLkingtry:~#rpm-qa|grep-imysql
libmysqlclient_r15-5.0.96-0.6.1
libqt4-sql-mysql-4.6.3-5.25.4
MySQL-client-community-5.1.73-1.sles11
MySQL-server-community-5.1.73-1.sles11
注意输出的MySQL-*,表示已经安装过。lib开头的可以忽略。
输入以下命令删除:kingtry:~#rpm-eMySQL-client-community-5.1.73-1.sles11
kingtry:~#rpm-eMySQL-server-community-5.1.73-1.sles11
三、软件准备MySQL-server-5.6.40-1.sles11.x86_64.rpm
MySQL-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,keyID5072e1f5
Preparing...###########################################[100%]
1:MySQL-server###########################################[50%]
warning:usermysqldoesnotexist-usingroot
warning:groupmysqldoesnotexist-usingroot
warning:usermysqldoesnotexist-usingroot
warning:groupmysqldoesnotexist-usingroot
insserv:Servicenetworkismissedintherunlevels4touseservicemysql
mysql0: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/f
/etc/f.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/data
kingtry:~#touch/data/mysql/mysql.err#此文件需要手工创建,当前版本问题
kingtry:~#chown-Rmysql/data/mysql
1,复制f模板文件
模板文件在/usr/share/mysql/my-f目录下,kingtry:~#cp/usr/share/mysql/my-f/etc/f
修改相关参数,主要是socket, datadir,如下:
#Foradviceonhowtochangesettingspleasesee
#/doc/refman/5.6/en/server-configuration-defaults.html
[client]
#password=your_password
port=3306
socket=/data/mysql/mysql.sock
default-character-set=utf8
#Herefollowsentriesforsomespecificprograms
#TheMySQLserver
[mysqld]
port=3306
datadir=/data/mysql/data
tmpdir=/data/mysql/tmp
socket=/data/mysql/mysql.sock
character-set-server=utf8
collation-server=utf8_general_ci
pid-file=/data/mysql/mysql.pid
user=mysql
explicit_defaults_for_timestamp
lower_case_table_names=1
max_connections=1000
back_log=1024
open_files_limit=10240
table_open_cache=5120
#bind-address=127.0.0.1
#skip-name-resolve
skip-external-locking
local-infile=1
key_buffer_size=32M
max_allowed_packet=1M
table_open_cache=64
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement,
#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.
#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.
#NotethatusingthisoptionwithoutenablingnamedpipesonWindows
#(viathe"enable-named-pipe"option)willrendermysqlduseless!
#
#skip-networking
#ReplicationMasterServer(default)
#binaryloggingisrequiredforreplication
log-bin=/data/mysql/mysql-bin
#binaryloggingformat-mixedrecommended
binlog_format=mixed
#requireduniqueidbetween1and2^32-1
#defaultsto1ifmaster-hostisnotset
#butwillnotfunctionasamasterifomitted
server-id=1
#ReplicationSlave(commentoutmastersectiontousethis)
#
#Toconfigurethishostasareplicationslave,youcanchoosebetween
#twomethods:
#
#1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-
#thesyntaxis:
#
#CHANGEMASTERTOMASTER_HOST=,MASTER_PORT=,
#MASTER_USER=,MASTER_PASSWORD=;
#
#whereyoureplace,,byquotedstringsand
#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=
#
#Theusernametheslavewilluseforauthenticationwhenconnecting
#tothemaster-required
#master-user=
#
#Thepasswordtheslavewillauthenticatewithwhenconnectingto
#themaster-required
#master-password=
#
#Theportthemasterislisteningon.
#optional-defaultsto3306
#master-port=
#
#binarylogging-notrequiredforslaves,butrecommended
#log-bin=mysql-bin
#UncommentthefollowingifyouareusingInnoDBtables
#innodb_data_home_dir=/var/lib/mysql
innodb_data_file_path=ibdata1:10M:autoextend
#innodb_log_group_home_dir=/var/lib/mysql
#Youcanset.._buffer_pool_sizeupto50-80%
#ofRAMbutbewareofsettingmemoryusagetoohigh
innodb_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=50
innodb_buffer_pool_instances=2
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_purge_threads=1
slow_query_log=1
long_query_time=10
log-queries-not-using-indexes
log-error=/data/mysql/mysql.err
expire-logs-days=10
[mysqldump]
quick
max_allowed_packet=512M
net_buffer_length=16384
[mysql]
auto-rehash
#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
#safe-updates
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
六、启动mysql服务即可kingtry:~#servicemysqlstartdone
StartingMySQL.done
kingtry:~#
检查MySQL服务是否已经启动:kingtry:~#netstat-nat|grep3306
七、安装后配置之root密码修改
root初始密码自动生成,默认存放在/root/.mysql_secret中。修改root密码的方式有以下两种,随便哪个都行:
1、命令方式kingtry:~#mysqladmin-uroot-ppassword'root123'
Enterpassword:
2、修改库表数据方式
先登陆mysql服务器mysql>usemysql
mysql>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
如果觉得《suse 安装mysql5.6_SuSE11安装MySQL5.6.40:RPM安装方式》对你有帮助,请点赞、收藏,并留下你的观点哦!