Connect to different port using MySql Command Line Client

Question

By default I am being connected to port 3309.I need to connect to port 3307.How do I do that?

Answer 1

Use -P parameter, like this:

mysql -h 127.0.0.1 -P 3307 -u user_name -p database_name

Important: if you connecting to localhost - use -h 127.0.0.1, NOT localhost, because MySQL will connect by file socket, not by TCP

Answer 2

From command line, assuming you are on the same host, have you tried :

mysql --user root --password (mypassword) --host=localhost --port=33061 

In server name specify custom port when not using default one (you can imply it only when is the standard mysql port 3306)

$servername = "localhost:33061";

Answer 3

you can use -P (uppercase) or --port=portnumber sample

mysql -u root -P 13306 -p databasename

or

mysql -u root --port=13306 -p databasename