centos6.7安装mysql5.5.48的方法
本文实例讲述了centos6.7安装mysql5.5.48的方法。分享给大家供大家参考,具体如下:
RPM安装mysql5.5.48
下载对应的MySQL安装包rpm文件,可以去MySQL官方网站找到对应版本,一般需要下载3个文件
MySQL-server
MySQL-client
MySQL-devel
wgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.48-1.el6.x86_64.rpm wgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.48-1.el6.x86_64.rpm wgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.48-1.el6.x86_64.rpm rpm-ivhMySQL-server-5.5.48-1.el6.x86_64.rpm rpm-ivhMySQL-client-5.5.48-1.el6.x86_64.rpm rpm-ivhMySQL-devel-5.5.48-1.el6.x86_64.rpm
安装服务端出错:
[root@localhost~]#rpm-ivhMySQL-server-5.5.48-1.el6.x86_64.rpm warning:MySQL-server-5.5.48-1.el6.x86_64.rpm:HeaderV3DSA/SHA1Signature,keyID5072e1f5:NOKEY Preparing... ###########################################[100%] file/usr/share/mysql/charsets/Index.xmlfrominstallofMySQL-server-5.5.48-1.el6.x86_64conflictswithfilefrompackagemysql-libs-5.1.73-5.el6_6.x86_64 file/usr/share/mysql/charsets/armscii8.xmlfrominstallofMySQL-server-5.5.48-1.el6.x86_64conflictswithfilefrompackagemysql-libs-5.1.73-5.el6_6.x86_64 file/usr/share/mysql/charsets/ascii.xmlfrominstallofMySQL-server-5.5.48-1.el6.x86_64conflictswithfilefrompackagemysql-libs-5.1.73-5.el6_6.x86_64 file/usr/share/mysql/charsets/cp1250.xmlfrominstallofMySQL-server-5.5.48-1.el6.x86_64conflictswithfilefrompackagemysql-libs-5.1.73-5.el6_6.x86_64 file/usr/share/mysql/charsets/cp1256.xmlfrominstallofMySQL-server-5.5.48-1.el6.x86_64conflictswithfilefrompackagemysql-libs-5.1.73-5.el6_6.x86_64
错误原因:包冲突了
centos6.7basicserver版本默认安装了mysql5.1,所以先卸载mysql5.1
yum-yremovemysql-libs-5.1*
再重新安装即可
rpm-ivhMySQL-server-5.5.48-1.el6.x86_64.rpm
启动mysql
[root@localhost~]#servicemysqlstart StartingMySQLSUCCESS!
CentOS下安装官方RPM包的MySQL后找不到my.cnf解决办法
复制/usr/share/mysql/my-medium.cnf文件到/etc目录,
cp/usr/share/mysql/my-medium.cnf/etc/my.cnf
局域网内mysql连接慢的解决办法
ping都很快,mysql连接慢,
原因是由于mysql对连接的客户端进行DNS反向解析。
有2种解决办法:
1.把client的ip写在mysql服务器的/etc/hosts文件里,随便给个名字就可以了。
2.在my.cnf中加入–skip-name-resolve。
希望本文所述对大家centos服务器配置有所帮助。