从 mysql 官网下载并上传 mysql安装包
mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
tar -zvxf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/lcoal/mysql
groupadd mysql
useradd -r -g mysql mysql
yum search libaio
cd /usr/local/mysql/
cp ./support-files/my-default.cnf /etc/my.cnf（提示是否覆盖，输入“ y ”同意）
vim /etc/my.cnf
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
[mysqld]
#skip-name-resolve
#设置3306端口
port = 3306
socket=/var/lib/mysql/mysql.sock
# 设置mysql的安装目录
basedir=/usr/local/mysql
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
#lower_case_table_name=1
max_allowed_packet=16M
mkdir ./data
chown -R mysql:mysql ./
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
service mysqld start
vim /etc/profile
PATH = $PATH:/usr/local/mysql/bin
export PATH
source /etc/profile
use msyql
grant all privileges on *.* to root@"%" identified by "password" with grant option;
flush privileges;
my.cnf
log-bin=/usr/local/mysql/mysql-bin #开启logbin日志
利用binlog恢复
mysqlbinlog --start-position="298" --stop-position="410" mysql-bin.000001 | mysql -u root -p test test是数据库名称
Xiaoqian03051993@
运维QQ交流群：171586999
网友评论