mysql安装

最新推荐文章于 2024-09-05 10:50:33 发布

lvxiucai

最新推荐文章于 2024-09-05 10:50:33 发布

阅读量129

点赞数

分类专栏：个人学习录 mysql

本文链接：https://blog.csdn.net/lvxiucai/article/details/104062002

版权

个人学习录同时被 2 个专栏收录

27 篇文章 0 订阅

订阅专栏

mysql

6 篇文章 0 订阅

订阅专栏

1.安装

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

2.启动

 启动命令：systemctl start  mysqld.service
 启动状态:  systemctl status mysqld.service

查看初始密码： grep "password" /var/log/mysqld.log
修改密码：ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

3.删除Yum Repository

4.允许远程链接

mysql -u root -p

mysql>use mysql;

mysql>select 'host' from user where user='root';

mysql>update user set host = '%' where user ='root';

mysql>flush privileges;