MAMP Pro & MySQL 8.0?

[andytela]

Are there any “half way idiot proof” instructions online how to get PHP 8 + working with MAMP 6.8.1

I used brew to install it
https://blog.akasu.de/blog/mysql-8-or-m ... mp-pro-6-x

Set my MySQL port in MAMP to 3307 so theres no conflict
Then in your wp-config just use this

Code: Select all

define( 'DB_HOST', '127.0.0.1:3306' );

[Chacapamac]

How to use this for other CMS than WP, How to make it work with Joomla?

[paurray]

Thanks for posting this suggestion. Just saw it now. Will need to put my thinking cap and do some tinkering.

Also looking at the Joomla path!

Off the top of my head I guess that this workflow is just plugging MAMP into another MySQL data base management system that is not “managed/maintained” inside MAMP. And that once the connection has been made/re routed it should be business as usual inside MAMP just with a working up to date version of MySQL with Wordpress, Joomla what ever?

[Pixel]

I am just moving over to Laravel Herd for local Server and DBEngin for local database.
https://herd.laravel.com/ + https://dbngin.com/

Both are free in the basic versions which should cover most of the needs if you want to develop for WP or Joomla locally. The setup is straightforward, even if a little less convenient, simply because mamp came with everything in one package.

There are tutorials on how to setup a simple environment with php + mysql + phpmyadmin. you should be ready to switch in 1 hours max.

[paurray]

This really helped me


Really like Herd but still on the fence. Not really doing any of this on a pro level more like semi pro

[jerome@64]

Are there any “half way idiot proof” instructions online how to get PHP 8 + working with MAMP 6.8.1

I used brew to install it
https://blog.akasu.de/blog/mysql-8-or-m ... mp-pro-6-x

Set my MySQL port in MAMP to 3307 so theres no conflict
Then in your wp-config just use this

Code: Select all

define( 'DB_HOST', '127.0.0.1:3306' );

Hi everyone,
I would like to install Moodle which requires the installation of MAMP...

I am looking for a solution to make MAMP work with mysql version 8.
I have just carried out the previous actions recommended by Andytela, but I cannot carry out this action :
"Then in your wp-config just use this

Code: Select all

define('DB_HOST', '127.0.0.1:3306');

"

or to you have a new solution ?
thank you for your help

[ghostridertc]

I recently started using Laravel and the app requires MySQL 8 which MAMP PRO doesn't offer but I used a Docker container and it works fine. Keeps it really simple and runs in its own container and doesn't affect the host.

I ran the following commands below to create the container, then used DBeaver to login and setup DB users and import a database and voila. All running smooth. This command maps port incoming port 3307 to the docker container image so it won't cause a conflict if your MySQL is running on 3306. To backup the DB just dump it.

docker pull mysql:8.4
docker run --name mysql8.4 -e MYSQL_ROOT_PASSWORD=root -d -p 3307:3306 mysql:8.4