Mysql Libmysql.dll

[Riitta Palazzo]

NoteIguana may not always support the very latest version of MySQL, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.

The easiest way to install the libmysql shared library on a Mac is to install the full MySQL database server. We recommend using a DMG archive rather than a TAR archive, as the install process is simpler.

Note: The paths for the MySQL Library directory as this can change depending on the version of MySQL that you have installed. You should use the the latest driver which will normally be in the install directory that you use for MySQL.

Errors related to libmysql.dll can arise for a few different different reasons. For instance, a faulty application, libmysql.dll has been deleted or misplaced, corrupted by malicious software present on your PC or a damaged Windows registry.

In the vast majority of cases, the solution is to properly reinstall libmysql.dll on your PC, to the Windows system folder. Alternatively, some programs, notably PC games, require that the DLL file is placed in the game/application installation folder.

Do you have information that we do not?

Did our advice help or did we miss something?

Our Forum is where you can get help from both qualified tech specialists and the community at large. Sign up, post your questions, and get updates straight to your inbox.

To connect to the MySQL Embedded server, you do not need to specify Server, Host, Port, User_Name, Password connection definition parameters. If you do not specify the --skip-networking argument, then using libmysqld.dll you can connect to the remote MySQL servers, the same as with normal libmysql.dll.

Hey,

I ran into a strange problem with database connectivity.

In my PHP.ini at one point I had to comment out the following because mysql is now supported another way? I dunno, but it worked.

;Windows Extensions

;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

;

;extension=php_msql.dll

Hope this helps.

Peer

Roy,

as far as PHPRunner works you may take libmysql.dll file from C:\Program Files\PHPRunner and copy it here: C:\Windows\SYSTEM32.

To avoid confusion in future you can delete libmysql.dll file from these locations:

Thanks, Sergey.

I got rid of WebServ, which is an all-in-one install for Apache2/mySQL/PHP, and reinstalled the applications independently. Problem solved!

There are a couple of question that remain unanswered, though.

I would like to eliminate the search banner at the top of many of the screens. I've deactivated all the search and advanced search fields in PHPRunner, but the banner is still there. It simply limits the search to "any field." If it can't be eliminated, can you show me how to move it to the bottom of the screen?

Additionally, I'm having some issues with display format. I'll try to describe what's happening for one of the tables. I am having the problem with a couple of tables. I have a table called "CONTRACTS" and it contains the following columns: busid int(5), zone tinyint(3), volume tinyint(3), issue tinyint(3), section varchar(15) and adsize varchar(15). I'm displaying it horizontally and the volume and issue columns are displaying way too wide and the section and ad_size are displaying too narrow. In the display the busid is being replaced by the busname (varchar(30)) from a lookup table in the database ("Businesses") and the zone is being replaced by the zonedesc (varchar(25)) from a lookup table in the database ("Zones"), both columns are being displayed way too narrow. Now comes the kicker! The columns for "edit" and "delete" are so wide that they each take up about a third of the screen. That only leaves a third of the screen for the "real" data.

Roy

So if a library is not found then open a command prompt windows (ie run cmd) and type path - this needs to include the directory with the MySQL library eg "MySQL Server 5.7\lib" (Note it was compiled against MySQL 5.7). The file it needs to find in this directory is LIBMYSQL.DLL. to troubelshoot there is a very good tool called Dependency Walker . So if you download this tool and then point it to your hammerdb mysql library eg C:\Program Files\HammerDB-3.1\lib\mysqltcl3.052\libmysqltcl.dll then the first step in the tree is LIBMYSQL.DLL ... so if this is in your path and it is found by dependency walker then it should be loaded by librarycheck. If not in the windows search bar type "environment variables" and add the library directory to the path. If you have the wrong version then this LIBMYSQL.DLL file is all you need for the client to run. It doesn't need to be the same as the server you are testing.

Steve thanks.

I ran the library check and got mostly failures. The database I will be connecting to is not this server, so I don't have the MySQL libraries installed, no \MySQL Server5.7\lib..

HammerDB CLI v3.1

Copyright (C) 2003-2018 Steve Shaw

Type "help" for a list of commands

The xml is well-formed, applying configuration

hammerdb>librarycheck

Checking database library for Oracle

Oratcl_Init(): Failed loading oci.dll symbols with error 126Error: failed to load Oratcl -

Ensure that Oracle client libraries are installed and the location in the PATH environment variable

Checking database library for MSSQLServer

Success ... loaded library tclodbc for MSSQLServer

Checking database library for Db2

Error: failed to load db2tcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/db2tcl2.0.0/libdb2tcl.dll": this library or a dependent library could not be found in library path

Ensure that Db2 client libraries are installed and the location in the PATH environment variable

Checking database library for MySQL

Error: failed to load mysqltcl - couldn't load library "libmysqltcl.dll": this library or a dependent library could not be found in library path

Ensure that MySQL client libraries are installed and the location in the PATH environment variable

Checking database library for PostgreSQL

Error: failed to load Pgtcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/pgtcl2.1.1/libpgtcl.dll": this library or a dependent library could not be found in library path

Ensure that PostgreSQL client libraries are installed and the location in the PATH environment variable

Checking database library for Redis

Success ... loaded library redis for Redis

Hi Steve,

I ran into same issue. Any idea how to resolve this.

Even ran the dependencywalker pointing to "C:\Program Files\HammerDB-3.1\lib\mysqltcl3.052\libmysqltcl.dll" and see the first step in the tree is LIBMYSQL.DLL.

What's weird is, I have no issues with the same setup on my home lab, it is perfectly working fine there, but when i'm trying to setup the same on my office lab. I'm facing this issue. Below are the specs for your comparision

HammerDB CLI v3.1

Copyright (C) 2003-2018 Steve Shaw

Type "help" for a list of commands

The xml is well-formed, applying configuration

hammerdb>librarycheck

Checking database library for Oracle

Oratcl_Init(): Failed loading oci.dll symbols with error 126Error: failed to load Oratcl -

Ensure that Oracle client libraries are installed and the location in the PATH environment variable

Checking database library for MSSQLServer

Success ... loaded library tclodbc for MSSQLServer

Checking database library for Db2

Error: failed to load db2tcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/db2tcl2.0.0/libdb2tcl.dll": this library or a dependent library could not be found in library path

Ensure that Db2 client libraries are installed and the location in the PATH environment variable

Checking database library for MySQL

Error: failed to load mysqltcl - couldn't load library "libmysqltcl.dll": this library or a dependent library could not be found in library path

Ensure that MySQL client libraries are installed and the location in the PATH environment variable

Checking database library for PostgreSQL

Error: failed to load Pgtcl - couldn't load library "C:/Program Files/HammerDB-3.1/lib/pgtcl2.1.1/libpgtcl.dll": this library or a dependent library could not be found in library path

Ensure that PostgreSQL client libraries are installed and the location in the PATH environment variable

Checking database library for Redis

Success ... loaded library redis for Redis

The client libraries for MySQL are different for different versions so unlike for example where any client will do for MySQL it is more specific. HammerDB-3.1 has been compiled against the MySQL 5..7 client library on Linux that is libmysqlclient.so.20 and that is the only file you need. On Windows therefore I believe you will need LIBMYSQL.DLL from 5.7. I would think maybe on your home test system you already have 5.7 so it is picking up the correct one by default for you but this is not on your server system. If you find and copy just this dll then it should work.

Oracle Virtual Box is excellent BTW and a very good choice for testing.

First tried to load library libmysql and failed because of error: [The specified module cannoit be found] second tried to load library libmysql.dlland failed because of error:[The specified module cannoit be found]. (FWB 0090).

I tried loading the library libmysql.dll in various folders but i get the same error. Can anyone please help? Looks like the installation files wants the dll in a specific folder but dont know where it is.

I then installed BI using the bundled DB, copied the libmysql.dll to the winx64_x64 directory in the business objects install and repointed the CMS to the mysql DB via the Central Console Manager. this worked and recreated the CMSDB in MySql, i can see all the tables in the schema. However when I try to start the CMS via the CCM I get the following error. Basically the install will let me repoint the CMSDB and recreate it yet the application still cant see the dll to use it.

3a8082e126