Connecting mySQL to Ruby on NETBEAN 8.0

[infinite.curve]

So... I hae this issue trying to connect mySQL to ruby on net bean... Has anyone connected it before?

The code:

#!/user/bin/ruby


require 'mysql'


begin
puts "hello World"
con = Mysql.new 'localhost', 'sqluser', ''
puts con.get_server_info
rs = con.query 'SELECT VERSION();'
puts rs.fetch_row

rescue Mysql::Error => e
puts e.errno
puts e.error

ensure
con.close if con
end

LoadError: no such file to load -- mysql
require at org/jruby/RubyKernel.java:1027
require at /Users/eugenelemon/Library/Application Support/NetBeans/8.0/jruby/lib/ruby/shared/rubygems/custom_require.rb:36
(root) at /Users/eugenelemon/NetBeansProjects/RubyApplication1/lib/main.rb:9

 

[Borg]

I'm not a Ruby developer but perhaps this will help.

http://rubylearning.com/satishtalim/ruby_mysql_tutorial.html

 

[Borek]

LoadError: no such file to load -- mysql

Looks like the problem occurs long before you try to connect to the database.

 

[redrails]

Looks like it's a MySQL server issue as it's not able to access the database file that you're trying to pull.