Chris Shea wrote:
> On Mar 5, 6:39 pm, Paul Hammer <paul_ham... / hotmail.com> wrote:
>> > installed via the One-Click Installer, you have to.
>>
>> I'm new to gem also.  Is the mswin32 option a command line option to
>> gem?
>>
>> What is the One-Click Installer?  Where can I read about this?
>>
>> Paul
>>
>> --
>> Posted viahttp://www.ruby-forum.com/.
> 
> Paul,
> 
> What I meant was: when you run 'gem install mysql' choose an install
> option with (mswin32) at the end.  So when faced with this:
> 
> Select which gem to install for your platform (i386-mswin32)
>  1. mysql 2.7.3 (mswin32)
>  2. mysql 2.7.1 (mswin32)
>  3. mysql 2.7 (ruby)
>  4. mysql 2.6 (ruby)
>  5. mysql 2.5.1 (ruby)
>  6. Cancel installation
> 
> Choose 1 or 2.
> 
> The Ruby One-Click Installer is found here: 
> http://rubyinstaller.rubyforge.org/wiki/wiki.pl
> It installs Ruby, and sets environment options, and installs a lot of
> helpful tools (like rubygems and the Win32API bindings).  I assumed
> your installation of Ruby was handled by it, many Windows
> installations are.
> 
> The other main possibility is that Ruby is installed on top of Cygwin
> (http://cygwin.com/), but I'm guessing it's not.
> 
> HTH,
> Chris

Hi Chris,

Thanks for your help.  This has gotten me further.  I selected 1. mysql 
2.7.3 (mswin32), and the install completed quickly without an error.

Next, I did a web search and found this example ruby script:

   require "mysql"

   begin
     # connect to the MySQL server
     dbh = Mysql.real_connect("localhost", "testuser", "testpass", 
"test")
     # get server version string and display it
     puts "Server version: " + dbh.get_server_info
   rescue Mysql::Error => e
     puts "Error code: #{e.errno}"
     puts "Error message: #{e.error}"
     puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
   ensure
     # disconnect from server
     dbh.close if dbh
   end

Running this gave me the error:

  Error code: 1045
  Error message: Access denied for user 'testuser'@'localhost' (using 
password: YES)

I have tried searching for where mysql is been installed, and can't find 
it.

Installing mysql in the past I've been able to set the root password.  I
didn't get that chance here.

So, I now have questions:

This is progress because the login has been attempted, right?
What users & passwords come along with a gem install?  How do I set 
these?
I'd like to run mysql by hand also.  Where has mysql been installed?

Paul


-- 
Posted via http://www.ruby-forum.com/.