Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 860
swydell Avatar asked Dec 28 '11 12:12

swydell


People also ask

Why phpMyAdmin is not working in MAMP?

This might happen if you're running an outdated version of PHP, or a new update is not compatible with your version of MAMP. In this case, you”ll need to change the PHP version of your MAMP application. In MAMP Pro, this is as simple as changing the setting.

How do I access phpMyAdmin in MAMP?

In MAMP, you need to open phpMyAdmin to create a MySQL database. If you have installed MAMP with the default ports, open the Welcome page in your browser (http://localhost:8888/MAMP/), then click the phpMyAdmin link at the top of the screen. The main phpMyAdmin screen will appear.

How do I access phpMyAdmin localhost?

Once phpMyAdmin is installed point your browser to http://localhost/phpmyadmin to start using it. You should be able to login using any users you've setup in MySQL. If no users have been setup, use admin with no password to login.


2 Answers

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

like image 136
brentlightsey Avatar answered Oct 13 '22 01:10

brentlightsey


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.

like image 28
Alex Coplan Avatar answered Oct 13 '22 01:10

Alex Coplan