Lazarus

Programming => Packages and Libraries => Topic started by: MrSlay on July 12, 2018, 05:45:54 am

Title: MySQL 8 and Lazarus
Post by: MrSlay on July 12, 2018, 05:45:54 am

Forgive my ignorance, as I am somewhat a beginner at this.  I have recently been ask to program a database software.  I have decided to go with lazarus, and mysql for my software.  problem is there is only a data component for mysql 5.0 thru 5.7.  and I am running mysql server 8.  is there a package update out there somewhere that I havent come across yet that incorporates mysql 8?

Title: Re: MySQL 8 and Lazarus
Post by: GAN on July 12, 2018, 06:31:32 am

You can use the package ZeosLib https://sourceforge.net/projects/zeoslib/ (https://sourceforge.net/projects/zeoslib/)

Title: Re: MySQL 8 and Lazarus
Post by: Mlhy on April 11, 2019, 09:24:57 am

This solution works for me: I have installed Lazarus v2.0 and MySQL server 8.0. For connection to MySQL server I use MySQL57Connection component and library libmySQL.dll v 5.7 (taken from the MySQL server 5.7 installation).

Title: Re: MySQL 8 and Lazarus
Post by: diego bertotti on March 31, 2022, 01:40:56 pm

Hello.

I had the same problem.

I was finally able to fix it, by copying libmysql.dll from the mysql lib folder. In my case, "D:\mysql57\lib", and you need to pay attention to binary versions. OS, .exe and dll must be all 64 or all 32 bit.

I used component 5.7, with dll version 5.7, but my mysql installation is version 8, (xampp) and it's working!

Title: Re: MySQL 8 and Lazarus
Post by: Hemptwister on January 31, 2023, 07:28:47 pm

I just installed Lazarus on Windows and it has a MYSQL80 connector. Is it Windows only? My Linux version only goes up to 57.

Title: Re: MySQL 8 and Lazarus
Post by: PascalDragon on January 31, 2023, 08:59:42 pm

Quote from: Hemptwister on January 31, 2023, 07:28:47 pm

I just installed Lazarus on Windows and it has a MYSQL80 connector. Is it Windows only? My Linux version only goes up to 57.

What is the version of your Lazarus/FPC?

Title: Re: MySQL 8 and Lazarus
Post by: eldonfsr on February 01, 2023, 02:23:12 am

Yes is possible to work with mysql8 and connecting to lazarus using 5.7 connector i suggest you use loadlibrary and put dll on your folder where  is running your app, this way for me aboid a lot problems with erro can load library...

just something like this...

   SQLDLL.LibraryName:=WideString(ExtractFilePath(ParamStr(0)) + 'libmysql.dll');
    SQLDLL.LoadLibrary;   
 for windows i don't know on linux.... i don't have a machine running linux...