connect mysql8.0 error
lazarus / 16-Databases

----------------------------------------------------------------------
softchina · 2020-08-28 21:04

I use mysqlconnector5.7 component to connect mysql8.0 server, and I
set skiplibaryversioncheck property to true,and the error shows "can't
load default mysql libary...", how to solve this problem,thank you!

btw,I can access mysql8 with navicat,and mysql8 runs ok,and also i'm a
new user for lazarus,thank you again!

envirnment: windows 10 pro,Mysql 8.0(green version)

----------------------------------------------------------------------
Chris_h174 · 2020-08-31 10:12

Quote from: softchina on August 28, 2020, 11:04:33 pmI use
mysqlconnector5.7 component to connect mysql8.0 server, and I set
skiplibaryversioncheck property to true,and the error shows "can't
load default mysql libary...", how to solve this problem,thank you!

btw,I can access mysql8 with navicat,and mysql8 runs ok,and also i'm a
new user for lazarus,thank you again!

envirnment: windows 10 pro,Mysql 8.0(green version)
There is a dll that the client m/c needs to access.  I don't have a
Win m/c running to look just now but it's something like mysqllib.dll
(does the dialog box say?) [Edited: may be libmysql.dll].  Find it
(must be the right version) and put it in your exe folder or better
still in your search path.
HTH
Chris

----------------------------------------------------------------------
rvk · 2020-08-31 10:25

Quote from: softchina on August 28, 2020, 11:04:33 pmI use
mysqlconnector5.7 component to connect mysql8.0 server, and I set
skiplibaryversioncheck property to true,and the error shows "can't
load default mysql libary...", how to solve this problem,thank you!
What bitness are you using for Lazarus (32 bit or 64 bit)?
What bitness of the mySQL client is installed (32 bit or 64 bit)?

----------------------------------------------------------------------
softchina · 2020-09-01 06:06

Quote from: rvk on August 31, 2020, 12:25:53 pmWhat bitness are you
using for Lazarus (32 bit or 64 bit)?                     //lazarus
v2.06 64bit
What bitness of the mySQL client is installed (32 bit or 64 bit)?    
       //mysql server 8.0 64bit