ubuntu 服务器中mysql的安装与连接方法
<div id="navCategory"><h5 class="catalogue">目录</h5><ul class="first_class_ul"><li><a href="#_label0">1.mysql的安装与初始化</a></li><li><a href="#_label1">2.mysql 进行远程连接的时候报错记录</a></li><ul class="second_class_ul"><li><a href="#_lab2_1_0">2.1.1 报错信息</a></li><li><a href="#_lab2_1_1">2.1.2 解决方案</a></li><li><a href="#_lab2_1_2">2.2.1 报错信息</a></li><li><a href="#_lab2_1_3">2.2.2 解决方案</a></li></ul><li><a href="#_label2">3 大功告成</a></li><ul class="second_class_ul"></ul><li><a href="#_label3">Host is not allowed to connect to this MySQL server解决方法</a></li><ul class="second_class_ul"></ul></ul></div><p class="maodian"><a name="_label0"></a></p><h2>1.mysql的安装与初始化</h2><div class="jb51code"><pre class="brush:bash;">sudo apt update
sudo apt install mysql-server-8.0 mysql-client-8.0
sudo mysql # 进入mysqlshell后输入下面的命令设置mysql的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</pre></div>
<p class="maodian"><a name="_label1"></a></p><h2>2.mysql 进行远程连接的时候报错记录</h2>
<p class="maodian"><a name="_lab2_1_0"></a></p><h3>2.1.1 报错信息</h3>
<p>2013 - Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11</p>
<p class="maodian"><a name="_lab2_1_1"></a></p><h3>2.1.2 解决方案</h3>
<p>修改配置文件配置允许远程连接</p>
<div class="jb51code"><pre class="brush:bash;">sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf </pre></div>
<p>其中之‘ /etc/mysql/mysql.conf.d/mysqld.cnf ’ 是ubuntu22.04中mysql8.0.35的具体配置文件路径,不同的版本文件路径有些差异，读者可以从/etc/mysql/mysql.conf 中获取信息。</p>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202401/2024011211114651.png" /></p>
<p class="maodian"><a name="_lab2_1_2"></a></p><h3>2.2.1 报错信息</h3>
<p>Host '' is not allowed to connect to this MySQL server</p>
<p class="maodian"><a name="_lab2_1_3"></a></p><h3>2.2.2 解决方案</h3>
<p><strong>Host is not allowed to connect to this MySQL server解决方法</strong>，见文末扩展知识介绍。</p>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202401/2024011211114652.png" /></p>
<p>修改root用户允许远程访问后如果还是无法链接记得重新启动mysql服务</p>
<div class="jb51code"><pre class="brush:bash;">sudo systemctl restart mysql</pre></div>
<p class="maodian"><a name="_label2"></a></p><h2>3 大功告成</h2>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202401/2024011211114653.png" /></p>
<p><span style="color:#ff0000"><strong>扩展：</strong></span></p>
<p class="maodian"><a name="_label3"></a></p><h2>Host is not allowed to connect to this MySQL server解决方法</h2>
<p>这个错误，其实就是我们安装的MySQL不允许远程登录，解决方法如下：</p>
<p>1.在装有MySQL的机器上登录MySQL mysql -u root -p密码<br />执行use mysql;<br />select host from user where user = ‘root’;</p>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202401/2024011211140655.png" /></p>
<p>该结果表示是当前的root用户限制在当前的ip内访问的，需要修改他的访问域。</p>
<p>2.执行update user set host = ‘%’ where user = ‘root’;</p>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202401/2024011211140656.png" /></p>
<p>3.执行FLUSH PRIVILEGES 或者重启 MySQL 即可;</p>
<p>到此这篇关于ubuntu 服务器中mysql的安装与连接的文章就介绍到这了,更多相关ubuntu安装mysql内容请搜索琼殿技术社区以前的文章或继续浏览下面的相关文章希望大家以后多多支持琼殿技术社区！</p>
頁:
[1]