Recent

Author Topic: Simple instruction to connect MySQL 5.7 to a Lazarus project  (Read 8379 times)

solent007

  • Newbie
  • Posts: 2
Simple instruction to connect MySQL 5.7 to a Lazarus project
« on: September 25, 2018, 04:36:54 pm »
Lazarus IDE v1.8.4,  MySql 5.7, MySQL Shell 8.0.12, Windows 10 Home 64-bit

Hi, I am trying to link a MySQL database with Lazarus to make a simple app for learning.
Is there a simple tutorial / video/ documentation I can follow to do this as I am having problems.
I am looking for the basic settings just to get it running. I can access and edit the database from MySQL shell without problem.
One problem I have experienced is that the error message below comes up when I have tried to connect it with MySQL57Connection1.

"Can not load default MySQL library (“libmysql.dll” or “libmysql.dll”). Check your installation."

I am a beginner so please keep it simple!
Thank you.

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: Simple instruction to connect MySQL 5.7 to a Lazarus project
« Reply #1 on: September 25, 2018, 05:22:31 pm »
Lazarus IDE v1.8.4,  MySql 5.7, MySQL Shell 8.0.12, Windows 10 Home 64-bit

Hi, I am trying to link a MySQL database with Lazarus to make a simple app for learning.
Is there a simple tutorial / video/ documentation I can follow to do this as I am having problems.
I am looking for the basic settings just to get it running. I can access and edit the database from MySQL shell without problem.
One problem I have experienced is that the error message below comes up when I have tried to connect it with MySQL57Connection1.

"Can not load default MySQL library (“libmysql.dll” or “libmysql.dll”). Check your installation."

I am a beginner so please keep it simple!
Thank you.
Have you read the wiki information?

MySQLDatabases
http://wiki.freepascal.org/MySQLDatabases

mysql
http://wiki.lazarus.freepascal.org/mysql

SqlDBHowto
http://wiki.lazarus.freepascal.org/SqlDBHowto

SQLdb_Package
http://wiki.freepascal.org/SQLdb_Package

Looking for simple Lazarus and MySQL database solution?
http://forum.lazarus.freepascal.org/index.php/topic,38967.0.html

Connection MySQL database
https://forum.lazarus.freepascal.org/index.php/topic,38780.0.html

mysql connector 5.6
https://forum.lazarus.freepascal.org/index.php/topic,34795.0.html

Download MySQL Community Server
https://dev.mysql.com/downloads/mysql/

solent007

  • Newbie
  • Posts: 2
Re: Simple instruction to connect MySQL 5.7 to a Lazarus project
« Reply #2 on: September 27, 2018, 10:06:10 pm »
Thank you very much. I will get reading as I have not seen some of this.
Then try again!

 

TinyPortal © 2005-2018