二进制安装mysql5.7.18

二进制安装mysql5.7.18

# 删除centos7系统自带的mariadb
yum remove mariadb-libs-5.5.60-1.el7_5.x86_64 -y
rpm -qa |grep mariadb

# 创建mysql用户
useradd -s /sbin/nologin mysql

# 解压二进制包
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
ln -s mysql-5.7.18-linux-glibc2.5-x86_64 /usr/local/mysql
mkdir -p /data/mysql/{data,sock}
chown -R mysql.mysql /data/mysql/
chown -R mysql.mysql /usr/local/mysql/

# 设置mysql环境变量
vim /etc/profile.d/mysql.sh 
	export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile

# --initialize 参数：
1. 对于密码复杂度进行定制：12位，4种  
2. 密码过期时间：180
3. 给root@localhost用户设置临时密码
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data

# 无限制，无临时密码
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data

# 配置文件的准备
cat >/etc/my.cnf <<EOF
[mysqld]
#skip-name-resolve 禁用域名解析，生产环境建议开启
character-set-server = utf8mb4
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/data/mysql/sock/mysql.sock
server_id=6
port=3306
[mysql]
default-character-set = utf8mb4
socket=/data/mysql/sock/mysql.sock
[client]
default-character-set = utf8mb4
EOF


# systemd启动方式
cat >/etc/systemd/system/mysqld.service <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF

# 启动服务
systemctl start mysqld
systemctl enable mysqld

# 管理员密码的设定
mysqladmin -S /data/mysql/sock/mysql.sock  -uroot -p password
Enter password:  无密码，直接回车
New password: 新密码
Confirm new password: 新密码

管理员忘记密码

vim /etc/my.cnf

[mysqld]
skip-grant-tables # 跳过授权表
skip-networking # 禁止远程登录

systemctl restart mysqld
mysql # 无密码登录

mysql>update mysql.user set authentication_string=PASSWORD('centos') where user = 'root'; -- 修改密码为centos  5.7.18用的是authentication_string 旧的字段是password
mysql>FLUSH PRIVILEGES; -- 重加载授权表

或者

mysql>set PASSWORD for 'root'@'localhost' = PASSWORD('centos1');  -- 修改密码为centos1  
mysql>FLUSH PRIVILEGES; -- 重加载授权表

删除my.cnf刚刚加上的两行

skip-grant-tables
skip-networking

重新启动就行了