Hull v Blades

[Waldo]

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?

[Ghozer]

You could try..

type -a mysql

it's usually located in /usr/bin/mysql

By default, MySQL is not installed as part of OSX

[Waldo]

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