linux 软件下载源
http://ftp.ntu.edu.tw/http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.7/
一、MYSQL 二进制包安装方式
1、解压MySQL-5.7.19-Linux-glibc2.5-x86_64.tar.gz,并拷贝到/usr/local/mysql目录下tar -zxvf mysql-5.7.19-linux-glibc2.5-x86_64.tar.gzsudo cp -r mysql-5.7.19-linux-glibc2.5-x86_64 /usr/local/mysql2、添加mysql 用户groupadd mysqluseradd -r -g mysql mysql3、切换到/usr/local/mysql 改变目录拥有者为 mysqlchown -R mysql.mysql /usr/local/mysql4、安装mysqlbin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data--basedir mysql基础目录--datadir mysql数据存放目录这里会生成mysql第一次登录用的 临时密码 需要保存下来。No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 777c9543-2e4a-11e8-b34d-00163e024684.如:A temporary password is generated for root@localhost: P/6B56dtIsr%P/6B56dtIsr% 就是临时密码root@localhost: x30o;:oq&w:L5、执行以下命令创建RSA private keybin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data6、修改当前目录拥有者为 root 用户,修改data 目录拥有者为 mysqlchown -R root:root /usr/local/mysqlchown -R mysql:mysql /usr/local/mysql/data7、配置my.cnf和开启启动
cd support-files cp my-default.cnf /etc/my.cnf //这一步的my-default.cnf 在mysql 5.7 版本中没有发现,需要手动建立cp mysql.server /etc/init.d/mysqlvim /etc/init.d/mysql //修改basedir = '' 修改datadir = '',修改成对应路径8、修改my.cnfvim /etc/my.cnf加入如下配置内容[mysqld]character-set-server=utf8datadir=/home/mysql/mysqldatabasedir=/usr/local/mysqlsocket=/var/lib/mysql/mysql.sock配置自动开机启动
chkconfig --level 35 mysqld on9、启动mysql
service mysql start这里如果没有 步骤8中的 socket 路径的话,mysql会启动失败。需要手动建立/var/lib/mysql/ 目录10、配置mysql 环境变量,让其在任何目录命令行都能启动
vim /etc/profile加入 export PATH=/usr/local/mysql/bin:$PATH更新配置 source /etc/profile完毕!
Mysql 主从复制配置
先建立从库登录主库的唯一帐号CREATE USER 'repl'@'192.168.0.1' IDENTIFIED BY 'repl123';GRANT FILE ON *.* TO 'repl'@'192.168.0.1' IDENTIFIED BY 'repl123';GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.0.1' IDENTIFIED BY 'repl123'; //配置从库所用帐号的权限Master my.cnf配置[mysqld]log-bin=mysql-bin server-id=200 //主服务器 id 必设innodb_flush_log_at_trx_commit=1sync_binlog=1binlog-do-db=57yn_db