apache mysql - "packets out of order" on 3306

Question

I just did a fresh install of Apache server 2.2. Everything works. When I go to localhost I get: "It Works!"

I just installed mySQL5.5 and when I go to localhost:3306 I just get gibberish:

J��� 5.5.22�'���4[LM{D~p�ÿ÷!�€����������6[I=4/+,9z{|�mysql_native_password�!��ÿ„#08S01Got packets out of order

I see many posts on the internet with users with similar problems, but I can't figure out a solution.

Can anyone help?

Answer 1

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.

Answer 2

If you try to start phpmyadmin then do it like this:

localhost/phpmyadmin

Answer 3

I'm a jsp beginner. I have a same problem with you. I guess it's kind of port problem.

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.

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.

I fixed the port part in my jsp file like 'jdbc:mysql://localhost:3306/dbname' and I could get it all right.

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.