Jump to content
Classifieds Temporarily Unavailable Read more... ×
Sign in to follow this  

Do i have mysql installed on my mac?

Recommended Posts

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

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
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 by Waldo

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.