MAMP (macOS) Documentation
The default MAMP WebStart page provides links to access utilities such as phpMyAdmin, phpInfo, SQLite Manager, phpLiteAdmin and the MAMP website.
Tools
phpInfo
phpInfo shows you information about PHP configuration.
phpMyAdmin
phpMyAdmin is a web-based database administration tool written in PHP. Your MAMP instance of phpMyAdmin can be accessed through a link in the WebStart page Additional MySQL users can be created using the User Accounts tab.
phpLiteAdmin
phpLiteAdmin is a web-based SQLite database administration tool written in PHP with support for SQLite3 and SQLite2.
APC
The Alternative PHP Cache (APC) is a free and open opcode cache for PHP. You can learn more about APC here.
eAccelerator
eAccelerator a free open-source PHP accelerator & optimizer. You can learn more about eAccelerator here.
XCache
XCache is a open-source opcode cacher. You can learn more about XCache here.
OPCache
OPcache improves PHP performance by storing precompiled script bytecode in shared memory, thereby removing the need for PHP to load and parse scripts on each request. You can learn more about OPcache here.
Tools
Documentation
A click on this menu item opens the documentation for MAMP.
Screencasts
A click on this menu item opens our channel on YouTube. There you will find numerous screencasts about MAMP.
Bugbase
A click on this menu entry takes you to the bugbase. If you have found a bug in the software, you can enter it there and we will fix it as soon as possible. Of course you can also enter suggestions for improvement or wishes there.
Examples
Several examples show how to connect to the databases (MySQL, SQLite) using PHP, Python, Perl and Ruby. Examples for the connection to SQLite are available in PHP.
How to configure phpMyAdmin from the MAMP installation to use an actual MySQL root password?
After changing the default password for the MySQL root user, we should not forget to edit the phpMyAdmin configuration file. But how do this if we use the MAMP app from appsolute GmbH for local web development on our macOS device. In this tutorial, I’ll show you how to configure phpMyAdmin from the MAMP installation to use an actual password of the MySQL root user.
I’m using version 5.1 of the MAMP app, but in your case there can be any other version of the MAMP app. If you use the non-standard version of the app, but the PRO one, then in the following steps, replace “MAMP” with “MAMP PRO”, respectively.
Let’s begin
All we need to do is edit the phpMyAdmin configuration file from the MAMP installation. This is a really easy process. To do this we have two methods. The first method is using Finder and the TextEdit app, and the second is using the Terminal app. Use the one that is convenient for you. Now, step by step guide.
In this solution we will use the Finder and the TextEdit app. You do not need to download and install anything, because it is already built into every macOS.
If the MAMP app is running, click the Stop Servers button and quit the app.
In the Finder, go to the folder Applications -> MAMP -> bin -> phpMyAdmin .
Open the file config.inc.php in a text editor. As a text editor, I use the TextEdit app, but you can use any other editor. The contents of the file may seem complicated in understanding, but do not worry, we will not change a lot of things.
Replace ‘root’ with an actual password of the MySQL root user.
Save the changes and close the file config.inc.php .
Launch MAMP and click the Start Servers button.
The phpMyAdmin web page located at localhost/phpMyAdmin/index.php .
This is another method to do the same thing as in the previous solution (№1), but with use the Terminal app. You do not need to download and install anything, because it is already built into every macOS.
If the MAMP app is running, click the Stop Servers button and quit the app.
Launch the Terminal app from the Utilities folder of your Applications folder, or use Spotlight to find it.
The contents of the file may seem complicated in understanding, but do not worry, we will not change a lot of things.
Replace ‘root’ with an actual password of the MySQL root user.
Save the changes and close the file config.inc.php .
Launch MAMP and click the Start Servers button.
The phpMyAdmin web page located at localhost/phpMyAdmin/index.php .
Conclusion
That’s it, you’re done. Now you have configured phpMyAdmin to use an actual password of the MySQL root user. So simple isn’t it?
I hope this article has helped you learn how to configure phpMyAdmin from the MAMP installation to use an actual password of the MySQL root user. If this article has helped you then please leave a comment
Thanks for reading!
If this post helped you out and you’d like to show your support, please consider fueling future posts by buying me a coffee cup!
getting to phpmyadmin with mamp
I’m using MAMP, and trying to get to phpmyadmin. loaclhost/phpmyadmin isn’t working.. the sql light is green so it is enabled.
I have changed the Document Root to /Users/troycosentino/Sites/easyuniv/ and when i open the start page from MAMP it is a page created by apple it looks like, not MAMP.
9 Answers 9
If i go to localhost:8888/MAMP it gives me the MAMP screen, from which i can go to phpmadmin.
If MAMP has MySQL Server and Apache Server running.
You can go to phpMyAdmin via url http://localhost/phpMyAdmin/
Try this localhost:8888/MAMP/?language=English
Click on phpMyAdmin tab and you have it.
On Windows pay attention to capital letters:
You can directly access it at the link below, make sure that it contains the same uppercase letters.
Or if you prefer
On macOS MAMP, you need to go to
and from nav-menu choose: tools>PhpMyAdmin
My htdocs folder was only filled with personal projects.
I have no idea WHY this works, but it did for me:
In the httpd.conf folder (do a command + space and search for that if you don’t know what it is already), change your root folder to:
Comment out your OLD document root with a ‘#’, such that it will look like:
Then, repeat those changes for the Directory path:
Stop/Restart MAMP. For good measure, try loading local server in your browser, it shouldn’t work.
Then, undo everything above and change your document and directory roots back to their originals.
Stop/Restart MAMP. Try navigating to localhost/phpmyadmin or localhost:8888/phpmyadmin again.
Not sure exactly why, but it seems to trigger MAMP to behave itself. Hope that helps
Setting up a basic MAMP server
Step 2. Move over your MAMP_MAMP_PRO_3.5.2.pkg file over to your Application Folder.
Step 3. Double click on the package & follow the prompts to install on your computer.
Step 4. Once installed you’ll notice you have 2 folders that say MAMP. For now, we will just be focusing on the free version of MAMP. Within the mamp directory, look for a folder called htdocs
This is where you will be adding your first index.html file.
Your directory structure would look like: /Applications/MAMP/htdocs/index.html
Step 5. Now you’re ready to click on the MAMP icon. If you click on preferences you’ll notice your default Apache Port is 8888. This is important because this is the port your application will be listening to. Now go back and click on Start Servers. If all went well you should have a green server icon and the Apache and MySql Server should show green.
Now you can access your index.html page by navigating to:
You can also get useful information by clicking on the Open WebStart Page Icon. This will let you know your default mySQL user + password and have the link to open up phpMyAdmin.