Mysql5.7 安装手册

Mysql Mysql, 用户权限 评论

mysql 5.7 下载安装

1
2
3
4
5
6
7
8
9
10
11
12
13
# 下载 mysql Yum Repository rpm 文件
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

# 安装  mysql Yum Repository rmp
yum install mysql57-community-release-el7-10.noarch.rpm

# 查找安装包名称
yum search mysql

# 安装mysql
# Error: Unable to find a match: mysql-community-server
# 先执行 yum module disable mysql，然后再执行yum -y install mysql-community-server
yum install mysql-community-server

初始

1
/usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1 --defaults-file=/etc/mysql/my.cnf

启动参数配置

1
2
3
4
5
6
7
8
9
10
11
12
13
[client]
port	= 16300
socket	= /var/lib/mysql/mysql.sock

[mysqld]
# 关闭 密码强度校验 
validate_password = off
port	= 16300
skip-extenal-locking
socket	= /var/lib/mysql/mysql.sock
key_buffer_size	=	16M
max_allowed_packet	=4M
log-error=/var/log/mysqld.log

启动或重启

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# 启动
service mysqld start
# 重启
service mysqld restart

systemctl start  mysqld.service

systemctl status  mysqld.service

# 调用 mysql.server，默认使用/etc/my.cnf配置文，调用 mysqld_safe

mysql.server start
mysql.server stop

# mysqld_safe，调用mysqld_safe的时候要把-datadir、-pid-file，调用mysqld

mysqld_safe --defaults-file=file_name --port=port_num

# mysqld

mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

重置root账户密码

root 初始密码 会在 错误日志或者console 中打印出来。

1
2
3
4
5
6
7
8
# 用初始密码登录
mysql -uroot -p

# 修改root 密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

# 修改root 密码
SET PASSWORD = PASSWORD('root-123.');

用户创建和授权

1
2
3
4
5
6
7
8
9
# 创建用户
# 指定host 时，localhost 和 127.0.0.1 不太一样
create user 'username'@'host' identified by 'password'

# 登录权限
grant usage on *.* to 'username'@'host';

# 授权
grant select,delete,update,create,drop,references on <db>.<table> to 'username'@'host';

参考文档

[mysql 安装说明] https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-installing
[mysql 配置说明] https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[主从配置] https://dev.mysql.com/doc/refman/5.7/en/replication.html

资源下载

[mysql 5.7 Yum Repository rpm] http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

鲁大师Developer & Designer

个人简介。