Debian 11安装mysql 8.0.13
<svg xmlns="http://www.w3.org/2000/svg" style="display: none"><path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0)"></path>
</svg>
<p></p>
<div class="toc">
<h3>Debian 11安装mysql 8.0.13</h3>
<ul><li>1、下载mysql安装包</li><li>2、安装文档</li><li><ul><li>2.1、安装依赖包</li><li>2.2、安装MySQL包</li><li>2.3、文件安装位置</li></ul>
</li><li>3、测试mysql安装</li></ul>
</div>
<p></p>
<h1>1、下载mysql安装包</h1>
<p>访问官方下载页面下载bundle安装包<br> https://downloads.mysql.com/archives/community/</p>
<p><img src="https://img-blog.csdnimg.cn/ca068a286dfc46af88b407550deb8d92.png" alt="在这里插入图片描述"></p>
<p>下载文件 然后解压</p>
<pre><code class="prism language-bash"><span class="token function">mkdir</span>-p /package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle
<span class="token function">tar</span> -xvf /package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle.tar -C /package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle
</code></pre>
<p>解压后的文件如图</p>
<pre><code class="prism language-bash">root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># ls -lh</span>
total 97M
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> 877K Oct<span class="token number">7</span><span class="token number">2018</span> libmysqlclient21_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">1</span>.1M Oct<span class="token number">7</span><span class="token number">2018</span> libmysqlclient-dev_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-client_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>83K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-common_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">2</span>.2M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-client_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">1</span>.4M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-client-core_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>23M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-server_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>17M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-server-core_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>52M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-test_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-server_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-testsuite_8.0.13-1debian9_amd64.deb
root@debian:/Koal/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># </span>
</code></pre>
<h1>2、安装文档</h1>
<p>https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/linux-installation-debian.html</p>
<h2>2.1、安装依赖包</h2>
<pre><code class="prism language-bash"><span class="token function">apt-get</span> <span class="token function">install</span> libaio1
</code></pre>
<h2>2.2、安装MySQL包</h2>
<pre><code class="prism language-bash"><span class="token builtin class-name">cd</span> /package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle
dpkg-preconfigure mysql-community-server_*.deb
</code></pre>
<p>此步骤会进行设定mysql的root密码</p>
<p><img src="https://img-blog.csdnimg.cn/1b1abcc8f5bb4df78e669aaa0d243c5a.png" alt="在这里插入图片描述"><br> 选择mysql加密组件，为了兼容性，可以选择老的加密方式。<br> <img src="https://img-blog.csdnimg.cn/68af79ce71104effbd2257853663a451.png" alt="在这里插入图片描述"></p>
<p>包文件如图所示</p>
<pre><code class="prism language-bash">root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># ls -lh</span>
total 97M
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> 877K Oct<span class="token number">7</span><span class="token number">2018</span> libmysqlclient21_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">1</span>.1M Oct<span class="token number">7</span><span class="token number">2018</span> libmysqlclient-dev_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-client_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>83K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-common_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">2</span>.2M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-client_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span> <span class="token number">1</span>.4M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-client-core_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>23M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-server_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>17M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-server-core_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>52M Oct<span class="token number">7</span><span class="token number">2018</span> mysql-community-test_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-server_8.0.13-1debian9_amd64.deb
-rw-r--r-- <span class="token number">1</span> <span class="token number">7155</span> <span class="token number">31415</span>79K Oct<span class="token number">7</span><span class="token number">2018</span> mysql-testsuite_8.0.13-1debian9_amd64.deb
root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># </span>
</code></pre>
<p>安装MySQL包<br> 本次安装失败 是因为依赖关系缺少的依赖包未安装导致导致安装失败</p>
<pre><code class="prism language-bash">root@debian:package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># dpkg -i mysql-{common,community-client-core,community-client,client,community-server-core,community-server,server}_*.deb</span>
Selecting previously unselected package mysql-common.
<span class="token punctuation">(</span>Reading database <span class="token punctuation">..</span>. <span class="token number">136712</span> files and directories currently installed.<span class="token punctuation">)</span>
Preparing to unpack mysql-common_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-common <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-community-client-core.
Preparing to unpack mysql-community-client-core_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-community-client-core <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-community-client.
Preparing to unpack mysql-community-client_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-community-client <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-client.
Preparing to unpack mysql-client_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-client <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-community-server-core.
Preparing to unpack mysql-community-server-core_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-community-server-core <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-community-server.
Preparing to unpack mysql-community-server_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-community-server <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package mysql-server.
Preparing to unpack mysql-server_8.0.13-1debian9_amd64.deb <span class="token punctuation">..</span>.
Unpacking mysql-server <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-common <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf <span class="token punctuation">(</span>my.cnf<span class="token punctuation">)</span> <span class="token keyword">in</span> auto mode
dpkg: dependency problems prevent configuration of mysql-community-client-core:
mysql-community-client-core depends on libncurses5 <span class="token punctuation">(</span><span class="token operator">>=</span> <span class="token number">6</span><span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package libncurses5 is not installed.
mysql-community-client-core depends on libtinfo5 <span class="token punctuation">(</span><span class="token operator">>=</span> <span class="token number">6</span><span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package libtinfo5 is not installed.
dpkg: error processing package mysql-community-client-core <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-community-client:
mysql-community-client depends on mysql-community-client-core <span class="token punctuation">(</span><span class="token operator">=</span> <span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package mysql-community-client-core is not configured yet.
dpkg: error processing package mysql-community-client <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-client:
mysql-client depends on mysql-community-client <span class="token punctuation">(</span><span class="token operator">=</span> <span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package mysql-community-client is not configured yet.
dpkg: error processing package mysql-client <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-community-server-core:
mysql-community-server-core depends on libmecab2<span class="token punctuation">;</span> however:
Package libmecab2 is not installed.
dpkg: error processing package mysql-community-server-core <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-community-server:
mysql-community-server depends on mysql-client <span class="token punctuation">(</span><span class="token operator">=</span> <span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package mysql-client is not configured yet.
mysql-community-server depends on mysql-community-server-core <span class="token punctuation">(</span><span class="token operator">=</span> <span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package mysql-community-server-core is not configured yet.
mysql-community-server depends on libmecab2<span class="token punctuation">;</span> however:
Package libmecab2 is not installed.
dpkg: error processing package mysql-community-server <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-community-server <span class="token punctuation">(</span><span class="token operator">=</span> <span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span><span class="token punctuation">;</span> however:
Package mysql-community-server is not configured yet.
dpkg: error processing package mysql-server <span class="token punctuation">(</span>--install<span class="token punctuation">)</span>:
dependency problems - leaving unconfigured
Processing triggers <span class="token keyword">for</span> man-db <span class="token punctuation">(</span><span class="token number">2.9</span>.4-2<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Errors were encountered <span class="token keyword">while</span> processing:
mysql-community-client-core
mysql-community-client
mysql-client
mysql-community-server-core
mysql-community-server
mysql-server
root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># </span>
</code></pre>
<p>apt-get -f install 修复上述问题</p>
<pre><code class="prism language-bash"><span class="token function">apt-get</span> -f <span class="token function">install</span>
</code></pre>
<p>安装过程会自动创建MySQL的systemd服务</p>
<pre><code class="prism language-bash">root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment"># apt-get -f install </span>
Reading package lists<span class="token punctuation">..</span>. Done
Building dependency tree<span class="token punctuation">..</span>. Done
Reading state information<span class="token punctuation">..</span>. Done
Correcting dependencies<span class="token punctuation">..</span>. Done
The following additional packages will be installed:
libmecab2 libncurses5 libtinfo5
The following NEW packages will be installed:
libmecab2 libncurses5 libtinfo5
<span class="token number">0</span> upgraded, <span class="token number">3</span> newly installed, <span class="token number">0</span> to remove and <span class="token number">210</span> not upgraded.
<span class="token number">6</span> not fully installed or removed.
Need to get <span class="token number">653</span> kB of archives.
After this operation, <span class="token number">2,670</span> kB of additional disk space will be used.
Do you want to continue? <span class="token punctuation">[</span>Y/n<span class="token punctuation">]</span> y
Get:1 https://mirrors.tuna.tsinghua.edu.cn/debian bullseye/main amd64 libmecab2 amd64 <span class="token number">0.996</span>-14+b4 <span class="token punctuation">[</span><span class="token number">221</span> kB<span class="token punctuation">]</span>
Get:2 https://mirrors.tuna.tsinghua.edu.cn/debian bullseye/main amd64 libtinfo5 amd64 <span class="token number">6.2</span>+20201114-2 <span class="token punctuation">[</span><span class="token number">336</span> kB<span class="token punctuation">]</span>
Get:3 https://mirrors.tuna.tsinghua.edu.cn/debian bullseye/main amd64 libncurses5 amd64 <span class="token number">6.2</span>+20201114-2 <span class="token punctuation">[</span><span class="token number">96.8</span> kB<span class="token punctuation">]</span>
Fetched <span class="token number">653</span> kB <span class="token keyword">in</span> 1s <span class="token punctuation">(</span><span class="token number">965</span> kB/s<span class="token punctuation">)</span>
Selecting previously unselected package libmecab2:amd64.
<span class="token punctuation">(</span>Reading database <span class="token punctuation">..</span>. <span class="token number">136962</span> files and directories currently installed.<span class="token punctuation">)</span>
Preparing to unpack <span class="token punctuation">..</span>./libmecab2_0.996-14+b4_amd64.deb <span class="token punctuation">..</span>.
Unpacking libmecab2:amd64 <span class="token punctuation">(</span><span class="token number">0.996</span>-14+b4<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package libtinfo5:amd64.
Preparing to unpack <span class="token punctuation">..</span>./libtinfo5_6.2+20201114-2_amd64.deb <span class="token punctuation">..</span>.
Unpacking libtinfo5:amd64 <span class="token punctuation">(</span><span class="token number">6.2</span>+20201114-2<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Selecting previously unselected package libncurses5:amd64.
Preparing to unpack <span class="token punctuation">..</span>./libncurses5_6.2+20201114-2_amd64.deb <span class="token punctuation">..</span>.
Unpacking libncurses5:amd64 <span class="token punctuation">(</span><span class="token number">6.2</span>+20201114-2<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up libmecab2:amd64 <span class="token punctuation">(</span><span class="token number">0.996</span>-14+b4<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-community-server-core <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up libtinfo5:amd64 <span class="token punctuation">(</span><span class="token number">6.2</span>+20201114-2<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up libncurses5:amd64 <span class="token punctuation">(</span><span class="token number">6.2</span>+20201114-2<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-community-client-core <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-community-client <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-client <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Setting up mysql-community-server <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf <span class="token punctuation">(</span>my.cnf<span class="token punctuation">)</span> <span class="token keyword">in</span> auto mode
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Setting up mysql-server <span class="token punctuation">(</span><span class="token number">8.0</span>.13-1debian9<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
Processing triggers <span class="token keyword">for</span> libc-bin <span class="token punctuation">(</span><span class="token number">2.31</span>-13+deb11u3<span class="token punctuation">)</span> <span class="token punctuation">..</span>.
root@debian:/package/mysql/mysql-server_8.0.13-1debian9_amd64.deb-bundle<span class="token comment">#</span>
</code></pre>
<p>至此安装MySQL成功，启动MySQL服务</p>
<pre><code class="prism language-bash">root@debian:/package/mysql<span class="token comment"># systemctl status mysql</span>
● mysql.service - MySQL Community Server
Loaded: loaded <span class="token punctuation">(</span>/lib/systemd/system/mysql.service<span class="token punctuation">;</span> enabled<span class="token punctuation">;</span> vendor preset: enabled<span class="token punctuation">)</span>
Active: active <span class="token punctuation">(</span>running<span class="token punctuation">)</span> since Fri <span class="token number">2023</span>-03-31 05:04:56 EDT<span class="token punctuation">;</span> 8min ago
Docs: man:mysqld<span class="token punctuation">(</span><span class="token number">8</span><span class="token punctuation">)</span>
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: <span class="token number">3107</span> <span class="token assign-left variable">ExecStartPre</span><span class="token operator">=</span>/usr/share/mysql-8.0/mysql-systemd-start pre <span class="token punctuation">(</span>code<span class="token operator">=</span>exited, <span class="token assign-left variable">status</span><span class="token operator">=</span><span class="token number">0</span>/SUCCESS<span class="token punctuation">)</span>
Main PID: <span class="token number">3142</span> <span class="token punctuation">(</span>mysqld<span class="token punctuation">)</span>
Status: <span class="token string">"SERVER_OPERATING"</span>
Tasks: <span class="token number">37</span> <span class="token punctuation">(</span>limit: <span class="token number">7035</span><span class="token punctuation">)</span>
Memory: <span class="token number">377</span>.0M
CPU: <span class="token number">3</span>.785s
CGroup: /system.slice/mysql.service
└─3142 /usr/sbin/mysqld
Mar <span class="token number">31</span> 05:04:55 debian systemd<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span>: Starting MySQL Community Server<span class="token punctuation">..</span>.
Mar <span class="token number">31</span> 05:04:56 debian systemd<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span>: Started MySQL Community Server.
root@debian:/package/mysql<span class="token comment"># </span>
root@debian:/package/mysql<span class="token comment"># mysql -uroot -p</span>
Enter password:
Welcome to the MySQL monitor.Commands end with <span class="token punctuation">;</span> or <span class="token punctuation">\</span>g.
Your MySQL connection <span class="token function">id</span> is <span class="token number">9</span>
Server version: <span class="token number">8.0</span>.13 MySQL Community Server - GPL
Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2000</span>, <span class="token number">2018</span>, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type <span class="token string">'help;'</span> or <span class="token string">'\h'</span> <span class="token keyword">for</span> help. Type <span class="token string">'\c'</span> to <span class="token function">clear</span> the current input statement.
mysql<span class="token operator">></span>
mysql<span class="token operator">></span> show databases<span class="token punctuation">;</span>
+--------------------+
<span class="token operator">|</span> Database <span class="token operator">|</span>
+--------------------+
<span class="token operator">|</span> information_schema <span class="token operator">|</span>
<span class="token operator">|</span> mysql <span class="token operator">|</span>
<span class="token operator">|</span> performance_schema <span class="token operator">|</span>
<span class="token operator">|</span> sys <span class="token operator">|</span>
+--------------------+
<span class="token number">4</span> rows <span class="token keyword">in</span> <span class="token builtin class-name">set</span> <span class="token punctuation">(</span><span class="token number">0.00</span> sec<span class="token punctuation">)</span>
mysql<span class="token operator">></span>
</code></pre>
<h2>2.3、文件安装位置</h2>
<p>Here are where the files are installed on the system:</p>
<p>All configuration files (like my.cnf) are under /etc/mysql</p>
<p>All binaries, libraries, headers, etc., are under /usr/bin and /usr/sbin</p>
<p>The data directory is under /var/lib/mysql</p>
<pre><code class="prism language-bash">root@debian:~<span class="token comment"># ls -l /etc/mysql/</span>
total <span class="token number">16</span>
drwxr-xr-x <span class="token number">2</span> root root <span class="token number">4096</span> Mar <span class="token number">31</span> 04:56 conf.d
lrwxrwxrwx <span class="token number">1</span> root root <span class="token number">24</span> Mar <span class="token number">31</span> 05:04 my.cnf -<span class="token operator">></span> /etc/alternatives/my.cnf
-rw-r--r-- <span class="token number">1</span> root root <span class="token number">1469</span> Oct<span class="token number">7</span><span class="token number">2018</span> my.cnf.fallback
-rw-r--r-- <span class="token number">1</span> root root <span class="token number">1497</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql.cnf
drwxr-xr-x <span class="token number">2</span> root root <span class="token number">4096</span> Mar <span class="token number">31</span> 05:04 mysql.conf.d
root@debian:~<span class="token comment"># ls -l /usr/bin/|grep "mysql*"</span>
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5985184</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5626480</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqladmin
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">6047392</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlbinlog
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5639600</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlcheck
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5371424</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql_config_editor
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">26716</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqld_multi
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">29769</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqld_safe
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5697904</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqldump
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">7855</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqldumpslow
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5622864</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlimport
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">6310096</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlpump
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5611344</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql_secure_installation
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5617296</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlshow
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5640528</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqlslap
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5393808</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql_ssl_rsa_setup
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">5285152</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql_tzinfo_to_sql
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">11663568</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysql_upgrade
root@debian:~<span class="token comment"># ls -l /usr/sbin/|grep "mysql*"</span>
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">54811120</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqld
-rwxr-xr-x <span class="token number">1</span> root root <span class="token number">108243792</span> Oct<span class="token number">7</span><span class="token number">2018</span> mysqld-debug
root@debian:~<span class="token comment"># ls -l /var/lib/mysql</span>
total <span class="token number">168008</span>
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">56</span> Mar <span class="token number">31</span> 05:04auto.cnf
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">471</span> Mar <span class="token number">31</span> 05:04binlog.000001
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">155</span> Mar <span class="token number">31</span> 05:04binlog.000002
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">32</span> Mar <span class="token number">31</span> 05:04binlog.index
-rw------- <span class="token number">1</span> mysql mysql <span class="token number">1680</span> Mar <span class="token number">31</span> 05:04ca-key.pem
-rw-r--r-- <span class="token number">1</span> mysql mysql <span class="token number">1112</span> Mar <span class="token number">31</span> 05:04ca.pem
-rw-r--r-- <span class="token number">1</span> mysql mysql <span class="token number">1112</span> Mar <span class="token number">31</span> 05:04client-cert.pem
-rw------- <span class="token number">1</span> mysql mysql <span class="token number">1676</span> Mar <span class="token number">31</span> 05:04client-key.pem
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">3580</span> Mar <span class="token number">31</span> 05:04ib_buffer_pool
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">12582912</span> Mar <span class="token number">31</span> 05:04ibdata1
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">50331648</span> Mar <span class="token number">31</span> 05:04ib_logfile0
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">50331648</span> Mar <span class="token number">31</span> 05:04ib_logfile1
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">12582912</span> Mar <span class="token number">31</span> 05:04ibtmp1
drwxr-x--- <span class="token number">2</span> mysql mysql <span class="token number">4096</span> Mar <span class="token number">31</span> 05:04 <span class="token string">'#innodb_temp'</span>
drwxr-x--- <span class="token number">2</span> mysql mysql <span class="token number">4096</span> Mar <span class="token number">31</span> 05:04mysql
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">25165824</span> Mar <span class="token number">31</span> 05:04mysql.ibd
drwxr-x--- <span class="token number">2</span> mysql mysql <span class="token number">4096</span> Mar <span class="token number">31</span> 05:04performance_schema
-rw------- <span class="token number">1</span> mysql mysql <span class="token number">1680</span> Mar <span class="token number">31</span> 05:04private_key.pem
-rw-r--r-- <span class="token number">1</span> mysql mysql <span class="token number">452</span> Mar <span class="token number">31</span> 05:04public_key.pem
-rw-r--r-- <span class="token number">1</span> mysql mysql <span class="token number">1112</span> Mar <span class="token number">31</span> 05:04server-cert.pem
-rw------- <span class="token number">1</span> mysql mysql <span class="token number">1680</span> Mar <span class="token number">31</span> 05:04server-key.pem
drwxr-x--- <span class="token number">2</span> mysql mysql <span class="token number">4096</span> Mar <span class="token number">31</span> 05:04sys
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">10485760</span> Mar <span class="token number">31</span> 05:04undo_001
-rw-r----- <span class="token number">1</span> mysql mysql <span class="token number">10485760</span> Mar <span class="token number">31</span> 05:04undo_002
root@debian:~<span class="token comment"># </span>
</code></pre>
<h1>3、测试mysql安装</h1>
<p>建立数据库</p>
<pre><code class="prism language-bash">root@debian:~<span class="token comment"># mysql -uroot -p</span>
Enter password:
Welcome to the MySQL monitor.Commands end with <span class="token punctuation">;</span> or <span class="token punctuation">\</span>g.
Your MySQL connection <span class="token function">id</span> is <span class="token number">10</span>
Server version: <span class="token number">8.0</span>.13 MySQL Community Server - GPL
Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2000</span>, <span class="token number">2018</span>, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type <span class="token string">'help;'</span> or <span class="token string">'\h'</span> <span class="token keyword">for</span> help. Type <span class="token string">'\c'</span> to <span class="token function">clear</span> the current input statement.
mysql<span class="token operator">></span> show databases<span class="token punctuation">;</span>
+--------------------+
<span class="token operator">|</span> Database <span class="token operator">|</span>
+--------------------+
<span class="token operator">|</span> information_schema <span class="token operator">|</span>
<span class="token operator">|</span> mysql <span class="token operator">|</span>
<span class="token operator">|</span> performance_schema <span class="token operator">|</span>
<span class="token operator">|</span> sys <span class="token operator">|</span>
+--------------------+
<span class="token number">4</span> rows <span class="token keyword">in</span> <span class="token builtin class-name">set</span> <span class="token punctuation">(</span><span class="token number">0.01</span> sec<span class="token punctuation">)</span>
mysql<span class="token operator">></span> create database <span class="token builtin class-name">test</span><span class="token punctuation">;</span>
Query OK, <span class="token number">1</span> row affected <span class="token punctuation">(</span><span class="token number">0.01</span> sec<span class="token punctuation">)</span>
mysql<span class="token operator">></span> show databases<span class="token punctuation">;</span>
+--------------------+
<span class="token operator">|</span> Database <span class="token operator">|</span>
+--------------------+
<span class="token operator">|</span> information_schema <span class="token operator">|</span>
<span class="token operator">|</span> mysql <span class="token operator">|</span>
<span class="token operator">|</span> performance_schema <span class="token operator">|</span>
<span class="token operator">|</span> sys <span class="token operator">|</span>
<span class="token operator">|</span> <span class="token builtin class-name">test</span> <span class="token operator">|</span>
+--------------------+
<span class="token number">5</span> rows <span class="token keyword">in</span> <span class="token builtin class-name">set</span> <span class="token punctuation">(</span><span class="token number">0.00</span> sec<span class="token punctuation">)</span>
mysql<span class="token operator">></span>
</code></pre>
</div>
<div id="MySignature" role="contentinfo">
<p></p>
<p></p>
时光如水，总是无言。若你安好，便是晴天。
<p></p>
<p>本文来自博客园，作者：OceanWaves，转载请注明原文链接：https://www.cnblogs.com/OceanWaves/p/17312430.html</p><br><br>
来源：https://www.cnblogs.com/OceanWaves/p/17312430.html
頁:
[1]