双MYSQL安装配置.docxVIP

双MYSQL安装配置安装编译前提:Yum install gccYum install gcc-c++第一个MYSQL安装编译1.带上参数 ./configure --prefix=/usr/local/mysql --with-named-curses-libs=/usr/lib/libncurses.so.5 可能需要的参数 Make Make install支持GBK编译./configure --prefix=/usr/local/mysql --with-named-curses-libs=/lib/libncurses.so.5 --with-charset=gbk --with-extra-charsets=gb2312将标准配置文件导入cp ./support-files/my-medium.cnf /etc/my.cnf?建立mysql 数据库目录Mkdir /usr/local/mysql/var初始化MYSQL/usr/local/mysql/bin/mysql_install_db启动mysql/usr/local/mysql/bin/mysqld_safe --user=root 停止mysql/usr/local/mysql/bin/mysqladmin shutdown登陆./usr/local/mysql/bin/mysql mysql GRANT ALL PRIVILEGES ON * TO root@% IDENTIFIED BY rootpwd;添加MYSQL用户权限.MysqlFlush privileges更新权限试登陆MYSQL2第二个MYSQL安装./configure --prefix=/usr/local/mysql5 --with-unix-socket-path=/tmp/mysql5.sock --with-tcp-port=3307?make make install将标准配置文件导入 cp ./support-files/my-medium.cnf /etc/my5.cnf修改my5.cnfVi /etc/my5.cnf 将以下的内容进行修改.PORT改成3307 SOCKET改成/tmp/mysql5.sock[client]port = 3307socket = /tmp/mysql5.sock [mysqld]port = 3307socket = /tmp/mysql5.sock建立mysql 数据库目录Mkdir /usr/local/mysql5/var初始化MYSQL/usr/local/mysql5/bin/mysql_install_db –defaults-file=/etc/my5.cnf –datadir=/usr/local/mysql5/var启动/usr/local/mysql5/bin/mysqld_safe --defaults-file=/etc/my5.cnf --datadir=/usr/local/mysql5/var --user=root 停止?/usr/local/mysql5/bin/mysqladmin --defaults-file=/etc/my5.cnf shutdown登陆./usr/local/mysql5/bin/mysql --defaults-file=/etc/my5.cnfmysql GRANT ALL PRIVILEGES ON * TO root@% IDENTIFIED BY rootpwd;添加MYSQL用户权限.MysqlFlush privileges更新权限试登陆MYSQL修改MYSQL配置文件,支持UTF8在my.cnf和my5.cnf中加入注意两个选项.添加错的话,将不会生效[mysql]default-character-set=utf8[mysqld]default-character-set=utf8双MYSQL主同步配一定要注意看完配置文件…默认配置中SERVER-ID=1在MYSQL2中需要修改一．数据库同步配置1.环境假设：IP：192.168.1.52 2.在serv上修改2个MYSQL的配置文件 my.cnf 和 my5.cnf My.cnf修改如下： [mysqld]#端口port=3306#log-bin项是让Master服务器记录二进制日志这个是必须的log-bin=mysql-bin#relay_log配置中继日志relay-log=relay-binrelay-log-index=relay-bin-index#server-id=master_id 其中master_