How to give port number MySql database in "Add Connection Window"

Question

I have two versions of MySql in my database server. One of them is under 5.0 and the other one is 5.2. Older one looks 3306 port and the new one looks 3307 port. I want to use new one on my .net project. When I try to give my server's IP address to Add Connection window, it looks 3306 port and says, "Connector/Net no longer supports server version prior to 5.0". I think it will be solved when I can give the port number.

Answer 1

After the ip just add ":portnumber" on the connection string

Answer 2

Open Advanced settings by clicking "Advance" button and inside you'll find the port parameter and then change it, I've practiced it many times.

Answer 3

From the docs

You can also set the port to connect with the MySQL server by pressing the Advanced button.