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

[beugelaar]

Hello,

I hope I can help you to get Mamp Pro 5.06 & MySql 8.4 to work in Windows.
Assuming you have a full working Mamp Pro 5 with MySQL 5.7, first thing to do is make a backup of your MySQL 5.7 database (if needed).
During testing it maybe helpfull to open an Administrator Command window and put this command in it: taskkill /F /IM mysqld.exe in case you have problems replacing files etc.
Before going further it is necessary to close Mamp Pro 5 (stop running services and exit, check the systray).

*** BEFORE GOING FURTHER, IF YOU WANT TO KEEP YOUR DATA BE SURE YOU HAVE MADE A BACKUP ***

STEPS:

1. Download MySQL Community Server 8.4.5 LTS, ZIP Archive (link: https://dev.mysql.com/downloads/file/?id=539262)
2. Unzip it in a download folder and rename it to mysql8
3. Copy all files from your downloaded mysql8 folder to folder C:\MAMP\bin\mysql and replace all files
4. Delete all files in folder C:\MAMP\db\mysql
5. Open my.ini from folder C:\MAMP\conf\mysql
6. In section [mysql] do the following:
Change: character-set-server=utf8 => character-set-server=utf8mb4
Change: collation-server=utf8_general_ci => collation-server=utf8mb4_general_ci
Change: #innodb_flush_log_at_trx_commit = 1 => innodb_flush_log_at_trx_commit = 1
Add: mysql_native_password = ON
7. Save my.ini
8. Open an Administrator Command prompt and goto folder C:\MAMP\bin\mysql\bin
9. Execute: mysqld --initialize --datadir="C:\MAMP\db\mysql" --console
10. In the console you will see a temporary password is generated for root@localhost. Write down or copy this password. (eg. _Ve&xIhG-2CR)
11. Execute: mysqld --defaults-file="C:\MAMP\conf\mysql\my.ini" --console
12. MySQL is now running. Open a new Administrator Command prompt and goto folder C:\MAMP\bin\mysql\bin
13: Excecute: mysql -u root -p (fill in the password from step 10)
14: Excecute: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
15: Close the database by typing quit <enter> and close the command prompt window
16: Close the command window from step 11.

17: Start MAMP PRO 5 and stop all running services
18: Open template MySQL (my.cnf) via menu File -> Open Template
19: In section [mysql] do the following steps:
Change/check: datadir = MAMP_datadir_MAMP => datadir = C:/MAMP/db/mysql/
Change/check: character-set-server=utf8 => character-set-server=utf8mb4
Change/check: collation-server=utf8_general_ci => collation-server=utf8mb4_general_ci
Change/check: skip-ssl=1 => #skip-ssl=1
Change/check: #innodb_flush_log_at_trx_commit = 1 => innodb_flush_log_at_trx_commit = 1
Add/check: mysql_native_password = ON
20: Save my.ini
21: Start.

Start phpMyAdmin and everything shoud be working fine with MySQL 8.4.
Dismiss the version notice of 5.7.24.

Good luck!
Erik