apache mysql - 3306 上的“数据包乱序”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10053613/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
apache mysql - "packets out of order" on 3306
提问by Adam
I just did a fresh install of Apache server 2.2. Everything works. When I go to localhost I get: "It Works!"
我刚刚全新安装了 Apache 服务器 2.2。一切正常。当我去本地主机时，我得到：“它有效！”
I just installed mySQL5.5 and when I go to localhost:3306 I just get gibberish:
我刚刚安装了 mySQL5.5，当我转到 localhost:3306 时，我只是胡言乱语：
J??? 5.5.22?'???4[LM{D~p??÷!???????????6[I=4/+,9z{|?mysql_native_password?!????#08S01Got packets out of order
J？？？5.5.22?'???4[LM{D~p??÷!?????????????6[I=4/+,9z{|?mysql_native_password?!????# 08S01数据包乱序
I see many posts on the internet with users with similar problems, but I can't figure out a solution.
我在互联网上看到很多用户遇到类似问题的帖子，但我想不出解决方案。
Can anyone help?
任何人都可以帮忙吗？
采纳答案by rainecc
The mysql service is not a web interface - you cannot connect using a browser. You will need to install a mysql client of some kind.
mysql 服务不是 Web 界面 - 您无法使用浏览器进行连接。您将需要安装某种类型的 mysql 客户端。
回答by Black
If you try to start phpmyadminthen do it like this:
如果您尝试开始，phpmyadmin请执行以下操作：
localhost/phpmyadmin
回答by Halit Kazzaz
Try just to write http://localhost/without the port and it will work , Or go to your phpmyadmin and click on My websites and it will take you immediately to your localhost
尝试只写http://localhost/没有端口，它会工作，或者去你的 phpmyadmin 并点击我的网站，它会立即带你到你的本地主机
回答by Silver
I'm a jsp beginner. I have a same problem with you. I guess it's kind of port problem.
我是一个jsp初学者。我和你有同样的问题。估计是端口问题。
For me, I had set the port for Apache server connector as 9090. Later, when I installed mysql, the port for mysql was 3306 as its default port.
对我来说，我把Apache服务器连接器的端口设置为9090。后来我安装mysql时，mysql的端口是3306作为默认端口。
In my jsp file, i loaded jdbc driver like 'jdbc:mysql://localhost:9090/dbname' and then i call 'http://localhost:9090/my.jsp' on my web browser. That's when I got the same problem with you.
在我的 jsp 文件中，我加载了 jdbc 驱动程序，如“jdbc:mysql://localhost:9090/dbname”，然后在我的 Web 浏览器上调用“http://localhost:9090/my.jsp”。那是我和你遇到同样问题的时候。
I fixed the port part in my jsp file like 'jdbc:mysql://localhost:3306/dbname' and I could get it all right.
我修复了我的 jsp 文件中的端口部分，如“jdbc:mysql://localhost:3306/dbname”，我可以得到它。
I think you need to check the port for your Apache server. You can check out \conf\server.xml file in your Apache directory. The part starts with "Connector port=8080...." in server.xml file. If so, you need to put 'http://localhost:8080... on your browser.
我认为您需要检查 Apache 服务器的端口。您可以查看 Apache 目录中的 \conf\server.xml 文件。该部分以 server.xml 文件中的“Connector port=8080....”开头。如果是这样，您需要在浏览器上输入“http://localhost:8080...”。
回答by John B Gilbert
I'm having exactly the same problem, so far I have : 1)Manually changed the Collation (it seemed to be defaulting to cp850)
我遇到了完全相同的问题，到目前为止我有：1）手动更改排序规则（它似乎默认为 cp850）
2)altered the ini/cnf file (located under services.msc -> MySQL)
2) 修改了 ini/cnf 文件（位于 services.msc -> MySQL 下）
3)Changed the max_packet_size to 2G
3) 将 max_packet_size 改为 2G
3)rebooted the server.
3）重启服务器。
As a start to this please run this script from MySQL 'SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';'
作为开始，请从 MySQL 'SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';' 运行此脚本
It should bring up a table of your collations, they should all read utf8 Possible causes
它应该显示您的排序规则表，它们都应该读取 utf8 可能的原因
