#!/bin/sh | |
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-macos10.12-x86_64.tar.gz | |
tar xfvz mysql-5.7.18-macos10.12-x86_64.tar.gz | |
echo "Stopping MAMP" | |
sudo /Applications/MAMP/bin/stop.sh | |
sudo killall httpd mysqld | |
echo "Copy Bin" | |
sudo rsync -arv --progress mysql-5.7.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe | |
echo "Copy Share" | |
sudo rsync -arv --progress mysql-5.7.*/share/* /Applications/MAMP/Library/share/ | |
echo "Building Mysql 5.7 Folder" | |
sudo cp -r /Applications/MAMP/db/mysql56 /Applications/MAMP/db/mysql57 | |
sudo rm -fr /Applications/MAMP/db/mysql57/mysql/innodb_* | |
sudo rm -fr /Applications/MAMP/db/mysql57/mysql/slave_* | |
sudo chmod -R o+rw /Applications/MAMP/db/mysql57/ | |
sed -i.bak 's/mysql56/mysql57/g' /Applications/MAMP/Library/bin/mysqld_safe | |
echo "Fixing Access (workaround)" | |
sudo chmod -R o+rw /Applications/MAMP/tmp/mysql/ | |
echo "Starting MySQL" | |
sudo /Applications/MAMP/Library/bin/mysqld_safe --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log | |
echo "Migrate, finaly, to new version" | |
sudo /Applications/MAMP/Library/bin/mysql_upgrade --user=root --password=root --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --force | |
This comment has been minimized.
This comment has been minimized.
Hi,
So there still is some problem with MySQL socket... |
This comment has been minimized.
This comment has been minimized.
I've got the same issue as Avokaado. After running the script, I can't even start mysql server with MAMP. |
This comment has been minimized.
This comment has been minimized.
I "solved" this by installing MySQL 5.7 on Ubuntu server on Virtualbox and using MAMPs Apache & PHP only. |
This comment has been minimized.
This comment has been minimized.
Hi @Avokaado and @vinachang or remove |
This comment has been minimized.
This comment has been minimized.
I had the same problem with the permissions of the My solution was to simply duplicate the |
This comment has been minimized.
This comment has been minimized.
There is a problem with this script and MAMP PRO. MAMP and MAMP PRO share almost all their paths, but MAMP PRO recently moved the data directory from Furthermore the So if you follow these instructions with MAMP PRO you will probably break your MAMP. MySQL will fail to launch because the data folder is empty. To fix this problem use the following commands:
Now you can use the Starting MySQL command. It's running for me, though the update script is throwing a ton of errors, that's a problem to fix for later. |
This comment has been minimized.
This comment has been minimized.
WARNING: Because this script only backs up the MAMP folder and not the MAMP PRO folder, it will not make backups of your databases. I've just found that out the hard way. |
This comment has been minimized.
This comment has been minimized.
I was able to get it working by copying the folder as @julian-tr suggested and then running the last line in the gist. |
This comment has been minimized.
This comment has been minimized.
@david-meza solution worked for me |
This comment has been minimized.
This comment has been minimized.
@david-meza solution also worked for me. Can't believe 5.7 still isn't provided in the MAMP core though. Also it should be noted that after you run the upgrade you need to restart the mysql server or else you'll get information_schema errors when you run queries. You can repro this by opening phpmyadmin, selecting any table and clicking the Browse button. Restarting fixes that. |
This comment has been minimized.
This comment has been minimized.
Couldn't get it to upgrade and when a new MAMP (PRO) release came it crapped all over my efforts. Instead following their instructions and installing a separate copy of MySQL : https://documentation.mamp.info/en/MAMP-PRO-Mac/How-Tos/MySQL/InstallMySQL57/ |
This comment has been minimized.
This comment has been minimized.
Well, starting mysql fails almost silently with the following:
The mysql_error_log.err file is empty. |
This comment has been minimized.
This comment has been minimized.
Solved the problem with a nasty:
I do not understand which user the mysqld process is running from... |
This comment has been minimized.
This comment has been minimized.
I needed to install wget on my osx ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" brew install wget --with-libressl Other than that, worked fine. Using Mamp Pro 4.1.1 |
This comment has been minimized.
This comment has been minimized.
@david-meza, best solution! |
This comment has been minimized.
This comment has been minimized.
@david-meza, excelente!!! |
This comment has been minimized.
This comment has been minimized.
Just tried Mamp pro 4.4 with the latest version : https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-macos10.13-x86_64.tar.gz And works fine :D |
This comment has been minimized.
This comment has been minimized.
Failed for me. zsh: no matches found: /Applications/MAMP/db/mysql57/mysql/innodb_* And when I run migrate mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. |
This comment has been minimized.
This comment has been minimized.
Anyone try upgrading MAMP after this process and fixing things? |
This comment has been minimized.
This comment has been minimized.
work fine!thanks |
This comment has been minimized.
This comment has been minimized.
It works fine mamp 4.5 |
This comment has been minimized.
This comment has been minimized.
@julian-tr 's solution above worked for me
|
This comment has been minimized.
This comment has been minimized.
If it helps I used the following:
|
This comment has been minimized.
This comment has been minimized.
@ronappleton 's code works fine for me. Thanks man! |
This comment has been minimized.
This guide is written having in mind MAMP 4.1.1 and MySQL 5.6. It considers known bugs from 5.6 and also a bunch of suggestions from other Gists.