# Problem in accessing MySQL

**URL:** <https://www.ruby-forum.com/t/problem-in-accessing-mysql/168915>\
**Category:** Ruby\
**Created:** [May 27, 2009, 11:16am UTC](https://www.ruby-forum.com/t/problem-in-accessing-mysql/168915 "2009-05-27T11:16:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bhaskar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/f4b2a3/32.png) [@bhaskar](https://www.ruby-forum.com/u/bhaskar)\
**Post date:** [May 27, 2009, 11:16am UTC](https://www.ruby-forum.com/t/problem-in-accessing-mysql/168915/1 "2009-05-27T11:16:03Z")

</div>

Hi,  
I’m new to ruby and facing the following problem in connecting to MySQL  
from my script.

Here is the script:  
#!/usr/bin/ruby -w  
#~ # simple.rb - simple MySQL script using Ruby DBI module  
gem “mysql”  
gem “dbi”  
require “dbi”  
#~ gem ‘dbd-mysql’  
begin  
# connect to the MySQL server  
dbh=DBI.connect(“DBI:Mysql::”, “user”,  
“password”)

```
 # get server version string and display it
 row = dbh.select_one("SELECT VERSION()")
 puts "Server version: " + row[0]

```

rescue DBI::DatabaseError =\> e  
puts “An error occurred”  
puts “Error code: #{e.err}”  
puts “Error message: #{e.errstr}”  
ensure  
# disconnect from server  
dbh.disconnect if dbh  
end

Here is the error:

> ruby simple.rb  
> c:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:294:in  
> `load_driver': Unable to load driver 'Mysql' (underlying error: uninitialized constant DBI::DBD::Mysql) (DBI::InterfaceError) from c:/ruby/lib/ruby/1.8/monitor.rb:242:in`synchronize’  
> from c:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:236:in  
> `load_driver' from c:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:154:in`\_get\_full\_driver’  
> from c:/ruby/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:139:in  
> `connect’  
> from simple.rb:10  
> Exit code: 1