1500字范文,内容丰富有趣,写作好帮手!
1500字范文 > centos下yum安装mysql5.7_CentOS下yum安装mysql5.7

centos下yum安装mysql5.7_CentOS下yum安装mysql5.7

时间:2019-06-15 15:29:39

相关推荐

centos下yum安装mysql5.7_CentOS下yum安装mysql5.7

文章目录

[隐藏]

1、安装yum库

2、安装mysql

3、启动mysql

4、获取初次安装时root的密码

5、修改root密码

6、允许root远程登录

1、安装yum库

[root@dream7788 ~]# wget //mysql57-community-release-el7-9.noarch.rpm [root@dream7788 ~]# yum localinstall mysql57-community-release-el7-9.noarch.rpm [root@dream7788 ~]# yum repolist enabled | grep "mysql.*-community.*"

2、安装mysql

[root@dream7788 ~]# yum install mysql-community-server

3、启动mysql

[root@dream7788 ~]# systemctl restart mysqld.service

4、获取初次安装时root的密码

[root@dream7788 ~]# grep 'temporary password' /var/log/mysqld.log

显示如下:

-01-08T19:41:01.080513Z 1 [Note] A temporary password is generated for root@localhost: js!iUor1wOTT

5、修改root密码

[root@dream7788 ~]# mysql -u root -p

修改密码:

mysql> set global validate_password_policy=0; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'dream7788'; mysql> FLUSH PRIVILEGES;

6、允许root远程登录

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'dream7788' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; mysql> quit

原文出处:君子如兰 -> /42.html

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。