Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2023-04

TSQLConnector for MySQL non-standard port

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Koenraad Lelong

Hi,

I would like to use a non-standard port for my MySQL-connection. Is this possible ? If so, how ?
Standard port is 3306.
I tried to add my non-standard port to the hostname (<hostname>:<portnumber>), but that does not work: 'TMySQL57Connection : Server connect failed.'
Sniffing the network on that port gives nothing, so there is no attempt to connect.
MySQLWorkbench with the same parameters works OK, so there is a server listening on that port.

Koenraad.

Reply by email

LacaK
to Koenraad Lelong

Hello,
try use "Params" and put there "Port=nnnn"
-Laco.

Show quoted text 14 lines
Hi, I would like to use a non-standard port for my MySQL-connection. Is this possible ? If so, how ? Standard port is 3306. I tried to add my non-standard port to the hostname (<hostname>:<portnumber>), but that does not work: 'TMySQL57Connection : Server connect failed.' Sniffing the network on that port gives nothing, so there is no attempt to connect. MySQLWorkbench with the same parameters works OK, so there is a server listening on that port. Koenraad.

Reply by email

Michael Van Canneyt
to Koenraad Lelong: I would like to use a non-standard port for my MySQL-connection. Is this possible ? If…
Koenraad Lelong wrote 12 lines
Hi, I would like to use a non-standard port for my MySQL-connection. Is this possible ? If so, how ? Standard port is 3306. I tried to add my non-standard port to the hostname (<hostname>:<portnumber>), but that does not work: 'TMySQL57Connection : Server connect failed.' Sniffing the network on that port gives nothing, so there is no attempt to connect. MySQLWorkbench with the same parameters works OK, so there is a server listening on that port.

Try this:

Params.Values['Port']:='3306'

Michael.

Reply by email

Koenraad Lelong
to Michael Van Canneyt

Thanks,

That works.

Koenraad

Op 25/04/2023 om 08:17 schreef Michael Van Canneyt via lazarus:

Show quoted text 22 lines
On Mon, 24 Apr 2023, Koenraad Lelong via lazarus wrote: > Hi, > > I would like to use a non-standard port for my MySQL-connection. Is > this possible ? If so, how ? > Standard port is 3306. > I tried to add my non-standard port to the hostname > (<hostname>:<portnumber>), but that does not work: 'TMySQL57Connection > : Server connect failed.' > Sniffing the network on that port gives nothing, so there is no > attempt to connect. > MySQLWorkbench with the same parameters works OK, so there is a server > listening on that port. Try this: Params.Values['Port']:='3306' Michael.

Reply by email