To all the guys using Windows OS and want to use mysql as your database: I went around all the forums of ruby that I could find on the internet and I'm glad I got the answer that I was looking for:
The path that I was looking for was G:\Ruby\bin. Ignore the wording 'add that path to the environment variable called PATH' cos it's just not in laymen's term for me. All I needed to do was to copy the files from G:\Rails\mysql\bin directory (windows explorer) to the directory G:\Ruby\bin as they are. I had to look for the file libmySQL.dll from google and download it as this was missing when I installed mysql from the command 'gem install mysql'. I copied all the files including mysql.exe, mysqladmin.exe and libmySQL.dll to the directory G:\Ruby\bin. These files are also available from the directory where you installed mysql on its own. Then I tried again the command mysql -v and I got ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) Now I knew I was close to solving the problem, so I knew it is the logging in issue that's left to be solved. so I typed in mysql -u root --password=*** music_library_development and I got: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 to server version: 5.1.36-community Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Hooray! Thanks to all the guys that helped in this forum - just bear in mind that some of us are beginners and do not know all the ruby terms so we need plain old English to survive ;) On Aug 7, 11:31 pm, Jeff <[email protected]> wrote: > I'll try again.... > > Walt, when you say that this happened: > > G:\Rails\rails_apps>mysql-v > and I get the error: > 'mysql' is not recognized as an internal or external command, > operable program or batch file. > > then it means that Windows is telling you that it can't find the > "mysql" program, right? > > And if that's true, then Ruby also has no way to talk tomysql > either. Hence all the advice about making sure that themysql.exe is > in your PATH. If you're not sure how to findmysql.exe or adjust your > PATH, you'll need to ask for basic Windows help, which is beyond the > scope of this forum > > However, assuming this all makes sense to you now, I'd suggest: > > 1. Adjust your PATH so that you can successfully run "mysql-v" > 2. Re-installing themysqlgem: hopefully now it can find themysql.exe binary > in your path > > Does that make sense? > > Thanks > Jeff > > purpleworkshops.com > softiesonrails.com > pragprog.com/titles/cerailn > > On Aug 7, 2:32 pm, WalT <[email protected]> wrote: > > > > No, he means the directory wheremySQLis installed. > > > I mentioned above that there's a bin folder in the directory where > >mysqlis installed: G:\Program Files\MySQL > > \MySQLServer 5.1. > > > That comment is > > > > >> telling you to add that path to the environment variable called PATH > > > > > I don't understand what you are saying here. Sorry I'm new to RoR. > > > > This has nothing to do with Rails. It's a basic Windows (and Un*x) > > > concept. Go learn about it; this is elementary and you need to know. > > > I disagree - this is not a windows concept. It's a ruby concept. Can > > someone else please help me to usemysqlwith ruby? I can see that > > under directory G:\Rails\rails_apps\music_library\config there's a > > file called environment.rb and its contents are: > > > # Be sure to restart your server when you modify this file > > > # Specifies gem version of Rails to use when vendor/rails is not > > present > > RAILS_GEM_VERSION = '2.3.3' unless defined? RAILS_GEM_VERSION > > > # Bootstrap the Rails environment, frameworks, and default > > configuration > > require File.join(File.dirname(__FILE__), 'boot') > > > Rails::Initializer.run do |config| > > # Settings in config/environments/* take precedence over those > > specified here. > > # Application configuration should go into files in config/ > > initializers > > # -- all .rb files in that directory are automatically loaded. > > > # Add additional load paths for your own custom dirs > > # config.load_paths += %W( #{RAILS_ROOT}/extras ) > > > # Specify gems that this application depends on and have them > > installed with rake gems:install > > # config.gem "bj" > > # config.gem "hpricot", :version => '0.6', :source => "http:// > > code.whytheluckystiff.net" > > # config.gem "sqlite3-ruby", :lib => "sqlite3" > > # config.gem "aws-s3", :lib => "aws/s3" > > > # Only load the plugins named here, in the order given (default is > > alphabetical). > > # :all can be used as a placeholder for all plugins not explicitly > > named > > # config.plugins = > > [ :exception_notification, :ssl_requirement, :all ] > > > # Skip frameworks you're not going to use. To use Rails without a > > database, > > # you must remove the Active Record framework. > > # config.frameworks -= > > [ :active_record, :active_resource, :action_mailer ] > > > # Activate observers that should always be running > > # config.active_record.observers > > = :cacher, :garbage_collector, :forum_observer > > > # Set Time.zone default to the specified zone and make Active Record > > auto-convert to this zone. > > # Run "rake -D time" for a list of tasks for finding time zone > > names. > > config.time_zone = 'UTC' > > > # The default locale is :en and all translations from config/locales/ > > *.rb,yml are auto loaded. > > # config.i18n.load_path += Dir[Rails.root.join('my', 'locales', '*. > > {rb,yml}')] > > # config.i18n.default_locale = :de > > end > > > Please guys I already know how to usemysqlsyntax to "talk" to a > > database, I just don't know how to "tell" ruby to usemysqlinstead of > >sqlite3. > > > Thanks > > > On Aug 7, 3:54 pm, Marnen Laibow-Koser <rails-mailing-l...@andreas- > > > s.net> wrote: > > > WalT wrote: > > > > Somewhere inside themysqldirectory > > > > > Do you meanmysqlfolder under G:\Rails\rails_apps\music_library? This > > > > is where I'm running my music_library application. > > > > No, he means the directory wheremySQLis installed. > > > > > That comment is > > > >> telling you to add that path to the environment variable called PATH > > > > > I don't understand what you are saying here. Sorry I'm new to RoR. > > > > This has nothing to do with Rails. It's a basic Windows (and Un*x) > > > concept. Go learn about it; this is elementary and you need to know. > > > > > OK I've tried: > > > > > G:\Rails\rails_apps\music_library>rubymysql-v (since I noticed on > > > > windows one has to type 'ruby' first to run some commands. > > > > > and I get: > > > > ruby: Permission denied --mysql(LoadError) > > > > That won't help. ThemySQLserver is not a Ruby script. > > > > (But in my opinion, you shouldn't usemySQL. PostgreSQL is a much > > > better database server. For most projects, there is no reason at all to > > > even considermySQL.) > > > > Best, > > > -- > > > Marnen Laibow-Koserhttp://www.marnen.org > > > [email protected] > > > -- > > > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
