银河麒麟V10 aarch64架构 linux系统安装mysql数据库，踩坑实录
<p>国产化环境，银河麒麟V10操作系统，aarch64架构：</p><p><img src="https://img2022.cnblogs.com/blog/983493/202206/983493-20220614111434446-894403436.png"></p>
<p> </p>
<p>高版本的mysql，有支持arm架构，因此直接推荐安装高版本，这里安装的版本是8.0.28</p>
<p> </p>
<p>一、下载mysql</p>
<p>有的老铁肯定要说了，下载个软件你还能水一步！</p>
<p>那可不，下载也是一本大学问，带你少走弯路嘛：</p>
<p><img src="https://img2022.cnblogs.com/blog/983493/202206/983493-20220614112712738-802256202.png"></p>
<p> 请直接按红框选中的下载，别问我什么是红色、绿色啊，不在本次教学范畴内！</p>
<p> </p>
<p>二、清理历史环境：</p>
<p>别管以前装过没有，先干一遍，不然中间可能会遇到很多坑！</p>
<p>1.查看系统是否自带MySQL和MariaDB</p>
<div class="cnblogs_code">
<pre>rpm -qa | <span style="color: rgba(0, 0, 255, 1)">grep</span><span style="color: rgba(0, 0, 0, 1)"> mysql
rpm </span>-qa | <span style="color: rgba(0, 0, 255, 1)">grep</span><span style="color: rgba(0, 0, 0, 1)"> mariadb<br>rpm -e --nodeps mariadb-libs<br>rpm -e mariadb-server --nodeps
</span><span style="color: rgba(0, 0, 255, 1)">yum</span> -y remove mysql*
<span style="color: rgba(0, 0, 255, 1)">yum</span> -y remove mariadb*</pre>
</div>
<p>2.删除MySQL和MariaDB相关包</p>
<div class="cnblogs_code">
<pre>rpm -e filename<br>yum remove 包名</pre>
</div>
<p>3.查询所有的mysql相关文件，然后统统删除</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">find</span> / -name mysql</pre>
</div>
<p> </p>
<p>三、开始安装</p>
<p>1.解压</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">tar</span> -xvf mysql-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span>.el8.aarch64.rpm-bundle.<span style="color: rgba(0, 0, 255, 1)">tar</span></pre>
</div>
<p>2.安装必须软件（<span style="color: rgba(255, 0, 0, 1)">务必根据顺序来</span>）</p>
<div class="cnblogs_code">
<pre>rpm -ivh mysql-community-common-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.el8.aarch64.rpm
rpm </span>-ivh mysql-community-client-plugins-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.el8.aarch64.rpm
rpm </span>-ivh mysql-community-libs-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.el8.aarch64.rpm
rpm </span>-ivh mysql-community-client-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.el8.aarch64.rpm
rpm </span>-ivh mysql-community-icu-data-files-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.el8.aarch64.rpm
rpm </span>-ivh mysql-community-server-<span style="color: rgba(128, 0, 128, 1)">8.0</span>.<span style="color: rgba(128, 0, 128, 1)">28</span>-<span style="color: rgba(128, 0, 128, 1)">1</span>.el8.aarch64.rpm</pre>
</div>
<p>3.修改配置文件</p>
<div class="cnblogs_code">
<pre>vim /etc/my.cnf</pre>
</div>
<p>在末尾补一行：</p>
<div class="cnblogs_code">
<pre>lower_case_table_names=<span style="color: rgba(128, 0, 128, 1)">1</span></pre>
</div>
<p><span style="color: rgba(128, 128, 128, 1)"><em>1：数据库大小写不敏感 </em></span></p>
<p><span style="color: rgba(128, 128, 128, 1)"><em>0：数据库大小写敏感</em></span></p>
<p>4.初始化数据库</p>
<div class="cnblogs_code">
<pre>mysqld --initialize --console</pre>
</div>
<p>5.目录授权</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">chown</span> -R mysql:mysql /var/lib/mysql/</pre>
</div>
<p>6.启动mysql服务</p>
<div class="cnblogs_code">
<pre>systemctl start mysqld</pre>
</div>
<p>7.查看临时密码</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">cat</span> /var/log/mysqld.log</pre>
</div>
<p>8.用临时密码登录</p>
<div class="cnblogs_code">
<pre>mysql -u root -p</pre>
</div>
<p>有的老铁这里就要震惊了，可能mysql不是有效命令之类的提示，那就：</p>
<p>9.编辑下环境变量</p>
<div class="cnblogs_code">
<pre>vim /etc/profile</pre>
</div>
<p>末尾加上一行：</p>
<div class="cnblogs_code">
<pre>export PATH=$PATH:/usr/bin/mysq</pre>
</div>
<p>10.修改密码</p>
<div class="cnblogs_code">
<pre>alter USER <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span> IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">123456</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p>11.……此处省略500字</p>
<p> </p>
<p>踩坑基本结束，后续的你都知道了，我就不写了，吃饭去~</p>
<p>要是有不同坑，可以留言，谢谢~</p>
<p> </p><br><br>
来源：https://www.cnblogs.com/wshisboy/p/16374015.html
頁:
[1]