Mysql5 Path

[oldmilwaukee33@…]

When I run python manage.py dbshell I am getting an error message regarding mysql5 not being in my path. I have tried a few things in my settings.py file but I must be setting the path incorrectly. I want to find the correct path to mysql5 & set it in my bash_login file. This should allow mysql5 to be found @localhost in my settings.py file & also have mysql5 in my system path.....

demetrius-fords-macbook-pro-17:jenniwren demet8$ python manage.py dbshell
/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Error: You appear not to have the 'mysql' program installed or on your path.

[ryandesign (Ryan Carsten Schmidt)]

From the error message it appears to be looking for "mysql" rather than "mysql5". "mysql" is located in /opt/local/lib/mysql5/bin; put that in your PATH.

[oldmilwaukee33@…]

Replying to ryandesign@…:

From the error message it appears to be looking for "mysql" rather than "mysql5". "mysql" is located in /opt/local/lib/mysql5/bin; put that in your PATH.

It worked! thank you. For some reason I couldn't get this answer on StackOverflow......

[ryandesign (Ryan Carsten Schmidt)]

Glad you got it working.

[oldmilwaukee33@…]

Hey Ryan quick question. Everything was working fine with my Mysql connection until yesterday. This is the error message I am getting now when I try to login to the server mysql5 -u demet8 -p:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2).

This is my current path via bash_login: export PATH="opt/local/bin:/opt/local/bin/mysql5/bin:/opt/local/Library/Frameworks/Python.framework/Versions/Current/bin:/opt/local/bin:/usr/local/bin:/usr/local/sbin:$PATH"

I updated Macports and my Portfiles after I started getting the error message & the update when good but I am still getting the ERROR message. Any suggestions?

[ryandesign (Ryan Carsten Schmidt)]

Is mysqld actually running, and does its socket file exist at /opt/local/var/run/mysql5/mysqld.sock?

[oldmilwaukee33@…]

I downloaded mysqld sometime ago & it was running fine. I looked in /opt/local/var/run/mysql5/mysqld.sock? & the mysql5 folder is completely empty. No files of any kind are located in the mysql5 folder.....

[ryandesign (Ryan Carsten Schmidt)]

Ok, so there is no socket file. Is mysqld running? If not, start it; if it's already running, stop and restart it. Do you have a socket file there now? If not, do you have the socket file somewhere else? Perhaps you told MySQL to put the socket elsewhere by changing a setting in your my.cnf?

[oldmilwaukee33@…]

@ Ryan this is what I did. sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock. I had to add a symbolic link to mysql5 mysqld.sock. Then I re-started mysql. It worked before without all this so I am not sure what really happened. Thanks again for helping me.