Islamic mind

april 1, 2011

MySQL not starting or can’t login ? Mac OS X

Filed under: Uncategorized — majestrooo @ 10:26 f m

This happened to me recently as I switched to a different network. Everything was working and I had not changed any setting whatsoever. But I failed to login to MySQL and got errors like

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

or

STOPPING server from pid file /usr/local/mysql/data/SOMEPIDFILEHERE.pid

I was seriously considering reinstalling but…I *knew* it was all running good before so there must’ve been something else.

The problem was that mysql was configured with ‘localhost’ (fine) but for some reason my hostname was not ‘localhost’ on the new network, instead I had the network’s address.

In Terminal

$ hostname

> somedomain.domain.org

Simply

$ sudo hostname localhost <or whatever you set up with, e.g. 127.0.0.1 before>

Restart mysql

$ sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist

$ sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist

Voila it worked after that!

$ mysql -u root [-p]

21 kommentarer »

  1. It is the best time to make some plans for the future and it is time to be happy.
    I’ve read this post and if I could I want to suggest you some interesting things or tips. Perhaps you can write next articles referring to this article. I wish to read even more things about it!

    Kommentar av Read Full Article — augusti 14, 2012 @ 3:48 e m | Svara

  2. I am genuinely pleased to read this web site posts which carries plenty of useful facts, thanks for
    providing these data.

    Kommentar av Edwin — september 16, 2012 @ 7:39 f m | Svara

  3. This is a great exercise to get your blood pumping and work your calves.
    Samsung hasconfirmedthat the Galaxy S III will be getting Jelly Bean “very soon.
    I say may- because as in all extreme sports while there is certainly a measurable
    amount of skill required there is also a great deal of mental training
    that goes with it.

    Kommentar av Randell — oktober 20, 2012 @ 6:15 e m | Svara

  4. you’re truly a just right webmaster. The site loading velocity is amazing. It kind of feels that you are doing any unique trick. In addition, The contents are masterwork. you’ve done a excellent job on this subject!

    Kommentar av social — november 7, 2012 @ 9:29 e m | Svara

  5. I got so interested in reading the content, it was slowing down my commenting!

    Kommentar av Whitney — januari 23, 2013 @ 4:11 e m | Svara

  6. Right now it appears like Expression Engine is the best blogging platform out there right now.
    (from what I’ve read) Is that what you are using on your blog?

    Kommentar av Arden — mars 28, 2013 @ 1:40 f m | Svara

  7. What a information of un-ambiguity and preserveness of valuable know-how concerning unpredicted emotions.

    Kommentar av Rosetta — april 25, 2013 @ 7:04 e m | Svara

  8. What a data of un-ambiguity and preserveness of valuable familiarity about unexpected feelings.

    Kommentar av dustystem1506.sosblogs.com — juni 4, 2013 @ 6:59 e m | Svara

  9. I used to be recommended this website by means of my
    cousin. I am no longer sure whether or not this submit is written through him as nobody else recognize such special approximately my problem.
    You are wonderful! Thanks!

    Kommentar av phen375 consumer reviews — juni 16, 2013 @ 6:38 e m | Svara

  10. avoid drying

    MySQL not starting or can’t login ? Mac OS X | Islamic mind

    Trackback av avoid drying — september 14, 2014 @ 12:36 e m | Svara

  11. Verlagsgruppe Random House GmbH

    MySQL not starting or can’t login ? Mac OS X | Islamic mind

    Trackback av Verlagsgruppe Random House GmbH — januari 17, 2015 @ 10:38 f m | Svara

  12. reseller hosting murah

    MySQL not starting or can’t login ? Mac OS X | Islamic mind

    Trackback av reseller hosting murah — juni 12, 2015 @ 5:46 f m | Svara

  13. domain murah

    MySQL not starting or can’t login ? Mac OS X | Islamic mind

    Trackback av domain murah — september 23, 2015 @ 12:43 e m | Svara

  14. baju muslim anak keke

    MySQL not starting or can’t login ? Mac OS X | Islamic mind

    Trackback av baju muslim anak keke — september 23, 2015 @ 1:55 e m | Svara

  15. This is the perfect website for anybody who wishes to
    understand this topic. You know a whole lot its almost tough to
    argue with you (not that I personally would want to…HaHa).
    You definitely put a brand new spin on a topic
    which has been written about for many years. Wonderful stuff, just wonderful!

    Kommentar av sock subscription — april 19, 2017 @ 1:14 f m | Svara

  16. Although an Android app can be made accessible by developers via their sites, most Android programs have been uploaded
    and printed on the Android Market, an online store dedicated to these programs.
    The Android Market includes both free and priced programs.

    Android programs are written in the Java programming language
    and use Java core libraries. They are compiled to Dalvik executables to run on the Dalvik
    virtual machine, and it is a digital machine specially created for portable devices.

    Kommentar av android apk — augusti 19, 2019 @ 7:41 f m | Svara

  17. Enhance your non-text written content so search engines can see it.
    If your web site employs Flash or PDFs, be sure to browse up on the most
    recent greatest procedures so search engines can crawl that written content and
    provides your website credit score for it.

    As soon as you install Yoast Website positioning Premium, you’ll no
    longer see any ads in your WordPress plugin. Unless of course you’re keen on seeing the Yoast team as
    part of your appropriate-hand column every single day, certainly.
    We can easily’t blame you!

    We will likely not only look for the keyword or keyphrase you enter, but We’re going to
    review your text on all variants of that term or phrase.

    Certainly, your company can gain from the solutions provided by a
    Digital Marketing Business, because of their skills in the sector.

    A social media agency which makes innovation and technologies entirely a lot more exciting with the help of Artistic digital media methods.

    It is just a should-have in the top online marketing companies listing of India.

    GenY Medium is often a Digital Marketing firm that mixes the
    artwork & science of marketing. They utilize a perfect combination of digital marketing procedures, with a mission that will help brand names reach their marketing targets.

    Do you have a very clear conversion objective?
    PPC promotion is best after you can match bucks used to your
    conversion just like a transaction or direct kind completion. Distinct conversion objectives assist you do that.

    You no longer must simply click all over to learn what you ought to enhance upcoming.
    In Yoast Search engine marketing Premium, you’ll be able
    to obtain an overview of all the main target key phrases you’ve utilised to this point
    and in the internet pages that need to have much more SEO care.

    An additional ethical controversy related to search
    marketing has actually been the issue of trademark infringement.
    The talk as to whether 3rd get-togethers must have the best to bid on their competition’ manufacturer names continues to be underway For several years.

    Fractography would be the analyze of fractured surfaces that could
    be completed on a lightweight microscope or, generally, on an SEM.
    The fractured surface area is Slice to an acceptable measurement, cleaned
    of any organic and natural residues, and mounted on the specimen holder for viewing during the SEM.

    while searching on google i also found a company which is a great at their services together with responding the your queries.
    cheers team Brandwitty !!

    PPC Exhibit is top-of-funnel, but it’s still targetable when nevertheless letting
    Artistic liberty. Don’t just are you able to take
    full advantage of person targeting selections to help you make sure your
    ads show to the correct folks, but It’s also possible to use impression and video property to capture a user’s notice.

    They’ve got a list of innovative benefit-added products like Simply call-Monitoring, Optimized Landing Internet pages and so forth which have assisted their clients to derive utmost benefits
    from their budgets. It truly is one of the best digital marketing companies concerning consumer fulfillment.

    Although the Introduction to Search engine optimization session was supposed for
    marketplace newcomers, Shelby’s suggestions provide critical reminders for even experienced Website positioning gurus who are actually optimizing websites For
    a long time.

    Kommentar av sem — september 3, 2019 @ 5:45 f m | Svara

  18. I’m gone to inform my little brother, that he should also pay a visit this blog on regular basis to obtain updated from latest news update.

    Kommentar av filmitorrent — september 16, 2019 @ 3:33 e m | Svara

  19. Can I simply say what a comfort to find somebody that genuinely knows what they’re talking about on the net.
    You definitely know how to bring an issue to
    light and make it important. A lot more people really need to read this and understand this side of your story.
    I was surprised you are not more popular given that you definitely have the gift.

    Kommentar av androidworld — oktober 19, 2019 @ 3:01 e m | Svara

  20. What’s up to all, because I am truly eager of reading this blog’s post to be updated regularly.
    It consists of pleasant information.

    Kommentar av socialgurus.in — november 11, 2019 @ 11:10 f m | Svara

  21. Thank you a bunch for sharing this with all folks you actually understand what
    you are speaking about! Bookmarked. Kindly also seek advice from my
    website =). We can have a hyperlink change contract between us

    Kommentar av 3Unlocker — november 24, 2019 @ 8:00 f m | Svara


RSS feed for comments on this post. TrackBack URI

Kommentera

Fyll i dina uppgifter nedan eller klicka på en ikon för att logga in:

WordPress.com Logo

Du kommenterar med ditt WordPress.com-konto. Logga ut /  Ändra )

Google-foto

Du kommenterar med ditt Google-konto. Logga ut /  Ändra )

Twitter-bild

Du kommenterar med ditt Twitter-konto. Logga ut /  Ändra )

Facebook-foto

Du kommenterar med ditt Facebook-konto. Logga ut /  Ändra )

Ansluter till %s

Blogga med WordPress.com.

%d bloggare gillar detta: