Couldn't find database client: mysql, mysql5, mysql.exe, mysql5.exe. Check your $PATH and try again.

Greetings,

I am trying to get MySQL to run with Rails, but when I try to get it to
run using "rails dbconsole" I get this error:

C:\IS410\Programs\sqltest3>rails dbconsole
Couldn't find database client: mysql, mysql5, mysql.exe, mysql5.exe.
Check your
$PATH and try again.

I have MySQL installed, along with the MySQL driver. I read alot of
posts in forums saying it might not be in my $PATH. Where is this $PATH
so I can look to make sure MySQL is in there. Thank you!

Here is my database.yml.

# MySQL. Versions 4.1 and 5.0 are recommended.

To be able to use "rails dbconsole", mysql.exe needs to be in the
PATH.

Doing "rails dbconsole" is exactly the same as doing to MySQL Console
Client shortcut that should have been installed in your system.

If not, you can add the location of your MySQL installation (where
mysql.exe lives) to the PATH doing the following on a console:

SET PATH=%PATH%;C:\path\to\mysql

However, to avoid issues with spaces and such, I recommend you use the
MySQL Console Client shortcut.

Thank you Luis. Using SET PATH fixed the issue with rails dbconsole.