Rake db:create => LIBMYSQL.DLL not found. how to solve?

Rails
1

ruby.exe - Unable to locate Component
This application has failed to start because LIBMYSQL.DLL was not
found. Re-installing the application might
fix this problem.

i get that message when running rake db:create
from what directory should i run rake db:create?

2

[1] gem install mysql
[2] you will see like error syntac but dont pay attention to it
[3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
not ruby folder.
[4] copy & paste that file to ruby/bin
[5] restart your server or console, if you are already run it.

Then Cheer,
Reinhart
http://teapoci.blogspot.com

3

do i need to download(and pay for) mysql separately from www.mysql.com?
what does gem install mysql do? downloads and installs it or just
downloads some Rails-Mysql-connectivity?

On 23 Apr, 04:46, Visit Indonesia 2008 <rails-mailing-l…@andreas-

4

Frederick C. wrote:

On 23 Apr 2008, at 04:16, globalrev wrote:

do i need to download(and pay for) mysql separately from
www.mysql.com?
mysql is free (look for the ‘community server’ stuff, as there is also
stuff you can pay for if you want technical support and that sort of
thing).

what does gem install mysql do? downloads and installs it or just
downloads some Rails-Mysql-connectivity?
it’s the library through which ruby (and therefore rails) accesses
mysql.

Fred

I just experienced the same problem and after a Google on the phrase,
the general consensus among those who offered solutions worked for me
also. It seems that MySQL 5.1 does not play well with Ruby. I resolved
this by downloading the 5.0 version. More specifically:
“mysql-noinstall-5.0.83-win32.zip”. Remove bin/libmysql.dll from the zip
file and place it in Ruby/bin/. This worked for me.
Good luck.
Herb

5

On 23 Apr 2008, at 04:16, globalrev wrote:

do i need to download(and pay for) mysql separately from
www.mysql.com?
mysql is free (look for the ‘community server’ stuff, as there is also
stuff you can pay for if you want technical support and that sort of
thing).

what does gem install mysql do? downloads and installs it or just
downloads some Rails-Mysql-connectivity?
it’s the library through which ruby (and therefore rails) accesses
mysql.

Fred

6

Rails T. wrote:

[1] gem install mysql
[2] you will see like error syntac but dont pay attention to it
[3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
not ruby folder.
[4] copy & paste that file to ruby/bin
[5] restart your server or console, if you are already run it.

Then Cheer,
Reinhart
http://teapoci.blogspot.com

Thanx Reinhart

this helps me to run rails on windows.

7

I just experienced the same problem and after a Google on the phrase,
the general consensus among those who offered solutions worked for me
also. It seems that MySQL 5.1 does not play well with Ruby. I resolved
this by downloading the 5.0 version. More specifically:
“mysql-noinstall-5.0.83-win32.zip”. Remove bin/libmysql.dll from the zip
file and place it in Ruby/bin/. This worked for me.
Good luck.
Herb

Hi Herb,
Thanks a lot. Copying libmysql.dll to Ruby/bin seems to have
worked for me too.

Cheers.

8

m trying to run my hello world prgm<since 3hrs now!!> pls help…1st i
got the above stated error…on solvin tat<thnks 2 u’ll> now i am getting
:

/!\ FAILSAFE /!\ 2010-08-24 03:27:09 +0530
Status: 500 Internal Server Error
Unknown database ‘demo_development’
C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
ection_adapters/mysql_adapter.rb:619:in `real_connect’…

help plz

9

Sagar Jhobalia wrote:

m trying to run my hello world prgm<since 3hrs now!!> pls help…1st i
got the above stated error…on solvin tat<thnks 2 u’ll> now i am getting
:

/!\ FAILSAFE /!\ 2010-08-24 03:27:09 +0530
Status: 500 Internal Server Error
Unknown database ‘demo_development’
C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
ection_adapters/mysql_adapter.rb:619:in `real_connect’…

help plz

It means just what it says. Does the DB exist yet?

Best,
–Â
Marnen Laibow-Koser
http://www.marnen.org
[email protected]

Sent from my iPhone

10

Sagar Jhobalia wrote:

Marnen Laibow-Koser wrote:

Sagar Jhobalia wrote:

m trying to run my hello world prgm<since 3hrs now!!> pls help…1st i
got the above stated error…on solvin tat<thnks 2 u’ll> now i am getting
:

/!\ FAILSAFE /!\ 2010-08-24 03:27:09 +0530
Status: 500 Internal Server Error
Unknown database ‘demo_development’
C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
ection_adapters/mysql_adapter.rb:619:in `real_connect’…

help plz

It means just what it says. Does the DB exist yet?

Best,
–Â
Marnen Laibow-Koser
http://www.marnen.org
[email protected]

Sent from my iPhone

i don’t understand,i mean i’ve installed the mysql,& the application
itself requires no access of database…so…i stil dont know what am i
suppossed to do.

check you config/database.yml page. obviously it mentions a database
named ‘demo_development’.

just like Marnen has mentioned above, it must be because this database
does not exist that you are getting this error.

11

This worked for me. A minor correction: libmysql.dll is in mysql/lib
folder and paste it to your ruby/bin folder!!!

Yacobus Reinhart wrote in post #664497:

[1] gem install mysql
[2] you will see like error syntac but dont pay attention to it
[3] find LIBMYSQL.DLL from your mysql/bin folder in your mysql folder
not ruby folder.
[4] copy & paste that file to ruby/bin
[5] restart your server or console, if you are already run it.

Then Cheer,
Reinhart
http://teapoci.blogspot.com

12

For further details about this issue, refer to the post -

This along with many other issues of mysql2 gem has already been solved
by many users and they have posted their solutions also.

Thanks
Ritesh Kumar

13

Marnen Laibow-Koser wrote:

Sagar Jhobalia wrote:

m trying to run my hello world prgm<since 3hrs now!!> pls help…1st i
got the above stated error…on solvin tat<thnks 2 u’ll> now i am getting
:

/!\ FAILSAFE /!\ 2010-08-24 03:27:09 +0530
Status: 500 Internal Server Error
Unknown database ‘demo_development’
C:/Ruby19/lib/ruby/gems/1.9.1/gems/activerecord-2.3.8/lib/active_record/conn
ection_adapters/mysql_adapter.rb:619:in `real_connect’…

help plz

It means just what it says. Does the DB exist yet?

Best,
–Â
Marnen Laibow-Koser
http://www.marnen.org
[email protected]

Sent from my iPhone

i don’t understand,i mean i’ve installed the mysql,& the application
itself requires no access of database…so…i stil dont know what am i
suppossed to do.

14

I know it been to late but almost you would like to know a fix to this error. As it is one of the common missing file error and related to a family of .DLL files. If you almost have tried different ways and methods to fix it you need to make sure before trying any method about the cause of the error. The reason for the cause may vary and also the method to fix it varies. You can try fixing libmysql.dll file by simply restoring the file at specific path or location this would fix it.

15

LIBMYSQL.DLL missing error is not new. This error has been continuing to appear on Windows devices for so long. And due to this error, you are unable to open the application. To fix this error, you can follow this guide: Fix Libmysql.dll Missing Error on Windows 10
Here, you will get a list of various solutions. So, try each of them and at least one of them will definitely going to help you in fixing the error.
Good Luck!!