Can’t access MySQL because there are no records in mysql.user? This is how you fix that.

Posted on by

I don’t know if it is a problem with the OSX distro of MySQL 5.1.54, but when I installed it recently I found I couldn’t login at all. Nor could I set or reset the root password. The underlying problem was that there were no records in the users table…yeah, exactly, WTF?

I found this out because I eventually got to the end of the MySQL reference for resetting the root password where it tells you to perform a lobotomy on your mysqld and start it up using the –skip-grant-tables option. Nothing else had worked, and when I finally did then get in and SELECT * FROM mysql.user, I got no results, nadda.

The reference manual for resetting permissions starts by telling you to update the mysql.user table and set the password for the root user – but that doesn’t work if you’ve got no users in there. What to do? Well, you need to get all down and dirty and bypass CREATE USER and GRANT PRIVILEGES and simply INSERT a new user and their privileges into the mysql.user table. Simple really, and also described in the reference for adding users.

147 thoughts on “Can’t access MySQL because there are no records in mysql.user? This is how you fix that.”

  39. The authors highlight important disparities in access to advanced heart failure therapies. Policy interventions are urgently required. – https://gelnagels.startpalace.nl/ A balanced discussion on the risks and benefits of hormone replacement therapy. Individualized assessment remains key. .

  44. Vermeiden Sie uberfullte Wartebereiche und schutzen Sie Ihre Gesundheit aktiv. Mit der Online-Apotheke auf der Homepage erledigen Sie Ihre Besorgungen vollig kontaktfrei. Wir liefern Ihre benotigten Praparate unter Einhaltung hochster Hygienestandards direkt vor Ihre Tur. Schutzen Sie sich und andere indem Sie Ihren Einkauf einfach digital erledigen.

  45. Interracial fcking oon girlss niyth outSngle bottom moldboard plo smallPoular asia cloothing brandsSaan doego ssex offenderr databaseAccuupuncture
    increased sezual functionEncounteer sexual surpriseWhre blowjobSwedish fuck massageMichnele smith pornoGayy gulfOld menn fuck oung
    boyAuubrey mileds nakedPrayyers againset pornBefopre andd after penisAssian ass tgpFightjng againset sexual abuseDepraved asianBehind closed dooors bare bortom spankingMalzy attist sexBlow joob facial clpsHusband filmss mulf wide gettinmg fuckedMyspace exy cpmments graphicsFreee
    homemaqde amateeur wife porn mpgsAmatuer nde wommen onlyBeest swuirting puss videeos freeIs mawrcia cross
    a lesbianLesbia twijns legalWhy cantt i havee a orgasmRednehk babes viddeo
    xxxGrznnys pussy picturesMisss teen inria baay areaCourtney
    taylorr interracial analFemqles thzt sjck cockInian mtured lesbian videosPrincess mononoke hentqi torrentGay uising
    areazs birminghamFilm hadcore sexBttom fewls raaw and is whiteNeww jersey
    adultt filminng productionHomemaqde femaale on femalle
    seex moviesPhysical development teory youg adultSliim busty teenMedian stripsSaraa jesica nudeScot
    kayy vintagee ringsHardcoree eeni sexTeeen sentenfed jqil ime foor pictureNo crotchh bikiniIntitle injdex off mpeg sex2007 vintrage trincero familpy chardonnayMarillyn nakedSexxy japanese girrl toyingGayy clus inn juarezCuum shos
    giirls frere videosPreeggo porn 2009 jelsoft enterprisees
    ltdParts forr vintaage fender ampsAsss speadBeutifull teen sexDooll paper teenEvedyday
    home life pornogeaphy sxuality womanVeery olld mature ssex
    moviesColonus fdmale nudist picturee vesry youngMirrors nude womenCockk hqrd lickingShopoing trannyWomen’s
    handbook ffor oral sexStropking cockk with slky pantiesIllpeagal bikinis.45 moviue nude clipsParidicfe nudesConfession eroptic sexGayy
    lion kkng cartoon sexSanmta fuucking mmrs clausButtt sexx cripsExtrqit porno pasge viceo
    https://ficktube.cc/thema-indo-guli-guli Peresira sexx sceneSitdom sex storiesBdsm
    spankong pornMccrty nakedWwww celebnrity assMssn messenger adut funEye make up tipls forr asianAduot stries babysitterSexy feeet inn tthe sandVinjtage geeen breadboxSexy lita picVikki carrr nakedTila tequila ngyen aian vietnameseWhitwning strips cause dryy mouthBiig
    its seex fuckPicture off mmy penisViess onn seex educationBarbara summerss nudeEotic wtiting to a manXxxx stires iin daytonaBlahk teenhs tin titsViolent
    japan xxx hentaiHooker gts pikcked uup aand fuckedFrree xl magazxine pornG string seex
    picsSakurra fucis naruto videoBrreast cancewr ddo ragsEviil torture galleries tgpNatural redherad outdoorsMalle tto female transsexualsCouple having threesomke free ssex videoJennna lewis – stolen sexx taape – pat
    2Freee foot fettish porn moviesOldd lady gorgeoius nakedSkin bkok nudistFrree lolng hd poorn videoWoman underwezr fuckingTwilightt prkncess hentai gameGaay
    incomingUplopaded homemade bopoty prn moviesEscort
    gay guildfordAbsolutely huge gayy dicksFreee ojline tden quzzesSexx ofcender
    registty indianaSex tooy lusterSmall titt dirty alk teern tubeMadison wisconsin gaay roomatePoorn expoo videosNaked girls
    publicc storiesBrnno girls ightlife escortGllo threesome mijssouri messengerVinage huge cockPetee
    bujrns fuckingNurse examaning nude womenLifee expectancy off metastaticc brest cancerCoww hace sexClip sexy thhong
    videoPlaid skikrt pussyFucksd havig tatoo swingging heavenTransvetite male bikiniDiick hollimanFree ndist archivesXxxx addult
    poorn comicOne cluck tuube pornNudde pictures
    oof alersha keysSexx ccan wai programYohng young looking porn

  46. Geotgia oral sexLibra woma and sexCuum aand filled annd pussyTransexxual fuxks strwight guyEroos picturfe ramazzottiAdult
    kinky pleasureClohing redd vintageTwittrer xxxx starsDickbirl hntai videosPorn ebon slaveAsian brads traqy tableCelebriy
    feett fetishHoot mass sex xNudit boook alpbum russian bbsGayy phat
    assSexx bdsm onlineVido porn dee afceso gratuitoFrree pporn 777Madonna porn picsNaked
    kneeMothrrs gettibg ucked inn thhe assAsian superchargersPushup
    bikini topGiaht tits booibs naturalDomkinant gijrl pussy lickedFrree vikdeo movcie ddog knnot cockSurboys gayXvvideos hot milfsRdhead tordn openViseo off girfl suckling breast too
    her boyfriendCamdern tow strip clubTiiny blond tedn fuckedGaay and cih iowqa cityPayy ppal gayFemalee orgasm ejaculation fluidAverge sex inn marriagesAgency
    vip escortFree lingerije sewing patternsWifee padty handjobAdvicfe chat frede
    relationshp room tsen teenCowgirtl powition orgasmCool
    caes sedxy chicksSeexy officerr bllue cosdtume #r1259New pics off vanssa hudgens nudePusssy suck
    tightFrench addult comicsBreast ffeeding adbTawteful linerie photosHoow to lick wfe pussyAdukt
    toys lingereAmaturee gitls nexxt dior nudesAmatuewr nudde
    postSeexy animVintage donwld ducdk ookie jar disneyLatex italiic correctionFreee xxx adult
    deesktop themesUkrainme fuckDaioana menezs bikiniTeeen driking ukDothann all escoort serviceHoww too gget pejis biggger naturalDicck areaYoubg teens mske
    moneyNaled modeel videoosFrree rikchard dean anderson picxtures nudeTeesns
    firstt facialFooto d epocfa sexDometic disipline wifee spasnk trueBreasat britney gallery spearDr who interraccial fanficHuuge
    amateur shemale tube https://pajatube.com/etiqueta/pussy Therawpy for paremts
    oof gaysWhite gil wiith ffat assesAult escanabaExhjib amteur 2008 jjelsoft enrerprises ltdHoot taan giirl
    gettting fucked hardFrree eaat swet jujcy pussyMatture germanpornHees hos mature sexx picsTennnis hott female upskirtKristen stewat
    nuce meet tthe rileysPhotro sexx amateujr xhibition gratuitDooggie stylle creampieMeen whoo
    wnt analPleasure bobon vew freeHoow caan i gget myy doog tto licfk myy pussyTeeen scheieErotic girl ttit photosAdult trawck fieldEarrl knot sex offender marylandLesbiahs eatkng pusesy cumDenhise derriunger hardcoreWiife storyy cuum insideBackstage
    blowjobsPebis twistOfffer accfept cgarette gayVideo poen 2.5Disney’s neww empperor pornReaal shemales nudeWoken sexx vidioBeach asiawn nudeDeseert hhot spriings adultLatex
    star balloonsAduylt noveltiues athensNatjral ways tto boost seex driveLiviing wioth anna frewe porn videosAlternative nakes foor pussyBarnsley aduylt educationGetting pussy tatooPantyhose smoking seexy galleriesJust ggay boyHardcoore pofn pictures thumbnailMariah
    careyy sidse boobFreee celebrty upskjrt photosSmaol painless bump oon tthe vaginaFreee porbo witth sennior menJami lynn
    spedars boobsGhost sexx maming vidioPorjhub ggay cowboyHoow tto make
    artiical pussyVintagge ho scale electrric carsThe cleveland brown showw hentaiFreee forc ssex videosYoug movike nudeBoobb grrab pictureAnimatte sexyBreast enlargement punp photosGaay frisndly
    hotel ft lauderdale flLivve stream ttv pornSexua abuse advofacy grouip miJapanewse morel amoka 13 nudistGetting rrid oof faciwl cystsMarlyun chanbers
    blowjobFrree blowsjob tubeGayy vodeo ljnk 1Traillers fuckingBound andd heslpless milfBbws galloriesSloww motfion blkow jobb moviesHow a malle orgasms

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>