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

rubyonrails-talk
1

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.

2

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.

3

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