http://woodrow.cn/w/index.php?action=history&feed=atom&title=MySQL
MySQL - 版本历史
2026-05-15T14:09:21Z
本wiki的该页面的版本历史
MediaWiki 1.35.5
http://woodrow.cn/w/index.php?title=MySQL&diff=18&oldid=prev
Woodrow：建立内容为“== MySQL Community Server == https://downloads.mysql.com/archives/community/ == 卸载MariaDB == <syntaxhighlight lang="bash"> rpm -qa | grep -i mariadb rpm -e m…”的新页面
2022-03-30T14:15:42Z
<p>建立内容为“== MySQL Community Server == https://downloads.mysql.com/archives/community/ == 卸载MariaDB == <syntaxhighlight lang="bash"> rpm -qa | grep -i mariadb rpm -e m…”的新页面</p>
<p><b>新页面</b></p><div>== MySQL Community Server ==<br />
https://downloads.mysql.com/archives/community/<br />
<br />
== 卸载MariaDB ==<br />
<syntaxhighlight lang="bash"><br />
rpm -qa | grep -i mariadb<br />
rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps<br />
</syntaxhighlight><br />
<br />
== 创建目录、解压 ==<br />
<syntaxhighlight lang="bash"><br />
mkdir mysql<br />
tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar -C mysql<br />
</syntaxhighlight><br />
<br />
== 安装MySQL ==<br />
<syntaxhighlight lang="bash"><br />
cd mysql<br />
rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm<br />
rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm<br />
rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm<br />
rpm -ivh mysql-community-libs-compat-8.0.26-1.el7.x86_64.rpm<br />
yum install openssl-devel<br />
rpm -ivh mysql-community-devel-8.0.26-1.el7.x86_64.rpm<br />
rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm<br />
rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm<br />
</syntaxhighlight><br />
<br />
== 启动MySQL服务 ==<br />
<syntaxhighlight lang="bash"><br />
systemctl start mysqld<br />
</syntaxhighlight><br />
<br />
== 查询自动生成的root用户密码 ==<br />
<syntaxhighlight lang="bash"><br />
grep 'temporary password' /var/log/mysqld.log<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
mysql -u root -p<br />
</syntaxhighlight><br />
<br />
== 修改root用户密码 ==<br />
<pre><br />
set global validate_password.policy = 0;<br />
set global validate_password.length = 8;<br />
</pre><br />
<br />
<syntaxhighlight lang="mysql"><br />
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';<br />
</syntaxhighlight><br />
<br />
== 创建用户 ==<br />
<syntaxhighlight lang="mysql"><br />
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';<br />
</syntaxhighlight><br />
<br />
== 授予权限 ==<br />
<syntaxhighlight lang="mysql"><br />
GRANT ALL ON *.* TO 'root'@'%';<br />
</syntaxhighlight><br />
<br />
== 重新连接MySQL ==<br />
<syntaxhighlight lang="bash"><br />
mysql -u root -p<br />
</syntaxhighlight></div>
Woodrow