Centos6.5使用rpm安装mysql及双主互备模式。.doc

《Centos6.5使用rpm安装mysql及双主互备模式。.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Centos使用RPM命令安装MySQL数据1检查MySQL及相关RPM包如果有安装，则移:[root@localhost~]#rpm-qa

2、grep-imysqlmysql-libs-5.1.66-2.el6_3.x86_64[root@localhost~]#rpm–e–nodepsmysql-libs-5.1.66-2.el6_3.x86_642安装mysql[root@localhostrpm]#rpm-ivhMySQL-server-5.6.15-1.el6.x86_64.rpm[root@localhostrpm]#rpm-ivhMySQL-devel-5.6.1

3、5-1.el6.x86_64.rpm[root@localhostrpm]#rpm-ivhMySQL-client-5.6.15-1.el6.x86_64.rpm#修改配置文件位置[root@localhostrpm]#cp/usr/share/mysql/my-default.cnf/etc/my.cnf初使化MYSQL及配置密码[root@localhostrpm]#/usr/bin/mysql_install_db[root@localhostrpm]#servicemysqlstart[root@localhostrpm]#cat/root/.mysql_secret

4、#查看root账号密码#TherandompasswordsetfortherootuseratWedDec1123:32:502013(localtime):qKTaFZnl[root@localhost~]#mysql-uroot–pqKTaFZnlmysql>SETPASSWORD=PASSWORD('123456');#设置密码为123456mysql>exit[root@localhost~]#mysql-uroot-p1234561允许远程登录mysql>usemysql;Readingtableinformationforcompletionoftableand

5、columnnamesYoucanturnoffthisfeaturetogetaquickerstartupwith-ADatabasechangedmysql>selecthost,user,passwordfromuser;1.+-----------------------+------+-------------------------------------------+  2.

6、 host                  

7、 user 

8、 password                                  

9、  3.+-------------

10、----------+------+-------------------------------------------+  4.

11、 localhost             

12、 root 

13、 *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B 

14、  5.

15、 localhost.localdomain 

16、 root 

17、 *A4B8196FF869F64E0119B231785E5946EDBA5E26 

18、  6.

19、 127.0.0.1             

20、 root 

21、 *A4B8196FF869F64E0119B231785E594

22、6EDBA5E26 

23、  7.

24、 ::1                   

25、 root 

26、 *A4B8196FF869F64E0119B231785E5946EDBA5E26 

27、  8.+-----------------------+------+-------------------------------------------+ mysql>updateusersetpassword=password('root')whereuser='root';QueryOK,3rowsaffected(0.01sec)Rowsmatched:4Changed:3Warnin

28、gs:0mysql>updateusersethost='%'whereuser='root'andhost='localhost';QueryOK,1rowaffected(0.04sec)Rowsmatched:1Changed:1Warnings:0mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)2设置开机自启动[root@localhost~]#chkconfigmysqlon[root@localhost~]#chkconfig--lis