华为openEuler安装MYSQL数据库
<h1 style="text-align: center">openEuler离线部署MYSQL常见问题</h1><h1 id="4W3W-1747820023494">一、MYSQL软件包安装完成后，无法启动服务，报错：</h1>
<div><span style="color: rgba(255, 0, 0, 1)">""Job for mysqld.service failed because the control process exited with error code.""</span></div>
<div><span style="color: rgba(255, 0, 0, 1)">""See "systemctl status mysqld.service" and "journalctl -xeu mysqld.service" for details.""</span></div>
<h3 id="0ViW-1747820023500">(1)权限问题：/var/lib/mysql目录权限不够</h3>
<div>处理办法：修改权限并启动MYSQL</div>
<div data-theme="coy" data-language="bash">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> <span style="color: rgba(255, 0, 0, 1)">[</span><span style="color: rgba(255, 0, 0, 1)">root@node2 ~</span><span style="color: rgba(255, 0, 0, 1)">]</span># setenforce <span style="color: rgba(128, 0, 0, 1); font-weight: bold">0</span>
<span style="color: rgba(0, 128, 128, 1)">2</span> <span style="color: rgba(255, 0, 0, 1)">[</span><span style="color: rgba(255, 0, 0, 1)">root@node2 ~</span><span style="color: rgba(255, 0, 0, 1)">]</span># chown <span style="color: rgba(128, 128, 128, 1)">-</span>R mysql:mysql <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(255, 0, 255, 1)">var</span><span style="color: rgba(128, 128, 128, 1)">/</span>lib<span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 0, 1)">mysql
</span><span style="color: rgba(0, 128, 128, 1)">3</span> <span style="color: rgba(255, 0, 0, 1)">[</span><span style="color: rgba(255, 0, 0, 1)">root@node2 ~</span><span style="color: rgba(255, 0, 0, 1)">]</span># chmod <span style="color: rgba(128, 128, 128, 1)">-</span>R <span style="color: rgba(128, 0, 0, 1); font-weight: bold">777</span> <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(255, 0, 255, 1)">var</span><span style="color: rgba(128, 128, 128, 1)">/</span>lib<span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 0, 1)">mysql
</span><span style="color: rgba(0, 128, 128, 1)">4</span> <span style="color: rgba(255, 0, 0, 1)">[</span><span style="color: rgba(255, 0, 0, 1)">root@node2 ~</span><span style="color: rgba(255, 0, 0, 1)">]</span># systemctl start mysqld.service</pre>
</div>
<p> </p>
</div>
<h3 id="uYuZ-1747820023513">（2）端口被占用，mysql端口经常使用3306端口，需要监测该端口是否被占用</h3>
<div data-theme="default" data-language="shell">命令：ps -ef |grep mysql</div>
<div>将占用3306端口的进程kill就可以正常运行。</div>
<h3 id="ccEQ-1747820023520">（3）缺少openssl1.1.1依赖（openEuler默认是3.0x版本的openssl依赖库）</h3>
<div><1>将在互联网下载的openssl1.1.1u安装包上传安装路径，解压安装。</div>
<div><2>配置编译源码包：</div>
<div data-theme="default" data-language="bash">./config --prefix=/usr/local/openssl-1.1.1t make make install</div>
<div data-theme="default" data-language="bash">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> .<span style="color: rgba(128, 128, 128, 1)">/</span>config <span style="color: rgba(0, 128, 128, 1)">--</span><span style="color: rgba(0, 128, 128, 1)">prefix=/usr/local/openssl-1.1.1t</span>
<span style="color: rgba(0, 128, 128, 1)">2</span> <span style="color: rgba(0, 0, 0, 1)">make
</span><span style="color: rgba(0, 128, 128, 1)">3</span> make install</pre>
</div>
</div>
<div><3>创建软链接</div>
<div data-theme="default" data-language="bash">
<div class="cnblogs_code">
<pre>ln <span style="color: rgba(128, 128, 128, 1)">-</span>s <span style="color: rgba(128, 128, 128, 1)">/</span>usr<span style="color: rgba(128, 128, 128, 1)">/</span>local<span style="color: rgba(128, 128, 128, 1)">/</span>openssl<span style="color: rgba(128, 128, 128, 1)">-</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span>.1t<span style="color: rgba(128, 128, 128, 1)">/</span>lib64<span style="color: rgba(128, 128, 128, 1)">/</span>libssl.so.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span> <span style="color: rgba(128, 128, 128, 1)">/</span>usr<span style="color: rgba(128, 128, 128, 1)">/</span>lib64<span style="color: rgba(128, 128, 128, 1)">/</span>libssl.so.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span><span style="color: rgba(0, 0, 0, 1)">
ln </span><span style="color: rgba(128, 128, 128, 1)">-</span>s <span style="color: rgba(128, 128, 128, 1)">/</span>usr<span style="color: rgba(128, 128, 128, 1)">/</span>local<span style="color: rgba(128, 128, 128, 1)">/</span>openssl<span style="color: rgba(128, 128, 128, 1)">-</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span>.1t<span style="color: rgba(128, 128, 128, 1)">/</span>lib64<span style="color: rgba(128, 128, 128, 1)">/</span>libcrypto.so.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span> <span style="color: rgba(128, 128, 128, 1)">/</span>usr<span style="color: rgba(128, 128, 128, 1)">/</span>lib64<span style="color: rgba(128, 128, 128, 1)">/</span>libcrypto.so.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">1.1</span></pre>
</div>
<p> </p>
</div>
<div><4>更新动态链接库缓存</div>
<div data-theme="default" data-language="bash">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> ldconfig</pre>
</div>
<p> </p>
</div>
<div><5>重启mysql服务进程</div>
<div data-theme="default" data-language="bash">
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">1</span> <span style="color: rgba(0, 0, 0, 1)">systemctl restart mysql.server
</span><span style="color: rgba(0, 128, 128, 1)">2</span> 或者是：systemctl restart mysqld</pre>
</div>
<p> </p>
</div>
<div> </div><br><br>
来源：https://www.cnblogs.com/motion2077/p/18889441
頁:
[1]