centos7 mysql数据库安装和配置
<p><span><strong>一、系统环境</strong></span></p>
<p>
yum update升级以后的系统版本为</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_621746">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># cat /etc/redhat-release </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">centos linux release 7.1.1503 (core)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
<span><strong>二、mysql安装</strong></span></p>
<p>
一般网上给出的资料都是</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_568923">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments">#yum install mysql</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments">#yum install mysql-server</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash comments">#yum install mysql-devel</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
安装mysql和mysql-devel都成功，但是安装mysql-server失败，如下： </p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_195296">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># yum install mysql-server</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">loaded plugins: fastestmirror</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">loading mirror speeds from cached hostfile</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash spaces"> </code><code class="bash plain">* base: mirrors.sina.cn</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash spaces"> </code><code class="bash plain">* extras: mirrors.sina.cn</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash spaces"> </code><code class="bash plain">* updates: mirrors.sina.cn</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">no package mysql-server available.</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">error: nothing to </code><code class="bash keyword">do</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
查资料发现是centos 7 版本将mysql数据库软件从默认的程序列表中移除，用mariadb代替了。</p>
<p>
有两种解决办法：</p>
<p>
<strong>1、方法一：安装mariadb</strong></p>
<p>
mariadb数据库管理系统是mysql的一个分支，主要由开源社区在维护，采用gpl授权许可。开发这个分支的原因之一是：甲骨文公司收购了mysql后，有将mysql闭源的潜在风险，因此社区采用分支的方式来避开这个风险。mariadb的目的是完全兼容mysql，包括api和命令行，使之能轻松成为mysql的代替品。</p>
<p>
安装mariadb，大小59 m。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_644223">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># yum install mariadb-server mariadb</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
mariadb数据库的相关命令是：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_661678">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">systemctl start mariadb </code><code class="bash comments">#启动mariadb</code>
</div>
<div class="line number2 index1 alt1">
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">systemctl stop mariadb </code><code class="bash comments">#停止mariadb</code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">systemctl restart mariadb </code><code class="bash comments">#重启mariadb</code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">systemctl </code><code class="bash functions">enable</code> <code class="bash plain">mariadb </code><code class="bash comments">#设置开机启动</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
所以先启动数据库</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_445615">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># systemctl start mariadb</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
然后就可以正常使用mysql了 </p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_649650">
<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>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># mysql -u root -p</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">enter password: </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">welcome to the mariadb monitor. commands end with ; or \g.</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">your mariadb connection </code><code class="bash functions">id</code> <code class="bash plain">is 3</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">server version: 5.5.41-mariadb mariadb server</code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">copyright (c) 2000, 2014, oracle, mariadb corporation ab and others.</code>
</div>
<div class="line number8 index7 alt1">
</div>
<div class="line number9 index8 alt2">
<code class="bash functions">type</code> <code class="bash string">'help;'</code> <code class="bash plain">or </code><code class="bash string">'\h'</code> <code class="bash keyword">for</code> <code class="bash plain">help. </code><code class="bash functions">type</code> <code class="bash string">'\c'</code> <code class="bash plain">to </code><code class="bash functions">clear</code> <code class="bash plain">the current input statement.</code>
</div>
<div class="line number10 index9 alt1">
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">mariadb [(none)]> show databases;</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">| database |</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">| information_schema |</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">| mysql |</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">| performance_schema |</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">| </code><code class="bash functions">test</code> <code class="bash plain">|</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain">4 rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code> <code class="bash plain">(0.00 sec)</code>
</div>
<div class="line number21 index20 alt2">
</div>
<div class="line number22 index21 alt1">
<code class="bash plain">mariadb [(none)]> </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
安装mariadb后显示的也是 mariadb [(none)]> ，可能看起来有点不习惯。下面是第二种方法。</p>
<p>
<strong>2、方法二：官网下载安装mysql-server</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_227388">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments"># wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments"># rpm -ivh mysql-community-release-el7-5.noarch.rpm</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash comments"># yum install mysql-community-server</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
安装成功后重启mysql服务。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_711182">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments"># service mysqld restart</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
初次安装mysql，root账户没有密码。 </p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_1173">
<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>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># mysql -u root </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">welcome to the mysql monitor. commands end with ; or \g.</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">your mysql connection </code><code class="bash functions">id</code> <code class="bash plain">is 3</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">server version: 5.6.26 mysql community server (gpl)</code>
</div>
<div class="line number5 index4 alt2">
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">copyright (c) 2000, 2015, oracle and</code><code class="bash plain">/or</code> <code class="bash plain">its affiliates. all rights reserved.</code>
</div>
<div class="line number7 index6 alt2">
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">oracle is a registered trademark of oracle corporation and</code><code class="bash plain">/or</code> <code class="bash plain">its</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">affiliates. other names may be trademarks of their respective</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">owners.</code>
</div>
<div class="line number11 index10 alt2">
</div>
<div class="line number12 index11 alt1">
<code class="bash functions">type</code> <code class="bash string">'help;'</code> <code class="bash plain">or </code><code class="bash string">'\h'</code> <code class="bash keyword">for</code> <code class="bash plain">help. </code><code class="bash functions">type</code> <code class="bash string">'\c'</code> <code class="bash plain">to </code><code class="bash functions">clear</code> <code class="bash plain">the current input statement.</code>
</div>
<div class="line number13 index12 alt2">
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">mysql> show databases;</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">| database |</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">| information_schema |</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">| mysql |</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain">| performance_schema |</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash plain">| </code><code class="bash functions">test</code> <code class="bash plain">|</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash plain">+--------------------+</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash plain">4 rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code> <code class="bash plain">(0.01 sec)</code>
</div>
<div class="line number24 index23 alt1">
</div>
<div class="line number25 index24 alt2">
<code class="bash plain">mysql> </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
设置密码</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_68239">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">set</code> <code class="sql keyword">password</code> <code class="sql keyword">for</code> <code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'localhost'</code> <code class="sql plain">=</code><code class="sql keyword">password</code><code class="sql plain">(</code><code class="sql string">'password'</code><code class="sql plain">);</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">query ok, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.00 sec)</code>
</div>
<div class="line number3 index2 alt2">
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">mysql> </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
不需要重启数据库即可生效。</p>
<p>
在mysql安装过程中如下内容： </p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_532216">
<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="sql plain">installed:</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql spaces"> </code><code class="sql plain">mysql-community-client.x86_64 0:5.6.26-2.el7 mysql-community-devel.x86_64 0:5.6.26-2.el7 </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql spaces"> </code><code class="sql plain">mysql-community-libs.x86_64 0:5.6.26-2.el7 mysql-community-server.x86_64 0:5.6.26-2.el7 </code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">dependency installed:</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql spaces"> </code><code class="sql plain">mysql-community-common.x86_64 0:5.6.26-2.el7 </code>
</div>
<div class="line number7 index6 alt2">
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">replaced:</code>
</div>
<div class="line number9 index8 alt2">
<code class="sql spaces"> </code><code class="sql plain">mariadb.x86_64 1:5.5.41-2.el7_0 mariadb-devel.x86_64 1:5.5.41-2.el7_0 mariadb-libs.x86_64 1:5.5.41-2.el7_0 </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql spaces"> </code><code class="sql plain">mariadb-server.x86_64 1:5.5.41-2.el7_0 </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
所以安装完以后mariadb自动就被替换了，将不再生效。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_680194">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># rpm -qa |grep mariadb</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
<span><strong>三、配置mysql</strong></span></p>
<p>
1、编码</p>
<p>
mysql配置文件为/etc/my.cnf</p>
<p>
最后加上编码配置</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_903732">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">default-character-</code><code class="bash functions">set</code> <code class="bash plain">=utf8</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
这里的字符编码必须和/usr/share/mysql/charsets/index.xml中一致。</p>
<p>
<img style="max-width:100%!important;height:auto!important;"title="centos7 mysql数据库安装和配置" alt="centos7 mysql数据库安装和配置" src="https://zhuji.jb51.net/uploads/img/202305/e1679bbfaa0a5937f10d994be85b245f.jpg"></p>
<p>
2、远程连接设置</p>
<p>
把在所有数据库的所有表的所有权限赋值给位于所有ip地址的root用户。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_479902">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">grant</code> <code class="sql color1">all</code> <code class="sql keyword">privileges</code> <code class="sql keyword">on</code> <code class="sql plain">*.* </code><code class="sql keyword">to</code> <code class="sql plain">root@</code><code class="sql string">'%'</code><code class="sql plain">identified </code><code class="sql keyword">by</code> <code class="sql string">'password'</code><code class="sql plain">;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
如果是新用户而不是root，则要先新建用户</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_692521">
<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>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql></code><code class="sql keyword">create</code> <code class="sql color2">user</code> <code class="sql string">'username'</code><code class="sql plain">@</code><code class="sql string">'%'</code> <code class="sql plain">identified </code><code class="sql keyword">by</code> <code class="sql string">'password'</code><code class="sql plain">;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
此时就可以进行远程连接了。</p>
<p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。</p>
<p>
原文链接：http://www.cnblogs.com/starof/p/4680083.html</p>
頁:
[1]