CentOS7安装mysql

最新推荐文章于 2024-07-13 10:38:18 发布

keli_Jun

最新推荐文章于 2024-07-13 10:38:18 发布

阅读量109

点赞数

分类专栏：运维文章标签： mysql 运维 linux centos 数据库

本文链接：https://blog.csdn.net/zero_uou/article/details/106839775

版权

3 篇文章 0 订阅

订阅专栏

1.下载mysql的repo源

如果没有 wget 先

yum install -y wget

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

2.安装mysql-community-release-el7-5.noarch.rpm包

非 root 用户加上 sudo

rpm -ivh mysql-community-release-el7-5.noarch.rpm

3.安装mysql服务

yum install -y mysql-server

4.启动mysql服务

service mysqld start

5.设置开机启动mysql服务

chkconfig mysqld on

6.空密码进入mysql

mysql -u root -p -h 127.0.0.1

7.修改 mysql 密码

mysql> UPDATE mysql.user SET password=PASSWORD("123456") WHERE user="root";

8.设置登录权限，远程服务器可访问

mysql> delete from user;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> flush privileges;

9.连接MySQL数据库

关注