swydell
swydell

Reputation: 2022

I can't access phpmyadmin with mamp

I have MAMP installed on my Mac Book Pro OS 10.6.8. The open start page on my MAMP is grayed out now. The Apache server button is green. The MySQL server button is red.

At one time I could access phpmyadmin. I have my php files in htdocs folder of MAMP that I can access in localhost:8888/filename.php. I want to create another database and table but I can't access phpmyadmin. I even downloaded phpmyadmin to my desktop but I don't know how to open it. Any suggestions

Upvotes: 12

Views: 39369

Answers (6)

ozbassplayer
ozbassplayer

Reputation: 71

The only way I was able to fix this was to reinstall MAMP Pro.

Upvotes: 0

Jon
Jon

Reputation: 1328

I had to go to the Mamp website

and download the latest version then reinstall it to get things working again. This had the advantage of also giving me the cloud options and upgrading MySql but But you do have to remember your default directory and preferred ports if you want to use the ones that you had before. I hope this helps?

Upvotes: 0

brentlightsey
brentlightsey

Reputation: 2066

On the latest version of MAMP (4.1.1), the default option in the settings was set to "PHP 7.1.1". After I set the default option to 7.0.15, the PHPmyAdmin tools were no longer grayed and worked fine.

Screenshot of PHP tab of MAMP preferences

Upvotes: 35

user3349250
user3349250

Reputation: 311

I had the same or similar issue where PHPMyAdmin was greyed out after installing MAMP 3.5. I checked the PHP version and it was set to 5.2, so I just bumped it up to 5.6 and the my PHPmyAdmin icon became active.

Hope that helps.

Upvotes: 2

Fisu
Fisu

Reputation: 3324

I encountered this issue after migrating my MAMP installation from one machine to another. The problem occurred due to permission issues on the MAMP directory.

To grant permission:

  1. Locate the MAMP directory in Finder
  2. Ctrl-click > Get Info
  3. Under Sharing & Permissions, if your username is not visible, click + and select your username
  4. Ensure Privilege shows Read & Write
  5. Click Apply to enclosed items from the settings icon

Upvotes: 0

Alex Coplan
Alex Coplan

Reputation: 13361

I often get MAMP giving me the red light for MySQL.

Every time I fixed it by quitting every instance of the mysqld process.

Check in Activity Monitor for multiple instances of that process running - if there are, then that is your problem. Quit them all, and restart MAMP.

Activity monitor can be found in Applications > Utilities > Activity Monitor.app. - Search for mysqld in the search box in the top right of activity monitor, and if there are multiple instances running, quit them all.

If not, try quitting the process anyway and restart MAMP.

Update: Easier way to perform this:

$ killall mysqld

From terminal.

Upvotes: 10

Related Questions