Ubuntu Server 16.04安装MySQL设置远程访问出现问题的完美解决方案(error:10061)
<p>说明：</p>
<p>
一个朋友在使用Ubuntu Server 16.04安装MySQL，设置远程访问的时候出现了问题，请我帮忙。但是，我也没有使用过Ubuntu安装MySQL，于是乎搜索了很多技术文件，比着葫芦画瓢。但是，由于MySQL版本的差异，导致在安装设置的过程中出现了一些问题：就是不能远程访问。</p>
<p>
<span><strong>一、安装mysql</strong></span></p>
<p>
1. 安装需要使用root账号，如果不会设置root账号的请参考Linux公社的其他文章。安装mysql过程中，需要设置mysql的root账号的密码，不要忽略了。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_52773">
<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 functions">sudo</code> <code class="bash plain">apt-get </code><code class="bash functions">install</code> <code class="bash plain">mysql-server</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">apt isntall mysql-client</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">apt </code><code class="bash functions">install</code> <code class="bash plain">libmysqlclient-dev</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2. 以上3个软件包安装完成后，使用如下命令查询是否安装成功：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_563782">
<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 functions">sudo</code> <code class="bash functions">netstat</code> <code class="bash plain">-tap | </code><code class="bash functions">grep</code> <code class="bash 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>
查询结果如下图所示，表示安装成功。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_28795">
<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 plain">root@linuxidc.com:~</code><code class="bash comments"># netstat -tap | grep mysql</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">tcp6 0 0 [::]:mysql [::]:* LISTEN 7510</code><code class="bash plain">/mysqld</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">root@linuxidc.com:~</code><code class="bash comments">#</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>
<span><strong>二、设置mysql远程访问</strong></span></p>
<p>
1. 编辑mysql配置文件，把其中bind-address = 127.0.0.1注释了</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_747059">
<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 functions">vi</code> <code class="bash plain">/etc/mysql/mysql</code><code class="bash plain">.conf.d</code><code class="bash plain">/mysqld</code><code class="bash plain">.cnf</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2. 使用root进入mysql命令行，执行如下2个命令，示例中mysql的root账号密码：root</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_848027">
<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">grant all on *.* to root@</code><code class="bash string">'%'</code> <code class="bash plain">identified by </code><code class="bash string">'root'</code> <code class="bash plain">with grand option;</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">flush privileges;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
3. 重启mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_946534">
<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">/etc/init</code><code class="bash plain">.d</code><code class="bash plain">/mysql</code> <code class="bash plain">restart</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>三、设置账号权限</strong></span></p>
<p>
给用户授权</p>
<p>
我用的用户是root 密码123456</p>
<p>
示例:</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_946938">
<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">GRANT ALL PRIVILEGES ON *.* TO </code><code class="bash string">'root'</code><code class="bash plain">@</code><code class="bash string">'%'</code> <code class="bash plain">IDENTIFIED BY </code><code class="bash string">'123456'</code> <code class="bash plain">WITH GRANT OPTION;</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>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_794875">
<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">mysql:flush privileges;</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>
重启成功后，在其他计算机上，便可以登录。</p>
<p>
以上所述是小编给大家介绍的Ubuntu Server 16.04安装MySQL设置远程访问出现问题的完美解决方案(error:10061)，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对网站的支持！</p>
頁:
[1]