On Mac OS X the system PATH variable is not recognized by emacs. This means that one can not simply type
mysql
in the emacs shell to get into the database. The emacs shell complains about “binary not found”.
Indeed
echo $PATH
reveals that emacs just looks into /bin, /usr/bin, /sbin and /usr/sbin.
To set the $PATH variable inside emacs one can append the following lines to the .emacs file (found on github, hattip Alex Payne):
; sane path (setq path "/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/mysql/bin") (setenv "PATH" path)
Next time Emacs starts one can go to the shell and
mysql
presents the database prompt.
Rforge 