|tar xfvz mysql-5.6*|
|echo "stopping mamp"|
|sudo killall httpd mysqld|
|echo "creating backup"|
|sudo rsync -a /Applications/MAMP ~/Desktop/MAMP-Backup|
|echo "copy bin"|
|sudo rsync -av mysql-5.6.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe|
|echo "copy share"|
|sudo rsync -av mysql-5.6.*/share/* /Applications/MAMP/Library/share/|
|echo "fixing access (workaround)"|
|sudo chmod -R o+rw /Applications/MAMP/db/mysql/|
|sudo chmod -R o+rw /Applications/MAMP/tmp/mysql/|
|echo "starting mamp"|
|echo "migrate to new version"|
|/Applications/MAMP/Library/bin/mysql_upgrade -u root --password=root -h 127.0.0.1|
Encountered this issue after update on cli: https://coderwall.com/p/w5kwzw/solved-can-t-connect-to-local-mysql-server-through-socket-tmp-mysql-sock
I`m getting this error:
Mac OS X 10.10.2 & MAMP 184.108.40.206
Changed a couple of things:
Due to incompatible changes coming from 5.5 I also followed this guide: http://mechanics.flite.com/blog/2014/05/01/upgrading-temporal-columns-from-mysql-5-dot-5-to-mysql-5-dot-6-format/
Thanks for the script!
I have mamp pro and I get the folowing error
The problem is that it's using the wrong php version, si if I fix it, it goes on, but then I find other set of errors ending with the problem with the tables, the root password etc...
goliathuy, if you are still having the issue (and for anyone else) go to the /Applications/MAMP/conf/apache/httpd.conf file and edit the line to point to the correct php version active:
LoadModule php5_module /Applications/MAMP/bin/php/php5.6.7/modules/libphp5.so
Got something in the MAMP/logs/mysql_error.log file along the lines of:
[Note] InnoDB: 5.6.24 started; log sequence number XXXXXXXX
It's not working at all.
Looking for 'mysql' as: /Applications/MAMP/Library/bin/mysql
Is this only working with MAMP Pro?
Update: I stand corrected
I got here because I wanted the combination of MAMP simplicity (including the choice between latest PHP5.x and PHP7), but with MySQL >= 5.6.5 (so I can set default values for created_at and updated_at).
Ultimately I successfully used daancart2quote's version above, with three changes:
Hopefully this is helpful to others.
After running this script, I can't launch mamp anymore.
This is error message:
This is error log:
161218 9:39:39 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete
161218 09:39:39 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
161218 9:43:17 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete
161218 09:43:17 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
any idea how to fix?