目录

Mysql 8.0 配置笔记

安装YUM Repo

下载repo rpm:https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
然后

1
sudo yum install mysql-community-server

启动Mysql

1
sudo systemctl enable --now mysqld

BugFix

遇到了权限问题
https://cdn.nlark.com/yuque/0/2021/png/368236/1626747645603-18ff1c4c-ba78-4e5b-ac6e-194e9057e7fc.png#clientId=u7a66219c-7aff-4&from=paste&height=330&id=ud7deea47&margin=%5Bobject%20Object%5D&name=image.png&originHeight=330&originWidth=1466&originalType=binary&ratio=1&size=78427&status=done&style=none&taskId=u2cf8d780-6d62-47b5-9f40-e4ee3e7f6a9&width=1466

1
2
3
sudo touch /var/log/mysqld.log
sudo chown mysql:mysql /var/log/mysqld.log
sudo systemctl enable --now mysqld

然后遇到了另一个错误
https://cdn.nlark.com/yuque/0/2021/png/368236/1626748106362-60974a16-e4aa-4eaa-93ef-55c2cfc27bcd.png#clientId=u7a66219c-7aff-4&from=paste&height=44&id=ucc2b9f59&margin=%5Bobject%20Object%5D&name=image.png&originHeight=44&originWidth=687&originalType=binary&ratio=1&size=8969&status=done&style=none&taskId=ufc0dce95-a15c-4d83-a3d6-dcce917cbfd&width=687

1
2
3
sudo mkdir -p /var/lib/mysql
sudo chown -R mysql:mysql /var/lib/mysql
sudo systemctl enable --now mysqld

成功启动
https://cdn.nlark.com/yuque/0/2021/png/368236/1626748204254-c5210ccb-7027-4c7e-b8d3-43ef9468cb9a.png#clientId=u7a66219c-7aff-4&from=paste&height=201&id=u83de324f&margin=%5Bobject%20Object%5D&name=image.png&originHeight=201&originWidth=747&originalType=binary&ratio=1&size=27864&status=done&style=none&taskId=u5d413c70-7a71-4bcf-bb55-342e9f03372&width=747

初始化配置

先查看临时密码

1
sudo grep 'temporary password' /var/log/mysqld.log

然后进行初始化安全配置

1
mysql_secure_installation

会让我们修改初始密码,注意有最低密码强度要求
https://cdn.nlark.com/yuque/0/2021/png/368236/1626748544462-4a3c0bd5-085c-4c5b-bb0b-45ed79ff2695.png#clientId=u7a66219c-7aff-4&from=paste&height=834&id=uf974bd42&margin=%5Bobject%20Object%5D&name=image.png&originHeight=834&originWidth=778&originalType=binary&ratio=1&size=76108&status=done&style=none&taskId=udc6a0acb-1422-4eda-87b7-110548f4c19&width=778

1
2
3
4
mysql -u root -p
CREATE USER 'pig'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'pig'@'%';
flush privileges;