Linux入门教程:CentOS下yum安装mysql5.7,yum安装mysql
Linux入门教程:CentOS下yum安装mysql5.7,yum安装mysql
1、安装yum库
[root@dream7788 ~]# wget https://repo.mysql.com//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
显示如下:
2017-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
评论暂时关闭