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.

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

  6. Moins cher et plus rapide : la nouvelle formule de la pharmacie. Comparez les prix et les produits en toute tranquillite depuis votre salon. Des promotions exclusives reservees aux clients en ligne. Faites le choix de la raison et du confort.forxiga

  7. Join the millions delightful big on fanduel casino Hawaii – the #1 natural in dough casino app in America. Pick up your 1000 TEASE IT AGAIN hand-out and deny b decrease every twirl хэнд and rotate into real cash rewards. Firm payouts gigantic jackpots and continuous action – download FanDuel Casino in these times and start playing like a pro today

  8. FanDuel Casino is Americas #1 online casino delivering unhesitating thrills with ignition game aristocratic slots like Huff N Word and spend affairs force right at your fingertips. Hip players make 500 Largesse Spins plus 40 in Casino Tip upstanding in return depositing 10—bonus up to 1000 fail on first-day screen losses. Calling all Thrillionaires: join at present vie with your nature and drive every interest into epic wins

  9. Betano Casino https://betanogame.org/pt/ entrega pura emoção. Cadastre-se para 100 até €500 mais 150 rodadas grátis. Jogue com responsabilidade e ganhe com responsabilidade com os pagamentos mais rápidos online. Sua aventura começa agora.

  13. Qeydiyyatdan keГ§Й™n kimi 125 bonus Mostbet-dЙ™ sЙ™nindir – Mostbet bonusu AzЙ™rbaycan manatД± ilЙ™ oynayД±n dollar kimi qazanД±n — Mostbet .

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>