The Configuration Overview page is displayed and shows the MySQL server installation is complete. This installs MySQL as a Service and starts MySQL automatically each time you start your computer. Start the MySQL Server at System Startup.Make sure the following two items are selected by default:.On the next MySQL Server Configuration page (2/3), choose a password for the root user, type it in, and write it down so you have it for future, then click Next.On the MySQL Server Configuration page (1/3), make sure the default Port Number is 3306, keep all the defaults and click Next.On the Configuration Overview page, click Next to setup the configuration.Once all of the products are installed click Next. The MySQL Server and the MySQL Workbench will both be installed. On the Installation Progress page, click Execute to install all of MySQL products.Click Next once all prerequisites are met. Follow any instructions to install any missing prerequisites. On the Check Requirements page, click Execute to make sure all required prerequisites are met.You can include the MySQL Workbench if you want, it is nice to have if you ever want to modify the raw structures. Optionally, you can select the Custom option and remove everything except the MySQL Server object. The only drawback is that the install will be much larger. On the Choosing a Setup Type page, the simplest option is to select Developer Default and click Next.If you want to use the version you have, you can select the skip option. On the Find latest products page, click Execute to check for installer updates from MySQL.On the License Agreement page, click the I accept the license terms box and click Next.Select the Install MySQL Products action.msi file to run it and to configure the installer. On the next page, click the No thanks, just start my download.I'm personally using the latest ZEOS 7.MySQL Installer is 32-bit, but will install both 32-bit and 64-bit binaries. If the application is 32bit then the dll must be 32bit also, same for 64bit. It is only that your application must load the proper dll for itself. The MySQL database itself does not matter whether 32 or 64bit, both the 32bit/64bit DLL can access them. Whichever your compiled executable is (Win32 or Win64), you need to load the proper 32 or 64bit LibMySQL.dll for it. "Unit output directory" to "units\$(TargetCPU)-$(TargetOS)" so I can see what files are what. I also put the "Target file name" to "something-$(TargetOS)" and the In the Lazarus "Project -> Project Options -> Code Generation" use the "Target OS" and "Target CPU Family" to make sure you either have "Win64/x86_64" or "Win32/i386" pair (of course you need the proper fpc units for both pairs). I am using the 32bit Lazarus and have cross-compiling to 64bit if I need 64bit applications.īy having 64 bit Lazarus does not guarantee that your compiled app is 64bit. I am able to create both 32bit and 64 bit Apps to use MySQL on my 64bit Windows machine (to connect to MySQL via tcp/ip locally or to remote servers). Am I better off Installing 32 Bit Lazarus, if so, what implications does that have for Windows 7 compatibilty? Where can I get a version of libmysql.dll that is guaranteed 64 Bits?Ģ. "Cannot load default MySQL Library ("libmysql.dll" or "libmysql.dll"). I have the 64 bit version of lazarus installed and I have tried both the 32 bit and (I think) the 64 bit version of libmysql.dll to no avail. I have copied the source for these to my new machine after downloading and installing Lazarus and BOOM!! I have the libmysql.dll in the application directory,and everything is hunky-dory. I have numerous Applications that talk to my MySQL Databases on my server, they all run fine on my old XP(SP3) machine. I have a Dell N5040, Windows 7(64 Bit), Lazarus 1.04, FPC Version2.6.0. I know this has been covered elsewhere(I think I've read most of the threads!),but I can't get this working.