Highest scored 'macos+mysql' questions

416 votes

17 answers

590k views

brew install mysql on macOS

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysql_install_db. However when I try to connect to the ...

nikola

5,346

asked Dec 5, 2010 at 13:57

338 votes

40 answers

625k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' [duplicate]

I installed MySQL on Mac OS X Mountain Lion with homebrew install mysql, but when I tried mysql -u root I got the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through ...

shrewdbeans

12.3k

asked Mar 16, 2013 at 13:53

264 votes

27 answers

587k views

Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed ...

madaura

2,641

asked Jun 24, 2011 at 23:37

258 votes

24 answers

353k views

How do you stop MySQL on a Mac OS install?

I installed MySQL via MacPorts. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)?

Laurie Young

138k

asked Sep 19, 2008 at 10:21

240 votes

16 answers

629k views

How to start MySQL server from command line on Mac OS Lion?

I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start from command-line. I do as follows: After ...

vietstone

8,964

asked Oct 28, 2011 at 10:05

237 votes

34 answers

459k views

Location of my.cnf file on macOS

I'm trying to follow along this tutorial to enable remote access to MySQL. The problem is, where should my.cnf file be located? I'm using Mac OS X Lion.

nicolas

2,630

asked May 25, 2012 at 15:26

230 votes

16 answers

275k views

How do you uninstall MySQL from Mac OS X?

I accidentally installed the PowerPC version of MySQL on my Intel Mac in Snow Leopard, and it installed without a problem but of course doesn't run properly. I just didn't pay enough attention. Now ...

Joseph Ravenwolfe

6,560

asked Sep 17, 2009 at 2:26

228 votes

23 answers

480k views

Reset MySQL root password using ALTER USER statement after install on Mac

I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else. Now I already reset the password the usual way: update user set password = ...

dengar81

2,505

asked Nov 1, 2015 at 21:18

222 votes

2 answers

44k views

Warning the user/local/mysql/data directory is not owned by the mysql user

I can't start the mysql service in Snow Leopard, and in the panel prefs appears the message, warning the user/local/mysql/data directory is not owned by the mysql user How can I fix this?

Kronos

7,541

asked Apr 3, 2011 at 4:57

221 votes

23 answers

551k views

How to stop mysqld

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get the following output, which allows me to start mysql server. /usr/local/mysql/bin/mysqld --basedir=/usr/...

David542

109k

asked Jun 18, 2012 at 21:33

206 votes

18 answers

302k views

How do I install command line MySQL client on mac?

I want to install the MySQL client for the command line, not a GUI. I have searched over the web but only found instructions on installing the MySQL server.

hch

6,280

asked Jun 22, 2015 at 21:53

186 votes

9 answers

263k views

MySQL user DB does not have password columns - Installing MySQL on OSX

I am trying to change MySql root password. What I have done is below. Install MySql-5.7.6 ~ .dmg(Community Server) and workbench. Turn off the server on OSX System preferences. Access MySql with ...

Juneyoung Oh

7,550

asked Jun 7, 2015 at 11:08

173 votes

29 answers

425k views

Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

I am running a local server of MySQL 5.6.10 on MacOS 10.8.3 and manage my database via Navicat essentials for MySQL. The error I get is that after running and managing my database just fine for a ...

MattMirabilis

1,839

asked Mar 28, 2013 at 23:49

165 votes

27 answers

184k views

MacOSX homebrew mysql root password

For some reason MySQL stopped giving access for root. Uninstalled and reinstalled with Homebrew. Fresh install, fresh tables but when I enter mysql -u root -p I get this error: Access denied for ...

Alisher Ulugbekov

2,089

asked Mar 14, 2012 at 3:07

153 votes

10 answers

184k views

Mac OS X - EnvironmentError: mysql_config not found

First off, yeah, I've already seen this: pip install mysql-python fails with EnvironmentError: mysql_config not found The problem I am trying to use Django on a Google App Engine project. However, ...

daniel_c05

11.5k

asked Aug 23, 2014 at 7:08

128 votes

28 answers

114k views

rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib

I'm just starting out with Ruby (and rails). I did the setup according to http://ruby.railstutorial.org/ruby-on-rails-tutorial-book#sec:ruby gems, using rvm. I have everything working well with sqlite....

George Armhold

31k

asked May 11, 2012 at 19:33

128 votes

3 answers

158k views

How to close this ssh tunnel? [closed]

I opened a ssh tunnel as described in this post: Zend_Db: How to connect to a MySQL database over SSH tunnel? But now I don't know what I actually did. Does this command affect anything on the server?...

Jacob

1,793

asked Feb 25, 2012 at 19:18

127 votes

36 answers

313k views

MySQL Database won't start in XAMPP Manager-osx

I downloaded XAMPP about a month ago and it was working just fine. Today I installed a voice recognition software and then restarted my computer. Ever since, MySQL won't start in my manager-osx ...

nitrous

1,727

asked Jan 21, 2014 at 19:13

102 votes

12 answers

156k views

Easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion)?

What is the easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion)? I'd prefer to use any bundled versions before resorting to downloading from the PHP ...

Matt Sephton

3,950

asked Aug 18, 2009 at 12:18

100 votes

14 answers

201k views

How to install MySQLdb (Python data access library to MySQL) on Mac OS X?

How do I get MySQLdb working on Mac OS X?

mblackwell8

3,065

asked Sep 19, 2009 at 12:04

95 votes

8 answers

309k views

Find out where MySQL is installed on Mac OS X

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?

weaveoftheride

4,325

asked Apr 22, 2013 at 10:08

94 votes

21 answers

155k views

Mysql password expired. Can't connect

I just wiped my Mac and did a fresh install of El Capitan. I'm struggling to connect to Mysql now. Having gone through a web server setup process, I've created a simple PHP test file: <?php $...

CaribouCode

14.3k

asked Oct 28, 2015 at 9:56

94 votes

8 answers

155k views

Connect to Docker MySQL container from localhost?

I have a docker mysql image running, following is what the docker-compose.yml file looks like: db: image: mysql environment: MYSQL_ROOT_PASSWORD: "" MYSQL_ALLOW_EMPTY_PASSWORD: yes ...

Caleb

3,762

asked Sep 2, 2015 at 18:34

93 votes

10 answers

176k views

MySQL data directory location

I installed MySQL on a Mac after downloading its DMG file version 64 bit. While trying to create a database it gave me error 1006 -- can't create database. After browsing a number of website, it seems ...

iwan

7,509

asked Sep 18, 2011 at 2:23

91 votes

14 answers

419k views

Mac install and open mysql using terminal

I downloaded the mysql dmg file and went through the wizard to run. Done. I have also started mysql server under system preferences. The purpose of me doing this is to work through the exercises of my ...

Doug Fir

20.8k

asked Jan 9, 2013 at 12:37

90 votes

13 answers

152k views

Cannot find mysql.sock

I just had to re-install mysql and I am having a problem starting it up. It cannot find the socket (mysql.sock). The problem is that neither can I. In my Mac OS X 10.4 terminal, I type: locate ...

Tony

19k

asked Apr 14, 2009 at 16:57

88 votes

6 answers

105k views

Is it possible to install only mysqldump on macOS

Is it possible to install only mysqldump on macOS without MySQL itself. I'm using MySQL db via Docker, but can't dump the DB from my local machine via MySQL Workbench. /Applications/MySQLWorkbench....

D.R.

2,768

asked Nov 19, 2017 at 18:29

87 votes

14 answers

106k views

Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on OSX

I have a standard Rails3 environment, RVM 1.2.9, Rails 3.0.5, Ruby 1.9.2p180, MySQL2 Gem 0.2.7, mysql-5.5.10-osx10.6-x86_64 Error I get when running rake db:migrate to create database is: Can't ...

Jamie Buchanan

3,918

asked Mar 31, 2011 at 11:24

80 votes

15 answers

113k views

MySQL Install: ERROR: Failed to build gem native extension

I'm trying to get MySQL installed to the latest version due to some installation going wrong somewhere along the line. I run the command gem install mysql and I receive the following: Building ...

Kieran Senior

18.2k

asked Jan 30, 2010 at 10:50

78 votes

5 answers

62k views

How to auto-load MySQL on startup on OS X Yosemite / El Capitan

After upgrading OS X my install of MySQL stopped loading on startup. This walk-through on MySQL says: "The Startup Item installation adds a variable MYSQLCOM=-YES- to the system configuration ...

Justin

27k

asked Oct 20, 2014 at 23:06

70 votes

15 answers

104k views

Unable to access MySQL after it automatically generated a temporary password

I have erased and installed OSX 10.11 El Capitan and I have been following through this tutorial to get MySQL up and running on the new OS X. The first step was to download MySQL For Mac OS X 10.9 (...

Cheetah Felidae

999

asked Oct 25, 2015 at 4:04

69 votes

7 answers

26k views

Mysql not starting in a docker container on MacOS after docker update

I just upgraded to Docker Desktop 2.4 on MacOS, from version 2.3. Suddenly none of my mysql containers will start. The logs show this as the reason: Different lower_case_table_names settings for ...

Cully

6,836

asked Sep 30, 2020 at 22:54

69 votes

2 answers

24k views

What user should own /usr/local/mysql on Mac?

What should the file owner & group be of /usr/local/mysql and all contained files & directories? MySQL was working fine, but after I did sudo chown -R $USER:staff /usr/local to install ...

ma11hew28

125k

asked Jan 21, 2011 at 18:42

68 votes

18 answers

111k views

MySQL does not start when upgrading OSX to Yosemite or El Capitan

I know similar questions exist, such as MySQL with MAMP does not work with OSX Yosemite 10.10. However, I do have MAMP, nor XAMPP installed on my computer. When I try to start mySQL from the PrefPane,...

Adam_G

7,707

asked Sep 20, 2014 at 23:25

65 votes

7 answers

57k views

Python: MySQLdb and "Library not loaded: libmysqlclient.16.dylib"

The setup... Trying to set up a clean Mac os X 10.6 install to develop python/django and I didn't remember running into this on 10.5. After installing MySQL from the installer on mysql-5.5.8-osx10.6-...

rennat

2,539

asked Dec 30, 2010 at 3:01

59 votes

9 answers

42k views

results grid not showing on mysql workbench 6.3.9 for macOS sierra

At firs it was working alright, but out of the blue it disappeared, and there is no way to bring it back. Note the gray area with the Apply and Revert buttons, where the results grid should be. I ...

Martin Ocando

924

asked Aug 30, 2017 at 18:26

56 votes

8 answers

176k views

How to fix "command not found: mysql" in Zsh

I want to use MySQL with my Rails application. After successfully installing the package and seeing the option to start and stop the server from the Preference Pane, if I execute mysql --version I ...

Aniruddha

3,277

asked Mar 8, 2016 at 2:53

55 votes

7 answers

43k views

MacOSX: autostart mysql on boot

I just installed mysql in terminal through homebrew. Now when I try to connect to mysql it fails, but after I run mysqld it works.. So what I need to do now is run mysqld when I boot my Mac. I've ...

Tim Baas

6,105

asked Nov 4, 2011 at 19:05

53 votes

12 answers

25k views

Can't install mysql2 gem on macOS Sierra

I'm setting up my development environment in the new macOS Sierra . First of all, I installed Rbenv, Ruby (2.3.1), Homebrew and so the latest version of MySQL (5.7.15). $ brew install mysql $ mysql....

Caio Tarifa

6,023

asked Sep 21, 2016 at 13:19

52 votes

6 answers

135k views

Using MySQL in the command line in OS X - command not found?

I'm trying to get MySQL up and running on my Mac OS X 10.9.5. I've installed the latest version 5.6.21 of MySQL Community Server. I've gone to system preferences and started the mysql server, then ...

user1574598

3,861

asked Oct 24, 2014 at 19:19

52 votes

8 answers

69k views

$PATH not being saved after I leave terminal

I just installed mysql server 5.5.20 on my OS X Lion and everything works fine.Now,every time I go into terminal I have to explicitly write: PATH=${PATH}:/usr/local/mysql/bin because is not being ...

Daniel

3,017

asked Feb 3, 2012 at 10:49

47 votes

6 answers

75k views

Getting MySQL working on OSX 10.7 Lion

I'm currently trying to get MySQL working on OSX 10.7 Lion. I tried the brew way: brew install mysql -> cmake -> no problems -> make -> no problems -> make install -> ...

sdepold

6,201

asked Jun 11, 2011 at 17:59

44 votes

5 answers

35k views

Add mysqldump to MAMP (MySQL /w Apache PHP on MacOS X)

I wonder how I can add mysqldump to my MAMP environment. I googled a bit and found only the community MySQL server version. But I do not want to install another MySQL – basically because I want to ...

Matt Bannert

28.1k

asked Jul 16, 2010 at 20:55

44 votes

12 answers

37k views

How to connect MySQL workbench with MAMP PRO?

What is the fix to connect the MySQL Workbench tool with the MAMP PRO MySQL database?

Chris Hough

3,509

asked Sep 7, 2009 at 22:29

43 votes

3 answers

16k views

Warning: The post-install step did not complete successfully when trying to install mysql using brew in Mac OS High Sierra

Trying to install mysql5.7 with brew on Mac OS High Sierra. I have used the following commands: sudo rm -rf /usr/local/var/mysql/ brew install [email protected] brew postinstall [email protected] Got the below ...

N20084753

2,160

asked Oct 5, 2019 at 3:32

42 votes

7 answers

61k views

libmysqlclient15-dev on macs?

Does OSX need an install of libmysqlclient15-dev? I'm trying to compile a gem that is failing and a lot of sources says to install "libmysqlclient15-dev" but I only see this for Linux, not OSX. Am I ...

maccy1

523

asked Dec 7, 2009 at 4:45

39 votes

9 answers

66k views

Restoring deleted 'root' user and password for MySQL

I accidentally deleted the root user on my local dev setup of MAMP/MySQL running on OS X. There are no other users created to get back into MySQL. This is a mild nightmare can't seem to do anything ...

PHPeer

413

asked May 22, 2011 at 1:22

39 votes

7 answers

25k views

mysql2 gem fails to compile with MySQL 5.6.12 on OS X with Homebrew

I updated all the packages I installed with Homebrew. MySQL got upgraded to 5.6.12 (from 5.5.27 or so): $ mysql --version mysql Ver 14.14 Distrib 5.6.12, for osx10.8 (x86_64) using EditLine wrapper ...

Pablo Fernandez

285k

asked Jun 21, 2013 at 14:51

37 votes

5 answers

22k views

brew link mysql did not complete

For some some reason brew does not link mysql and it complains about permission. I chmod the folder to 777 but I am still having the same issues laptop$ brew install mysql Error: mysql-5.5.27 ...

tawheed

5,755

asked Oct 10, 2012 at 5:38

37 votes

4 answers

38k views

MySQL server start issues on Mavericks

I am having difficulty using MySQL on my MacBook, I am trying to start my server using sudo mysqld_safe and this results in the following output: 140131 00:03:02 mysqld_safe Logging to '/usr/local/...

user3144542

599

asked Jan 31, 2014 at 0:09

Collectives™ on Stack Overflow

All Questions

Related Tags