Mysql8.0+CentOS8.0安装

Mysql8.0+CentOS8.0安装

​ 由于MySQL版本不兼容原因，你需要安装MySQL5.7，而不是安装MySQL8，但是Centos8默认是安装MySQL8的，因为Centos8的AppStream仓库只包含MySQL8的包

环境

系统版本

---

mysql版本:

linux版本: CentOS 8

---

操作

yum安装mysql服务

yum install mysql-server

检查是否已经设置为开机启动MySQL服务

[root@localhost ~]# systemctl list-unit-files | grep mysqld
mysqld.service                                                         disabled 
mysqld@.service                                                        disabled 

设置开机启动

[root@localhost ~]# systemctl enable mysqld.service 
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.
# double check
[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service                                                         enabled  
mysqld@.service                                                        disabled 

查看是否启动MySQL服务

[root@localhost ~]# ps -ef | grep mysql
root       34198    3968  0 06:01 pts/1    00:00:00 grep --color=auto mysql
[root@localhost ~]# 

修改root用户密码

[root@localhost ~]# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
# 登录报错
[root@localhost mysql]# systemctl start mysqld.service 
[root@localhost mysql]# ps -ef | grep 'mysql'
mysql      34528       1  5 06:11 ?        00:00:00 /usr/libexec/mysqld --basedir=/usr
root       34609    3968  0 06:11 pts/1    00:00:00 grep --color=auto mysql
# 再次登录, 直接回车,没有密码
[root@localhost ~]# mysql -uroot -p
Enter password: 


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'root' ;
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

mysql> 

创建一个新用户

mysql> create user mysql identified with mysql_native_password by 'mysql';
Query OK, 0 rows affected (0.00 sec)

# 删除用户
delete from mysql.user where Host ='localhost' and User = 'username';
drop user username;
# 授权
mysql> grant all on *.* to 'mysql'@'%';
Query OK, 0 rows affected (0.01 sec)
# 刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

开通3306端口

[root@localhost man]# firewall-cmd --add-port=3306/tcp --permanent 
success

[root@localhost man]# firewall-cmd --reload 
success

测试连接