linux tao环境安装_Linux环境下一键安装Mysql 5.7

最新推荐文章于 2023-01-05 15:19:14 发布

WebGuru

最新推荐文章于 2023-01-05 15:19:14 发布

阅读量73

点赞数

文章标签： linux tao环境安装

本文链接：https://blog.csdn.net/weixin_36402765/article/details/112479078

版权

本文详细介绍了在Linux系统中如何安装MySQL5.7，包括使用YumRepository下载安装、启动与验证MySQL服务、设置root用户密码、开启远程访问权限等步骤，并列举了常用的服务管理命令。

摘要由CSDN通过智能技术生成

MySQL 作为一款关系型数据库管理系统，本身是开源的一款产品，在互联网架构下的项目中应用非常广泛。对于想自学web开发的朋友，MySQL绝对是独一无二的选择。本文主要是分享一下Linux环境下最简单的MySQL安装方式，希望能帮助需要的小伙伴。本文以mysql5.7版本为例

安装

下载并安装MySQL官方的 Yum Repository

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

使用上面的命令就直接下载了安装用的Yum Repository。

安装mysql-community

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

安装mysql-server

yum -y install mysql-community-server

直到complete! 即安装完成，就可以登陆啦。

验证安装

mysql --version

启动

启动

sudo systemctl start mysqld.service

查看运行状态

sudo systemctl status mysqld.service

登陆

查看临时密码

MySql服务器初始化的时候会创建 'root@localhost'是一个超级用户账号。设置超级用户的密码并将其存储在错误日志文件中。要显示它，请使用以下命令：

sudo grep 'temporary password' /var/log/mysqld.log

2. 密码登陆

mysql -uroot -p

重置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456xxxx';

这里有个问题，新密码设置的时候如果设置的过于简单会报错：

原因是因为MySQL有密码设置的规范，具体是与validate_password_policy的值有关。

远程登陆

一般服务器默认是不开放3306端口，启用远程访问(MySQL默认禁止远程访问)。

1. 授权给所有ip

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

2. 授权给某ip

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'your ip' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;mysql>FLUSH PRIVILEGES;

常用指令

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;"],[20,"\n","24:\"8cS8\"|36:177"],[20,"mysql>FLUSH PRIVILEGES;"],[20,"\n","24:\"Ehgv\"|36:177"],[20,"* 授权给某ip"],[20,"\n","24:\"mg59\"|36:177"],[20,"mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'your ip' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;"],[20,"\n","24:\"KBaF\"|36:177"],[20,"mysql>FLUSH PRIVILEGES;"],[20,"\n","24:\"9uw1\"|36:177"],[20,{"gallery":"https://uploader.shimo.im/f/y6E7QceOBE5jZ5lI.png!thumbnail"},"29:0|30:0|3:\"1080\"|4:\"auto\"|crop:\"\"|frame:\"none\"|ori-height:\"500\"|ori-width:\"1080\""],[20,"\n","24:\"xm9x\"|linespacing:\"150\""],[20,"常用指令"],[20,"\n","24:\"l58v\"|32:2|linespacing:\"150\""],[20,"启动mysql服务：systemctl start mysqld.service"],[20,"\n","24:\"AyNL\"|36:177|7:3|linespacing:\"150\""],[20,"停止mysql服务：systemctl stop mysqld.service"],[20,"\n","24:\"UTZz\"|36:177|7:3|linespacing:\"150\""],[20,"重启mysql服务：systemctl restart mysqld.service"],[20,"\n","24:\"4Syy\"|36:177|7:3|linespacing:\"150\""],[20,"查看mysql服务当前状态：systemctl status mysqld.service"],[20,"\n","24:\"ipQ1\"|36:177|7:3|linespacing:\"150\""],[20,"设置mysql服务开机自启动：systemctl enable mysqld.service"],[20,"\n","24:\"3t1e\"|36:177|7:3|linespacing:\"150\""],[20,"停止mysql服务开机自启动：systemctl disable mysqld.service"],[20,"\n","24:\"M1uO\"|36:177|7:3|linespacing:\"150\""],[20,"查看所有已启动的服务：systemctl list-units --type=service"],[20,"\n","24:\"36Pp\"|36:177|7:3|linespacing:\"150\""],[20,"\n","24:\"urLIad\""],[20,"全文完，安装过程遇到问题可以留言。"]]">

启动mysql服务：systemctl start mysqld.service停止mysql服务：systemctl stop mysqld.service重启mysql服务：systemctl restart mysqld.service查看mysql服务当前状态：systemctl status mysqld.service设置mysql服务开机自启动：systemctl enable mysqld.service停止mysql服务开机自启动：systemctl disable mysqld.service查看所有已启动的服务：systemctl list-units --type=service

全文完，安装过程遇到问题可以留言。