MAMP issue.

Discussion in 'Web Design and Development' started by JakeGWood, Jul 12, 2011.

Most Liked Posts
  1. JakeGWood, Jul 12, 2011

    JakeGWood macrumors newbie

    Joined:
    Jul 3, 2011
    #1
    I just started learning MySQL and PHP and am using MAMP. My book (O'Reilly, PHP, MySQL and JScript) recommended that I switch the default ports to 80 and 3306 for apache and MySQL. However, when I did that, on the startup menu for MAMP the status box gives the green light for the Apache server, but red light for the MySQL. I tried switching back to 8888 and 8889, MAMP's defaults, but no luck, and I did have two green lights before.

    Any ideas? Thanks
     
    share
    + Quote Reply
  2. JakeGWood, Jul 13, 2011

    JakeGWood thread starter macrumors newbie

    Joined:
    Jul 3, 2011
    #2
    I just downloaded XAMPP and it also can't access the MySQL server. It says XAMPP MySQL can't run while another MySQL is running. Even if I quit MAMP, whose MySQL isn't working anyway, it still gives me the same error.
     
    share
    + Quote Reply
  3. angelwatt, Jul 13, 2011

    angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #3
    Sounds like the MySQL process is stuck. Logging out and back in may help or rebooting.
     
    share
    + Quote Reply
  4. JakeGWood, Jul 14, 2011

    JakeGWood thread starter macrumors newbie

    Joined:
    Jul 3, 2011
    #4
    Yeah, that worked, but it seems like every time I quit MAMP and then open it back up, the MySQL won't start back up and have I have to log out/in again in order for it to do say, so it's habitual problem. Any ideas where it may lie?
     
    share
    + Quote Reply
  5. angelwatt, Jul 14, 2011

    angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #5
    I recommend looking at the MySQL log (/Applications/MAMP/logs/) and the Console app (/Applications/Utilities/Console), especially when quitting.
     
    share
    + Quote Reply
  6. rufhausen, Jul 15, 2011

    rufhausen macrumors regular

    Joined:
    Jul 5, 2007
    Location:
    Littleton, CO
    #6
    With respect to port 80, are you sure you are not conflicting with another process (built-in Apache) running on that port?
    Is Web Sharing turned on under Settings|Sharing?

    Even though 80 and 3306 are the Apache/Mysql default ports, I've found that it's easier to just to use the MAMP port defaults instead because it eliminates conflicts and it doesn't require entering your administrator password every time you start up.

    In fact, I avoid the MAMP GUI altogether and create symbolic links to all the start/stop shell scripts from the MAMP folder to my home folder and just control things via the terminal.

    The only time using the MAMP default ports is an issue is when you hard code the port number into your application code and move environments. This can be addressed easily with some simple if/else logic.
     
    share
    + Quote Reply
  7. HomeBru Studios, Jul 15, 2011

    HomeBru Studios macrumors member

    HomeBru Studios

    Joined:
    Jun 4, 2008
    #7
    Try connecting via a socket.
     
    share
    + Quote Reply
  8. JakeGWood, Jul 25, 2011

    JakeGWood thread starter macrumors newbie

    Joined:
    Jul 3, 2011
    #8
    Where would I find this info?

    Any good tutorials for this? Overall, I need a way better understanding of the terminal and UNIX. Any good and thorough tutorials for not only terminal use but what it means in terms of the system itself? A lot of the ones a find are for pretty basic file management tasks, or just overall not that insightful.
     
    share
    + Quote Reply
  9. turbobass, Aug 2, 2011

    turbobass macrumors 6502

    Joined:
    May 25, 2010
    Location:
    Los Angeles
    #9
    Funny I just got done recommending MAMP in another thread saying how reliable it is, etc. ;)

    There have been a few times however when the MySQL locks up. 99% of the time you can just restart your computer.

    Or if you want to get fancy pants:

    Open the terminal.

    Use
    Code:
    killall -9 mysqld
    If that doesn't work you're probably boned ... delete and reinstall MAMP. You should always be backing up your SQL database FYI...
     
    share
    + Quote Reply
  10. DaReal_Dionysus, Aug 2, 2011

    DaReal_Dionysus macrumors regular

    DaReal_Dionysus

    Joined:
    Jan 9, 2009
    #10
    I have been using MAMP for years and have several tutorials under my former handle and think you need to understand how MAMP works so i will explain.

    MAMP's configuration is unique and I would not recommend changing any off the settings at all. OS X comes with apache pre-installed and MAMP sets up another apache server but in a separate location that becomes the default for MAMP.

    Where it can get tricky is defining the site, this is where most people go wrong. I did a video tutorial on MAMP installation and defining the site properly at this http://www.dreamweaverclub.com/vtm/mamp.php

    Please view the VTM and you will learn how this will work for you. I would recommend installing MAMP completely and follow the VTM.

    Hope this helps.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page