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.

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

  11. Tyra banks nude pictureNaked escorts in londonRight said fred sexy mp3Gwen steffani nude picsReal life naked wivesMother
    son sex photo galleryComic strips peanutsXxx winamp
    skin xnxx Alfred vargas nudeWife farmyard sexCum from their wifes pussySexy cherrleaderKarma cumBlonde hardcore stripper videosCondom made ofYoung gay twinks sucking cocksAsian decor canada https://m.xnxxtubexxx.cc/ Asian swiming tubeSex pics mature positions overweightMoviesand face fuckedVintage henredonFree gay movie sex siteDay
    after period bleed during sexHow to talk sex dirty on the phoneRaven from teen titan tied
    up xnxx Bea busty flora polishInflatable dildos and viberatorsNaked mature geeks and nerdsSasuke
    naked picsDrawn to bondage passwordsVintage ktmVaginal
    piercing christinaStiletto pleasureAdult sex dating
    in camden new jerseyStrip slots onlineAdult hercules the legendary
    journeys fanfictionNude teen close upsHuge breast veinsDanni
    ashe blow job videoGetting jacked offMerino bikini breifSexy
    nicknames for girlsMoni escort

  21. Платформы для совершеннолетних могут служить инструментом сексуального ликбеза а также помощью в осознании личных предпочтений. Они позволяют взрослым изучать собственные границы в безопасной обстановке уменьшая риски фактических последствий. порно рассказы анал В отношениях взаимное ознакомление подобных сюжетов может укреплять близость и служить причиной для откровенного диалога о желаниях и границах. Также такие ресурсы предоставляют возможность для безопасной разрядки напряжения и снятия психологического напряжения не нанося ущерба другим.

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>