是否可以将MAMP中的MySQL升级到MySQL 5.7? [英] Is it possible to upgrade the MySQL in MAMP to MySQL 5.7?

问题描述

是否可以将MAMP MySQL库升级到5.7? 我目前正在运行5.6(已使用MAMP的升级脚本升级为5.6 ) 还是我需要在系统上本地安装MySQL? (macOS 10.11 El Capitan)

Is it possible to upgrade the MAMP MySQL library to 5.7? I am currently running 5.6 (which I upgraded to using MAMP’s upgrade script ) Or would I need to install MySQL natively on my system? (macOS 10.11 El Capitan)

如果有人可以指出正确的方向……谢谢！

If someone could point me in the right direction… Thanks!

推荐答案

将MAMP升级到Mysql 5.7

Upgrade MAMP to Mysql 5.7

#!/bin/sh

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10-osx10.10-x86_64.tar.gz
tar xfvz mysql-5.7*

echo "stopping mamp"
sudo /Applications/MAMP/bin/stop.sh
sudo killall httpd mysqld

echo "creating backup"
sudo rsync -arv --progress /Applications/MAMP ~/Desktop/MAMP-Backup

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 "fixing access (workaround)"
sudo chmod -R o+rw  /Applications/MAMP/db/mysql/
sudo chmod -R o+rw  /Applications/MAMP/tmp/mysql/
sudo chmod -R o+rw  "/Library/Application Support/appsolute/MAMP PRO/db/mysql/"

echo "starting mamp"
sudo /Applications/MAMP/bin/start.sh

echo "migrate to new version"
/Applications/MAMP/Library/bin/mysql_upgrade -u root --password=root -h 127.0.0.1

这篇关于是否可以将MAMP中的MySQL升级到MySQL 5.7?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！