服务器Centos部署MySql并连接Navicat过程详解
<p>(1)服务器配置：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_134768">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># cd /usr/local/src/</code>
</div>
<div class="line number2 index1 alt1">
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm </code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -ivh mysql57-community-release-el7-8.noarch.rpm </code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash string">""</code><code class="bash plain">"</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">mysql-community-client-5.7.30-1.el7.x86_64.rpm </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">mysql-community-server-5.7.31-1.el7.x86_64.rpm</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash string">""</code><code class="bash plain">"</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">将这两个个rpm包，以FTP形式导入：</code><code class="bash plain">/var/cache/yum/x86_64/7/mysql57-community/packages/</code>
</div>
<div class="line number12 index11 alt1">
</div>
<div class="line number13 index12 alt2">
<code class="bash plain"></code><code class="bash comments"># yum -y install mysql-server</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
等待时间较长</p>
<p>
(2)重置密码与创建用户</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_90787">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments">#重启mysql服务</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># service mysqld restart</code>
</div>
<div class="line number3 index2 alt2">
</div>
<div class="line number4 index3 alt1">
<code class="bash comments">#重置密码</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># grep "password" /var/log/mysqld.log</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<img style="max-width:100%!important;height:auto!important;"title="服务器Centos部署MySql并连接Navicat过程详解" alt="服务器Centos部署MySql并连接Navicat过程详解" src="https://zhuji.jb51.net/uploads/img/202305/4eb65d8fe665400e5412e3f4a325d294.jpg"></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_795823">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments">#密码重置mysql> alter user 'root'@'localhost' identified by 'password';//密码重置，新的密码</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code>
</div>
<div class="line number3 index2 alt2">
</div>
<div class="line number4 index3 alt1">
<code class="bash comments">#创建新的用户，</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">mysql> create user </code><code class="bash string">'username'</code><code class="bash plain">@</code><code class="bash string">'%'</code> <code class="bash plain">identified by </code><code class="bash string">'paswword'</code><code class="bash plain">;</code><code class="bash plain">//</code><code class="bash plain">添加新的用户，密码</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code><code class="bash comments">#给新用户分权限mysql> grant all privileges on *.* to 'user1'@'%' with grant option;</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash spaces"> </code><code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash spaces"> </code><code class="bash comments">#刷新权限 </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash spaces"> </code><code class="bash plain">mysql> flush privileges;</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash spaces"> </code><code class="bash plain">Query OK, 0 rows affected (0.00 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
Query OK, 0 rows affected (0.00 sec)</p>
<p>
#刷新权限</p>
<p>
mysql> flush privileges;</p>
<p>
Query OK, 0 rows affected (0.00 sec)</p>
<p>
(3)查询MySql当前用户：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_254833">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql color2">user</code><code class="sql plain">,host </code><code class="sql keyword">from</code> <code class="sql plain">mysql.</code><code class="sql color2">user</code><code class="sql plain">;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">+</code><code class="sql comments">---------------+-----------+</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">| </code><code class="sql color2">user</code> <code class="sql plain">| host |</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">+</code><code class="sql comments">---------------+-----------+</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">| user1 | % |</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">| mysql.session | localhost |</code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">| mysql.sys | localhost |</code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">| root | localhost |</code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">+</code><code class="sql comments">---------------+-----------+</code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">4 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec)</code>
</div>
<div class="line number11 index10 alt2">
</div>
<div class="line number12 index11 alt1">
<code class="sql plain">mysql></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
(4)实现在Navicat上连接</p>
<p>
【常规】端配置参数</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="服务器Centos部署MySql并连接Navicat过程详解" alt="服务器Centos部署MySql并连接Navicat过程详解" src="https://zhuji.jb51.net/uploads/img/202305/0643e0fc53e76ab6111c3b30e7317732.jpg"></p>
<p>
【SSH】端配置参数</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="服务器Centos部署MySql并连接Navicat过程详解" alt="服务器Centos部署MySql并连接Navicat过程详解" src="https://zhuji.jb51.net/uploads/img/202305/df28beeafe001a6bc8a4b90f28a91df2.jpg"></p>
<p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。</p>
<p>
原文链接：https://www.cnblogs.com/bashliuhe/p/13334354.html</p>
頁:
[1]