Waldo   96 #1 Posted December 6, 2018 I thought I had installed it sometime in the past; but, I just typed 'mysql --version' in terminal, and I get 'command not found'.  Maybe the PATH to 'mysql' is not setup correctly, does anyone know where would the mysql executable normally be on a Mac? Share this post Link to post Share on other sites Share this content via...
Ghozer   112 #2 Posted December 6, 2018 You could try.. type -a mysql it's usually located in /usr/bin/mysql By default, MySQL is not installed as part of OSX Share this post Link to post Share on other sites Share this content via...
Waldo   96 #3 Posted December 6, 2018 (edited) 1 hour ago, Ghozer said: You could try.. type -a mysql it's usually located in /usr/bin/mysql By default, MySQL is not installed as part of OSX Yep, it's normally just pre-installed with OSX server. I did install it manually before though, I mean the community server edition from the official mysql website.  Looks like I must have uninstalled; because it wasn't at that location, and no sign of it anywhere on my Mac.  I've just tried installing the latest version; now, bear in mind I'm on OSX Yosemite (10.11.6)...  Latest version, not working. Installs okay; but you go to the mysql preference pane, and try to start the service. It lights up green, then after about 1 second, it goes red (stopped). Sigh.  Tried XAMPP (overkill I think, as I already have apache running on my Mac, with no issues). That won't run; it doesn't like the fact I'm on Yosemite.  Next I tried an older version of mysql from official site; I got the version that was last supported by Yosemite (think it said July 2016). Installed okay. Preference pane reports mysql service running. But...  myphpsql won't connect. Also, I can't connect using the mysql executable in /usr/bin/mysql (./mysql -u root).  Sometimes I feel being an indie developer must be a bit like being a brain surgeon; where you also need to build the hospital, and develop all the medicines and medical technologies that you're going to be using; before you can actually start doing the bit you specialise in! 😕  UPDATE1:  Okay, scratch that! I've managed to connect to mysql using...  ./mysql -u root -p  ...then pasting in my password and hitting enter.  The password was created automatically by the installer and has a hyphen in it, which is confusing the mysql executable.  Now I'm confused as to why myphpsql will not connect...  UPDATE2:  Wonder it there's something in the myphpadmin config.inc.php I need to change? (infact, that file does not exist, only config.sample.inc.php exists).  UPDATE3:  Tried connecting with another client (SequelPro on Mac), and got some error about an expired password, try connecting with a client that supports expired passwords...  Anyhow, managed to change the password in terminal, and that client seems to connect okay now; I'm guessing phpmysql will too (and even if it doesn't, it's no biggie, the other client seems to work okay. Edited December 6, 2018 by Waldo Share this post Link to post Share on other sites Share this content via...