centos7安装MySQL

来源

仅作记录

# 1.下载并安装MySQL官方的 Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

# 2.yum安装
yum -y install mysql57-community-release-el7-10.noarch.rpm

# 3.安装MySQL服务器
yum -y install mysql-community-server

# 4.启动MySQL
systemctl start  mysqld.service

# 5.查看MySQL运行状态
systemctl status mysqld.service

# 6.找出默认密码, 密码是localhost：后面部分
grep "password" /var/log/mysqld.log

# 7.进入MySQL
mysql -uroot -p

# 8.修改默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '自己的密码';

# 9.开启mysql的远程访问
grant all privileges on *.* to 'root'@'ip地址，开启所有用%' identified by 'password' with grant option;

# 10.在MySQL中查看编码， server characterset如果不是utf8 修改
status

# 11.退出MySQL并修改配置文件
exit
vi /etc/my.cnf1

# 12.在第一行新增
[client]
default-character-set=utf8 # 如果用utf8mb4，把utf替换即可

# 13.在最后新增
character-set-server=utf8
collation-server=utf8_general_ci

# 13.1忽略表名大小写
lower_case_table_names=1

# 14.如果想开启sql-bin则继续在后面新增
log-bin=mysql-bin
server-id=1

# 15.保存并重启MySQL
service mysqld restart

# 16.进入MySQL查看status观察编码是否改变
# 17.查看是否开启log_bin, 如果log_bin value 是on则已经开启
show variables like ‘log_%’;

# 18.开放阿里3306端口