CentOS7 yum方式安装MySQL5.7(简单 好用)
发布时间
阅读量：
阅读量
CentOS7 yum方式安装MySQL5.7
下载并安装MySQL官方的 Yum Repository
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm -y
yum install mysql-community-server mysql -y
代码解读MySql初始化及配置
1. 启动: systemctl start mysqld
2. 查看状态: systemctl status mysqld
3. 查看初始密码: grep "password" /var/log/mysqld.log
4. 登录: mysql -uroot -p’查到的密码’
5. 这个两个设置以后 密码很简单不会报错
set global validate_password_policy=0;
set global validate_password_length=1;
代码解读修改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
7. 允许远程客户端通过SSH协议与本地数据库进行通信：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
8. 刷新权限: flush privileges;
9. 修改默认字符集: vi /etc/my.cnf
[mysqld]
default-storage-engine=INNODB
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
代码解读重启mysql: systemctl restart mysqld
11. 开机启动: systemctl enable mysqld
12. 避免依赖yum软件包时，默认情况下每次都会自动加载mysql软件族中的社区版本配置文件mysql57-community-release-el7-8.noarch。
全部评论 (0)
还没有任何评论哟~