Deepin系统安装mysql5.7
<h1 style="text-align: center">Deepin系统安装mysql5.7</h1><h2 id="mysql卸载">mysql卸载<button class="cnblogs-toc-button" title="显示目录导航"> </button></h2>
<div class="cnblogs_code">
<pre><br>sudo apt-<span style="color: rgba(0, 0, 255, 1)">get</span> --purge remove mysql-<span style="color: rgba(0, 0, 0, 1)">server
sudo apt</span>-<span style="color: rgba(0, 0, 255, 1)">get</span> --purge remove mysql-<span style="color: rgba(0, 0, 0, 1)">client
sudo apt</span>-<span style="color: rgba(0, 0, 255, 1)">get</span> --purge remove mysql-<span style="color: rgba(0, 0, 0, 1)">common
最后再通过下面的命令清理残余
sudo apt</span>-<span style="color: rgba(0, 0, 255, 1)">get</span><span style="color: rgba(0, 0, 0, 1)"> autoremove
sudo apt</span>-<span style="color: rgba(0, 0, 255, 1)">get</span><span style="color: rgba(0, 0, 0, 1)"> autoclean
sudo rm </span>/etc/mysql/ -<span style="color: rgba(0, 0, 0, 1)">R
sudo rm </span>/<span style="color: rgba(0, 0, 255, 1)">var</span>/lib/mysql/ -R</pre>
</div>
<p>第一次安装请卸载自带mysql</p>
<p> </p>
<p>Deepin系统源于debian，和ubuntu同为一个linux分支，与centos及redhat不是一个系列，在使用和安装软件方面有很大不同，本文简要记录在Deepin20版本下，安装mysql5.7的过程。</p>
<p>1.在mysql官网下载mysql-server_5.7.34-1debian10_amd64.deb-bundle.tar安装包（当然要根据自己的debian版本选择合适的版本）。</p>
<p>2.拷贝到合适位置（一般：/usr/local）,然后解压：</p>
<div class="cnblogs_code">
<pre>sudo tar -xf mysql-server_5.7.34-1debian10_amd64.deb-bundle.tar</pre>
</div>
<p>3.安装mysql</p>
<div class="cnblogs_code">
<pre>sudo dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb</pre>
</div>
<p>此时会报错：未安装软件包 libmecab2。</p>
<p>4.更新软件源，在/etc/apt/sources.list文件中添加新的软件源：</p>
<div class="cnblogs_code">
<pre>deb https://mirrors.aliyun.com/deepin/ apricot main contrib non-free</pre>
</div>
<p>千万记得更新系统软件源缓存，使之生效。</p>
<div class="cnblogs_code">
<pre>sudo apt-get update</pre>
</div>
<p>5.安装mysql所需的libmecab2</p>
<div class="cnblogs_code">
<pre>sudo apt-get -y install libmecab2 libjson-perl</pre>
</div>
<p>然后输入2次密码即可。</p>
<p>安装后，记得使用命令允许root远程访问：</p>
<div class="cnblogs_code">
<pre>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '****' WITH GRANT OPTION;<br><br>###分开<br><br><br>FLUSH PRIVILEGES;</pre>
</div>
<p>备注：如果不能使用右键粘贴，则运行命令:set mouse-=a，即可。</p>
<p> </p>
<h2>接下来修改mysql中字符编码问题：</h2>
<p><br>直接添加mysql的配置文件中编码为utf-8即可：</p>
<div class="cnblogs_code">
<pre>sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf</pre>
</div>
<p>在mysqld节点，添加以下：</p>
<div class="cnblogs_Highlighter">
<pre class="brush:csharp;gutter:true;">character-set-server = utf8</pre>
</div>
<p>重启mysql服务：</p>
<div class="cnblogs_code">
<pre>sudo systemctl restart mysql.service</pre>
</div>
<p>查看当前字符编码：</p>
<div class="cnblogs_code">
<pre>show variables like <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">char%</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
得到以下结果：
</span>+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+</pre>
</div>
<p>修改成功。</p>
<p><br>至此，mysql 5.7的所有安装配置在deepin中已经完成。<br><br></p>
<p>/etc/mysql/mysql.conf.d/mysqld.cnf</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">
pid</span>-file = /<span style="color: rgba(0, 0, 255, 1)">var</span>/run/mysqld/<span style="color: rgba(0, 0, 0, 1)">mysqld.pid
socket </span>= /<span style="color: rgba(0, 0, 255, 1)">var</span>/run/mysqld/<span style="color: rgba(0, 0, 0, 1)">mysqld.sock
datadir </span>= /<span style="color: rgba(0, 0, 255, 1)">var</span>/lib/<span style="color: rgba(0, 0, 0, 1)">mysql
log</span>-error = /<span style="color: rgba(0, 0, 255, 1)">var</span>/log/mysql/<span style="color: rgba(0, 0, 0, 1)">error.log
# By </span><span style="color: rgba(0, 0, 255, 1)">default</span> we only accept connections <span style="color: rgba(0, 0, 255, 1)">from</span><span style="color: rgba(0, 0, 0, 1)"> localhost
<span style="color: rgba(255, 0, 0, 1)">bind</span></span><span style="color: rgba(255, 0, 0, 1)">-address = 0.0.0.0</span><span style="color: rgba(0, 0, 0, 1)">
# Disabling symbolic</span>-links <span style="color: rgba(0, 0, 255, 1)">is</span><span style="color: rgba(0, 0, 0, 1)"> recommended to prevent assorted security risks
symbolic</span>-links=<span style="color: rgba(128, 0, 128, 1)">0</span><span style="color: rgba(0, 0, 0, 1)">
#skip</span>-grant-<span style="color: rgba(0, 0, 0, 1)">tables
<span style="color: rgba(255, 0, 0, 1)">character</span></span><span style="color: rgba(255, 0, 0, 1)">-set-server = utf8
lower_case_table_names=1</span></pre>
</div>
<p> </p><br><br>
来源：https://www.cnblogs.com/cbpm-wuhq/p/17411729.html
頁:
[1]