关闭iptable和selinux
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
getenforce
setenforce 0
vim /etc/sysconfig/selinux
SELINUX=disabled
reboot
201802020202
mysql8.0的yum安装方式
1.下载相关的rpm源 大概几十KB
2.yum install mysql80-community-release-el7-{version-number}.noarch.rpm
3.yum install mysql-community-server
4. systemctl start mysqld
5.systemctl status mysqld
6. grep 'temporary password' /var/log/mysqld.log 查看暂时密码
7. mysql -uroot -p暂时密码
8. use mysql
9. alter user 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
10. 这时候在本地是可以登陆了, 但是远程还不行
11.执行命令
use mysql;
select user, host from user;
update user set host = '%' where user = 'root';
这样就可以远程连接了
12. flush privileges
刷新数据库权限
13. 更改 数据库默认字符集
修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
14. 编辑保存完 重启mysql服务;
systemctl restart mysqld
15.重新登录mysql
查看数据库默认字符集
show variables like '%character%';