centos8.0中安装mysql8,远程权限配置

安装Yum Repository

wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

使用rpm来安装MySQL

rpm -ivh mysql80-community-release-el8-1.noarch.rpm

使用yum安装mysql服务

 

yum install mysql-server      (Is this ok [y/N]: y)

检查是否已经设置为开机启动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.
[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service enabled
mysqld@.service disabled

[root@localhost ~]# ps -ef|grep mysql # 查看是否启动MySQL服务
root 4311 32702 0 21:07 pts/4 00:00:00 grep --color=auto mysql
[root@localhost ~]# systemctl start mysqld.service #启动服务

 

初次启动mysql

[root@ecs-kc1-small-1-linux-20200810093149 ~]# mysql

 mysql> alter user 'root'@'localhost' identified by '123456';

 

配置远程登录

mysql> create user 'root'@'%' identified by '123456';
Query OK, 0 rows affected (0.03 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)