荃月 發表於 2019-6-4 20:14:00

ubuntu离线安装mysql

<h4 id="一ubuntu离线安装mysql">一：ubuntu离线安装mysql</h4>
<p>转载来源：https://blog.csdn.net/liuhuoxingkong/article/details/80696574</p>
<div id="article_content" class="article_content clearfix csdn-tracking-statistics" data-pid="blog" data-mod="popu_307" data-dsm="post">
            
                              
          <div class="htmledit_views" id="content_views">
            <p>参考文章：https://www.cnblogs.com/tabCtrlShift/p/6564002.html</p><p>某部署环境，因网络限制无法直接访问外网，所以只能手动下载安装包方式进行mysql安装。参考文章中仍有使用apt-get命令安装依赖的部分，所以补充部分缺失依赖的离线安装过程。</p><p>操作系统版本：</p><pre><code class="language-css"><span class="hljs-selector-tag">No</span> <span class="hljs-selector-tag">LSB</span> <span class="hljs-selector-tag">modules</span> <span class="hljs-selector-tag">are</span> <span class="hljs-selector-tag">available</span>.
<span class="hljs-selector-tag">Distributor</span> <span class="hljs-selector-tag">ID</span>:        <span class="hljs-selector-tag">Ubuntu</span>
<span class="hljs-selector-tag">Description</span>:        <span class="hljs-selector-tag">Ubuntu</span> 16<span class="hljs-selector-class">.04</span><span class="hljs-selector-class">.2</span> <span class="hljs-selector-tag">LTS</span>
<span class="hljs-selector-tag">Release</span>:        16<span class="hljs-selector-class">.04</span>
<span class="hljs-selector-tag">Codename</span>:        <span class="hljs-selector-tag">xenial</span></code></pre><p>一 mysql下载</p><p>mysql官网--&gt;download--&gt;社区版，https://dev.mysql.com/downloads/mysql/，选择对应操作系统版本的mysql安装文件，如下，</p><p><img src="https://img-blog.csdn.net/20180614181611728?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdWh1b3hpbmdrb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt=""><br></p><p><span style="font-size: 12px; line-height: 19.2px; background-color: rgba(255, 255, 255, 1)"><span style="font-family: SimSun; color: rgba(51, 51, 51, 1)">下载mysql-server_8.0.11-1ubuntu16.04_amd64.deb-bundle.tar，完成后上传至安装机器。</span></span></p><p></p><p><span style="font-size: 12px; line-height: 19.2px; background-color: rgba(255, 255, 255, 1)"><span style="font-family: SimSun; color: rgba(51, 51, 51, 1)">tar -xf mysql-server_5.7.22-1ubuntu16.04_amd64.deb-bundle.tar命令解压，得到如下安装包：</span></span></p><pre><code class="language-html hljs xml"><ol class="hljs-ln"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx1192920 Mar4 21:37 libmysqlclient-dev_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx   839962 Mar4 21:37 libmysqlclient20_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxx xxx17546554 Mar4 21:37 libmysqld-dev_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxx xxx12322 Mar4 21:37 mysql-client_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxx xxx15180 Mar4 21:37 mysql-common_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx7856138 Mar4 21:37 mysql-community-client_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx25396182 Mar4 21:37 mysql-community-server_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx48738976 Mar4 21:37 mysql-community-source_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx23857528 Mar4 21:37 mysql-community-test_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx12318 Mar4 21:37 mysql-server_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-rw-r--r-- 1 xxxxxx12328 Mar4 21:37 mysql-testsuite_5.7.22-1ubuntu16.04_amd64.deb</div></div></li></ol></code><div class="hljs-button {2}" data-title="复制"></div></pre><p>依次执行下面命令进行安装：</p><pre><code class="language-html hljs xml"><ol class="hljs-ln"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i mysql-common_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg-preconfigure mysql-community-server_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libmysqlclient20_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libmysqlclient-dev_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libmysqld-dev_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libc6_2.19-0ubuntu6_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libaio1_0.3.110-2_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i mysql-community-client_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i mysql-client_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i mysql-common_5.7.22-1ubuntu16.04_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> sudo dpkg -i mysql-community-server_5.7.22-1ubuntu16.04_amd64.deb</div></div></li></ol></code><div class="hljs-button {2}" data-title="复制"></div></pre>其中，<pre><code class="language-html hljs xml">libc6_2.19-0ubuntu6_amd64.deb   libaio1_0.3.110-2_amd64.deblibmecab2_0.996-1.2ubuntu1_amd64.deb</code><div class="hljs-button {2}" data-title="复制"></div></pre><p>是安装过程中依赖的包，这个根据实际安装环境不同可能会有不同的错误提示，只要按照错误日志提示，下载依赖包，并使用dpkg -i命令执行安装就可以解决。依赖包的下载，可在https://pkgs.org/上寻找，选择自己的系统版本即可。以libaio1为例：</p><p>缺失依赖包提示日志：</p><pre><code class="language-html hljs xml"><ol class="hljs-ln"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">:~/environments$ sudo dpkg -i mysql-community-client_5.7.22-1ubuntu16.04_amd64.deb </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Selecting previously unselected package mysql-community-client.</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">(Reading database ... 70413 files and directories currently installed.)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Preparing to unpack mysql-community-client_5.7.22-1ubuntu16.04_amd64.deb ...</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Unpacking mysql-community-client (5.7.22-1ubuntu16.04) ...</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">dpkg: dependency problems prevent configuration of mysql-community-client:</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> mysql-community-client depends on libaio1 (&gt;= 0.3.93); however:</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Package libaio1 is not installed.</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">dpkg: error processing package mysql-community-client (--install):</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dependency problems - leaving unconfigured</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Processing triggers for man-db (2.7.5-1) ...</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Errors were encountered while processing:</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> mysql-community-client</div></div></li></ol></code><div class="hljs-button {2}" data-title="复制"></div></pre><br><p>https://pkgs.org/download/libaio1&nbsp;<br></p><p><img src="https://img-blog.csdn.net/20180614182443561?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdWh1b3hpbmdrb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt=""><br></p><p><br></p><p>mysql server安装过程中会提示输入root用户密码，待所有安装完成后，使用命令登陆即可。如密码设置为123456</p><p>mysql -uroot -p123456</p><p><br></p><p><br></p>          </div>
                  </div><br><br>
来源：https://www.cnblogs.com/itzlg/p/10975842.html
頁: [1]
查看完整版本: ubuntu离线安装mysql