摘要:SuSE11sp3 64位操作系统、MySQL5.7.22 rpm安装包
5.7版本与先前版本安装有所区别,需要注意
注: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
二、检测是否安装过MySQL
我的电脑上显示以前安装过5.1.73版本的mysql,这个显示信息与实际情况相关。kingtry:~#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-community-common-5.7.22-1.sles11.x86_64.rpm
mysql-community-libs-5.7.22-1.sles11.x86_64.rpm
mysql-community-client-5.7.22-1.sles11.x86_64.rpm
mysql-community-server-5.7.22-1.sles11.x86_64.rpm
四、安装软件
注:4个rpm安装包,有依赖关系,按照以下顺序分别安装即可。kingtry:~#rpm-ivhmysql-community-common-5.7.22-1.sles11.x86_64.rpm
kingtry:~#rpm-ivhmysql-community-libs-5.7.22-1.sles11.x86_64.rpm
kingtry:~#rpm-ivhmysql-community-client-5.7.22-1.sles11.x86_64.rpm
kingtry:~#rpm-ivhmysql-community-server-5.7.22-1.sles11.x86_64.rpm
五、修改配置文件/etc/f
软件安装之后自动生成/etc/f文件,实际生成文件内容比较简单,下面是我修改之后的
#Foradviceonhowtochangesettingspleasesee
#/doc/refman/5.7/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
socket=/data/mysql/mysql.sock
character-set-server=utf8
pid-file=/data/mysql/mysql.pid
user=mysql
lower_case_table_names=1
max_connections=1000
#bind-address=127.0.0.1
#skip-name-resolve
skip-external-locking
key_buffer_size=16M
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=16M
#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
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=16M
[mysql]
no-auto-rehash
#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
#safe-updates
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
六、初始化数据库
注:5.7版本的rpm包安装之后默认不再创建数据库,mysql服务也不会自动启动。但是它还是自动增加了系统用户mysql。kingtry:~#mkdir-p/data/mysql/data#创建存放数据文件目录
kingtry:~#chown-Rmysql/data/mysql
kingtry:~#mysqld--initialize--datadir=/data/mysql/data/--user=mysql#初始化
初始化成功之后,会将root的默认密码写入文件:/data/mysql/mysql.err中,如下:Atemporarypasswordisgeneratedfor[emailprotected]:_tVUgaq%P25Q#这就是root的默认密码
七、启动mysql服务即可kingtry:~#servicemysqlstartdone
StartingMySQL.done
kingtry:~#
检查MySQL服务是否已经启动:kingtry:~#netstat-nat|grep3306
八、安装后配置之root密码修改
root初始密码自动生成,默认存放在/data/mysql/mysql.err中。修改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*.*to[emailprotected]'%'identifiedby'root123';
QueryOK,0rowsaffected(0.00sec)
mysql>flushprivileges;
QueryOK,0rowsaffected(0.00sec)
mysql>
注:生产环境最好只允许root在特定IP的机器上才能远程访问。
原文:/10759919/2150853
如果觉得《suse11 rpm 安装mysql_SuSE11安装MySQL5.7.22:RPM安装方式》对你有帮助,请点赞、收藏,并留下你的观点哦!