: Why has mysql stopped working on localhost and how do I fix it? I asked this at superuser but I'm having no joy there. I was really hoping someone could help because I'm stumped. I use a

I asked this at superuser but I'm having no joy there. I was really hoping someone could help because I'm stumped.

I use a MacBook Pro running Mac OS X 10.6.4

For a few years I have used MAMP to test websites locally but suddenly and for no apparent reason when I start the MAMP servers the mysql light stays red.

I'm not very clued up on how to actually run a server which is the main reason I use MAMP. I also have Sequel Pro installed for administering my databases. When I try to connect to mysql in Sequel Pro through a socket connection it says

The socket file could not be found in any common location. Please supply the correct socket location.

and then

MySQL said: Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2)

I can connect and access all my databases if I connect with host 127.0.0.1 but I used to just connect through the socket and all was fine. Also all my testing sites which I hosted locally are no longer being processed by PHP.

I have no idea why this suddenly stopped working and any light someone could shine on the matter would be very much appreciated. A solution even more so.

Thanks.

10.02% popularity Vote Up Vote Down

: How to 301 redirect from old query string URLs to CakePHP Canonical URLs? I currently have a .htaccess file that looks like this: RewriteCond %{QUERY_STRING} ^action=view&item=([0-9]+)$ RewriteRule

@Pope3001725

Posted in: #301Redirect #Htaccess #ModRewrite

2 Comments

: Restrict access to web directory with .htaccess Let me just say that doing this sort of thing with .htaccess files has never been a strong point for me. Let's say that I have a directory

@Pope3001725

Posted in: #Htaccess #Security

2 Comments

: Consider a service like S3 where there is redundancy at a backup level. Also, as your customer's data is critical, its best you encrypt your data before storing it anywhere outside your

@Pope3001725

0 Comments

: 1) Create the email accounts on the new server 2) Have the customer download any emails they wish to keep off of the old server (if they haven't done so already) 3) After business hours

@Pope3001725

0 Comments

Login to post a comment!

2 Comments

Sorted by latest first Latest Oldest Best

@Cofer257

I'd see if Skype is blocking your port. I've had similar problems in the past and found if Skype is open before I launch my server, it won't launch properly. IF Skype is the culprit, simply close Skype, launch your server, and then open Skype once your server is online.

10% popularity Vote Up Vote Down

@Moriarity557

Just to make sure .... disable all the start ups and reinstall MAMP.... Go to services and try to enable mysql from there...

10% popularity Vote Up Vote Down

Feed

: Why has mysql stopped working on localhost and how do I fix it? I asked this at superuser but I'm having no joy there. I was really hoping someone could help because I'm stumped. I use a

More posts by @Pope3001725

: How to 301 redirect from old query string URLs to CakePHP Canonical URLs? I currently have a .htaccess file that looks like this: RewriteCond %{QUERY_STRING} ^action=view&item=([0-9]+)$ RewriteRule

: Restrict access to web directory with .htaccess Let me just say that doing this sort of thing with .htaccess files has never been a strong point for me. Let's say that I have a directory

: Consider a service like S3 where there is redundancy at a backup level. Also, as your customer's data is critical, its best you encrypt your data before storing it anywhere outside your

: 1) Create the email accounts on the new server 2) Have the customer download any emails they wish to keep off of the old server (if they haven't done so already) 3) After business hours

Login to post a comment!

2 Comments

Back to top | Use Dark Theme