How to test which port MySQL is running on and whether it can be connected to?

Question

I have installed the MySQL and indeed logged in there as a user.

However, while I try to connect like this:

http://localhost:3306
mysql://localhost:3306

Neither of it works. Not certain if both are supposed to work, though at least one of them should work.

How can I confirm that the port is indeed 3306? Is there any Linux command to check it anyhow? Plus, is there anymore right way to try it through a URL?

Answer 1

So for determining a listener on a port, do this

netstat -tln

You should see a line that seems like this if MySQL is indeed listening on that port.

tcp        0      0 127.0.0.1:3306              0.0.0.0:*                   LISTEN  

Port 3306 is the MySQL's default port.

In order, to connect, you simply have to use any client you need, such as the basic MySQL client.

mysql -h localhost -u user database

Or a URL which is defined by your library code.

Want to become a SQL Expertise? Join the SQL Course and get certified.