Mysql5.7 安装手册
mysql 5.7 下载安装
# 下载 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
初始
/usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1 --defaults-file=/etc/mysql/my.cnf
启动参数配置
[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
启动或重启
# 启动
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 中打印出来。
# 用初始密码登录
mysql -uroot -p
# 修改root 密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
# 修改root 密码
SET PASSWORD = PASSWORD('root-123.');
用户创建和授权
# 创建用户
# 指定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