This was a common problem with past versions of MAMP and it continues to happen for some users in version 4.x. Fortunately, the fix is easy. The problem is that when exiting MAMP the MySQL processes continue to run and are not stopped. This post has two solutions. The first solution of killing running processes has worked for me pretty much all the time. The second solution is from one of the comments below.
Server: Apache: The Apache HTTP Server Project is an effort to develop and maintain an open-source HTTP server for modern operating systems including UNIX and Windows NT. The goal of this project is to provide a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards.
- Quit MAMP. You may have to force quit when this happens as it does not shut down correctly.
- To show any MySQL processes currently running, open Terminal and from the command prompt run the command below.
- Next, kill the MySQL processes by running the command below.
- To verify they no longer exist, pgrep for mysql again and you should not have any processes returned.
- Now Launch MAMP again and MySQL Server should start normally.
Server Map Path In C#
Alternative Solution
If the above solution does not work, this method should.
- Stop Mamp and kill the mysql processes as above.
- Rename the ib_logfileN (N is the log numbers) files to something else. Don’t delete these as you may need to return to them. The path to these files may be different on your system. On my system, I would do the following:
- Restart MAMP and MySQL should start correctly.
(Thanks to Daniel Erkalo for this alternative fix!)
MAMP is a free distribution package that makes it easy to install Apache Web Server, PHP, and MySQL. Before installing MAMP, you should turn off any other web servers and instances of MySQL you have running on your Windows machine.
- Connect and share knowledge within a single location that is structured and easy to search.
- MAMP Local Server: MAMP is that local server that works compatibly with Mac operating system. It’s an open-source platform that supports; Apache, PHP, MySQL for coding and testing purposes. It will definitely give you all the programs and tools to smoothly run WordPress on your local machine. Since it supports PHP and MySQL, you will be able.
- Download the latest version of MAMP:
- Run the downloaded file (e.g., MAMP_MAMP_PRO_4.1.exe) and click through the installation wizard.
- If prompted, you do not need to install MAMP PRO or Apple Bonjour.
- Accept the License Agreement.
- Leave the default for the installation directory (C:MAMP).
- Leave the default for the Start Menu folder (MAMP).
- Close the wizard when setup is finished.
Running MAMP on Windows
Careful!
What is evernote software. Be very careful to follow these steps exactly. MAMP can be finicky. If something goes wrong, often the easiest thing to do is uninstall MAMP and start the process over again.
To run MAMP..
- Navigate to C:MAMP in Windows Explorer and open MAMP.exe. If you get a security alert, allow access. You should see a window like this one: The servers (Apache Server and MySQL Server) should have automatically started. If they did not, start them by clicking on Start Servers.
- Open MAMP Preferences:
- Change the Apache port to 8888:
- Click on Open WebStart Page: The following page should open in your browser:
Class Files
- After downloading the class files, create a folder in C:MAMPhtdocs named 'Webucator' and extract your class files in that folder:
- Rename the ClassFiles folder to php:
- To test that your setup so far is correct, open your browser and navigate to http://localhost:8888/Webucator/php/. You should get a listing like this:
- Click PHPBasics, then click Demos, and then hello-world.php. You should get a page that looks like this:
Setting the MySQL Password
The PHP files use 'pwdpwd' for the MySQL root password, while the default password used in MAMP is 'root'. In your browser, navigate to http://localhost:8888/phpMyAdmin/.
Note: It is important to do these steps in the order specified.
- Click the mysql database on the left.
- Click the SQL tab at the top.
- Enter the following in the textbox under Run SQL query/queries on database mysql:
- Click Go.
- You also need to update the password in C:MAMPbinphpMyAdminconfig.inc.php. Open the file in your editor (e.g., Visual Studio Code) and change the password setting as show below to 'pwdpwd'.
Installing the poetree Database
Use phpMyAdmin to install the poetree database used in class.
- Click on the Import tab heading
- Click the Choose File button.
- Browse to the poetree-db.sql file in your class files (C:MAMPWebucatorphppoetree-dbsql).
- Click Open:
- Click the Go button on the bottom left of the page.
- You should get a Success message and poetree should be added to your list of Databases.
One Final Test
Point your browser to http://localhost:8888/Webucator/php/Database/Solutions/phppoetry.com/. If you see a page like this, you're all set:
And that's it
Happy MAMPing!
Recommended Code Editor
How To Download Virtual Server Mamp
Visual Studio Code (Download, Install, and Set up VS Code)
Server Mapping Drive
While you may use a different editor or IDE, Visual Studio Code is an excellent IDE to learn to code on. It provides a nice balance of power and simplicity and it is available on Windows and Mac.