When OSX 10.9 + and MySQL 5.6 Don't Work
source link: https://fuzzyblog.io/blog/mysql/2014/11/06/when-osx-10-9-and-mysql-5-6-don-t-work.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
When OSX 10.9 + and MySQL 5.6 Don't Work
Nov 6, 2014
I recently was traveling and off my trusty home machine and on a new laptop running Mavericks. And I found that when I worked on one of my applications (Hi Jim!), I was getting this error constantly:
Lost connection to MySQL server at 'sending authentication information', system error: 32
That's not a good error. I dug into it and found this Stack Overflow post:
http://stackoverflow.com/questions/17813630/mysql-5-6-headaches-on-mac-osx
And I dug into it and its the classic – OSX is Unix; except its not kind of crap. Sigh. And since MySQL 5.6 defaults to
innodb_file_per_table = ON
If you have any kind of a large mysql installation (and mine are huge) then you're going to have issues. No way around it. So here are the steps to fix it:
Create a my.cnf file in /etc. All it needs is the following: [mysqld] innodb_file_per_table = OFF Then reload mysql. If you’re using home-brew then you need to do this: launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist And this is the worst part — dump your databases and reload. I’m sorry. There’s just no way around it.
Recommend
-
48
下面为最近使用swift 进行 OSX 开发中，对于一些知识点的总结与汇总，主要是跨行过来，很多内容都不太熟悉，所以这里进行一部分的记录与总结，方便日后的回顾与思考，后续有新的也会继续进行补充。 swift 代码同步块
-
67
在 AppDelegate 中，复写 applicationShouldTerminate 方法可以达到控制是否点击关闭按钮是否关闭应用的效果，其返回值 TerminateReply 有三个值，具体如下： publi...
-
45
在 OSX 中有一些列表的需求，这时候需要使用 OSX 中 TableView 来实现，但是这个 TableView 与 Android的 ListView 不太一样。使用还是比较复杂的。下面做一个简单的介绍， TableView 的使用 首先...
-
37
开发设备一般开放 SSH 端口和访问权限就能够满足几乎所有需求，但是如果设备换成了 Windows 或者 OSX ，这个事情就没有那么简单了，偶尔还是需要登录图形界面做一些事情。对于我这种家里局域网有完整开发环境的折腾控，远程...
-
12
Installing Rails 2.6 on OSX and a Creating New Application Aug 17, 2019 So Rails 2.6 has been released and I just went thru the normal update dance. Here's how I handled upgrading my system. Let's start with...
-
15
Your permanent storage for a SAAS app is always one of your single biggest per user costs. There are two ways to get this info – at the SQL layer with a query and at the filesystem layer. Each method is explained. Getting Disc Spac...
-
9
Bash on OSX versus Bash on Ubuntu and Upgrading Your Bash Feb 15, 2017 Bash is one of those things that you just don't think about all that much – until you want something that is apparently new. In my case I...
-
14
Install PHPUnit and Pear correctly on OSX Leopard advertisements I've installed pear using this guide
-
8
TIL - Keda and DataDog don’t work together ...
-
4
Ebola Is Back—and Vaccines Don’t Work Against ItPublic health officials are racing to contain an outbreak in Uganda. It’s an urgent warning to the rest of the world.
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK