Mac Manual Mysql

Active1 month ago

How do I find out where MySQL is installed on Mac OS X 10.7.9? I have MAMP installed so I presume that it is bundled with this install?

Jason
8,08221 gold badges75 silver badges105 bronze badges
  1. Installing MySQL on Mac OS X. What follows are instructions for building and installing MySQL 5 on Mac OS X. These instructions should work perfectly on both Tiger and Leopard. If you’re a pro at this type of thing already, if you’re impatient, or just feeling lucky, you can download the basic install steps as a shell script and give that a go.
  2. Nov 10, 2007  Saturday, 10 November 2007. Permalink Update: I’ve posted updated instructions for compiling MySQL on Snow Leopard. What follows are instructions for building and installing MySQL 5 on Mac OS X.These instructions should work perfectly on both Tiger and Leopard.
  3. Check that MySQL Connector Python installation is working and able to connect to MySQL Server by Connecting to MySQL Using MySQL Connector Python. Install MySQL Connector Python on Ubuntu Use the following command to install MySQL connector Python on Ubuntu.
weaveoftheride

This is the MySQL™ Reference Manual. It documents MySQL 5.5 through 5.5.62, as well as NDB Cluster releases based on version 7.2 of NDBCLUSTER through 5.5.61-ndb-7.2.34. It may include documentation of features of MySQL versions that have not yet been released. For information about which versions have been released, see the MySQL 5.5 Release Notes.

weaveoftheride
1,4175 gold badges24 silver badges42 bronze badges

6 Answers

To check MySQL version of MAMP , use the following command in Terminal:

Assume you have started MAMP .

Example output:

UPDATE: Moreover, if you want to find where does mysql installed in system, use the following command:

type -a is an equivalent of tclsh built-in command where in OS X bash shell. If MySQL is found, it will show :

If not found, it will show:

By default , MySQL is not installed in Mac OS X.

Sidenote: For XAMPP, the command should be:

Mac Manual MysqlRaptorRaptor
36.7k33 gold badges184 silver badges308 bronze badges

It will be found in /usr/local/mysql if you use the mysql binaries or dmg to install it on your system instead of using MAMP

DebDeb

If you run SHOW VARIABLES from a mysql console you can look for basedir.

When I run the following:

on my system I get /usr/local/mysql as the Value returned.(I am not using MAMP - I installed MySQL with homebrew.

mysqldon my machine is in /usr/local/mysql/bin so the basedir is where most everything will be installed to.

Also util:

To find where the DBs are stored.

For more:http://dev.mysql.com/doc/refman/5.0/en/show-variables.html

andhttp://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_basedir

fguillen
22.9k13 gold badges90 silver badges151 bronze badges
JasonJason
8,08221 gold badges75 silver badges105 bronze badges

If you downloaded mySQL using a DMG (easiest way to download found here http://dev.mysql.com/downloads/mysql/) in Terminal try: cd /usr/local/

When you type ls you should see mysql-YOUR-VERSION. You will also see mysql which is the installation directory.

Source: http://geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php

shnraj

Mac Manual Mysql Download

shnraj

Mac Manual Mysql Server

1,2611 gold badge8 silver badges4 bronze badges

If you've installed with the dmg, you can also go to the Mac 'System Preferences' menu, click on 'MySql' and then on the configuration tab to see the location of all MySql directories.

Reference: https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html

Safa AlaiSafa Alai
6701 gold badge9 silver badges19 bronze badges

Or use good old 'find'. For example in order to look for old mysql v5.7:

Dzmitry HubinDzmitry Hubin

Macbook Manual

Not the answer you're looking for? Browse other questions tagged mysqlmacos or ask your own question.