CODEWITHSUNDEEP
mysqlmacosmampmysql-8.0
shahmanthan9
shahmanthan9

Reputation: 523

Upgrading to MYSQL 8 - MAMP

I have installed MAMP on my MAC machine and I am trying to upgrade it to use MySQL 8. However, I am not having any luck. I have tried following script but database migration fails.

Also, sequelPro fails to connect to DB but, phpmyadmin has no issue connecting.

#!/bin/sh

curl -OL https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.17-macos10.14-x86_64.tar.gz
tar xfvz mysql-8.0.*

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-8.0.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe 

echo "copy share"
sudo rsync -arv --progress mysql-8.0.*/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 -u root --password=root -h 127.0.0.1

Upvotes: 17

Views: 17077

Answers (2)

Dan
Dan

Reputation: 9468

When this question was posted MAMP did not support MySQL 8.

There is support for MySQL 8 now and with Mamp PRO I was able to get things configured properly directly in MAMP.

First MAMP Pro Settings > Server > MySQL tab. I selected the following settings: enter image description here

Then to open my local DB I go to the MAMP Pro Databases tab, highlight a database, and then click "Open In" and choose my desired DB program.

enter image description here

Upvotes: 0

Pratik Shah
Pratik Shah

Reputation: 71

As MySQL 8 having more feature introduce and one of them is Authentication, as you stated that using phpmyadmin you are able to connect while using sequelPro fails. One settings require to perform on my.cnf file as stated below. After that you can restart your mysql service and check also make sure that your root user can be accessible with proper host with password and grant already set up.

[mysqld]
default-authentication-plugin=mysql_native_password

Please let me know does this solve your problem.

Upvotes: 1

Related Questions