Recent

Author Topic: [SOLVED] ZEOS MySQL MariaDB named pipes  (Read 952 times)

pcurtis

  • Hero Member
  • *****
  • Posts: 951
[SOLVED] ZEOS MySQL MariaDB named pipes
« on: February 02, 2021, 06:48:24 pm »
Hi All,

how can I connect to MySQL / MariaDB using named pipes?

The DB is setup correctly, I can connect with HeidiSQL

Thanks in advance.
« Last Edit: February 03, 2021, 02:18:42 pm by pcurtis »
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

PascalDragon

  • Hero Member
  • *****
  • Posts: 5942
  • Compiler Developer
Re: [SOLVED] ZEOS MySQL MariaDB named pipes
« Reply #1 on: February 03, 2021, 09:18:30 am »
You've marked this is solved. Maybe you want to explain how you solved it so that others who struggle with this might find the solution as well?

pcurtis

  • Hero Member
  • *****
  • Posts: 951
Re: [1/2 SOLVED] ZEOS MySQL MariaDB named pipes
« Reply #2 on: February 03, 2021, 12:46:58 pm »
It turns out it's only half solved so at the moment I don't have a full solution. I am searching elsewhere to find the correct way.
It seems that here is not the ideal place to get help on this topic.
I have remarked as 1/2 solved and will post a solution when I have one. OK?
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

lucamar

  • Hero Member
  • *****
  • Posts: 4219
Re: [1/2 SOLVED] ZEOS MySQL MariaDB named pipes
« Reply #3 on: February 03, 2021, 01:06:34 pm »
It seems that here is not the ideal place to get help on this topic.

Maybe you should have posted in Databases or an OS-specific sub-board instead of General?

Just saying :-X
« Last Edit: February 03, 2021, 01:08:23 pm by lucamar »
Turbo Pascal 3 CP/M - Amstrad PCW 8256 (512 KB !!!) :P
Lazarus/FPC 2.0.8/3.0.4 & 2.0.12/3.2.0 - 32/64 bits on:
(K|L|X)Ubuntu 12..18, Windows XP, 7, 10 and various DOSes.

pcurtis

  • Hero Member
  • *****
  • Posts: 951
Re: [1/2 SOLVED] ZEOS MySQL MariaDB named pipes
« Reply #4 on: February 03, 2021, 01:11:56 pm »
I thought that later but can't change it
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

pcurtis

  • Hero Member
  • *****
  • Posts: 951
Re: [1/2 SOLVED] ZEOS MySQL MariaDB named pipes
« Reply #5 on: February 03, 2021, 02:18:00 pm »
Add these two lines to properties

MYSQL_OPT_NAMED_PIPE
MYSQL_OPT_PROTOCOL=3
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

 

TinyPortal © 2005-2018