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

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.

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

  1. Egal ob du ein Fan von klassischen Tischspielen oder modernen Video-Slots bist,
    casino Winshark hat alles am Start. Diese Aktion bietet einen 100% Match-Bonus von bis zu
    1.000 €, begleitet von 50 Freispielen für ausgewählte
    Slots. Wenn Sie jedoch um echtes Geld spielen und echte Gewinne erzielen möchten, stellen wir Ihnen heute alle Vorteile vor, die Ihnen die Anmeldung bei
    WinShark Casino DE bietet.
    Für Spieler, die gerne sozial spielen, gibt es verschiedene
    Varianten von Bingo, die im Winshark Casino gespielt werden können. Vom Drehen der Walzen bis hin zu strategischen Tischspielen sind bei Winshark Online-Casino
    Live-Dealer-Spiele verfügbar, die jeden Geschmack treffen. Zusätzlich zu den Willkommensboni bietet Winshark Casino Reload-Boni, Cashbacks
    und Treueprämien an.

    References:
    https://online-spielhallen.de/nomini-casino-promo-code-ihr-schlussel-zu-willkommensboni-und-mehr/

  2. The online casino supports the most popular Australian payment methods, 24/7 customer support,
    and generous bonuses. National Casino offers a
    really pleasant online gambling experience in Australia.

    The app lets you get real-time notifications for bonuses and special offers.

    You can also use your Skrill, Neteller, or other eWallets to make a deposit or request a withdrawal.

    National Casino Online offers all the common banking methods that work in New Zealand.
    With multiple angles, it’s easy to watch the game, see card values
    clearly, and track where the ball is landing.

    References:
    https://blackcoin.co/crownplay-casino-majestic-gambling-for-australia/

  3. SkyCrown is more suitable for experienced players who enjoy playing over a longer period.
    Adding a chatbot would improve convenience for players needing quick help, reduce
    waiting time, and overall enhance customer service.
    This offer suits players who deposit and play consistently but have an unlucky week.
    This cashback program is designed for regular slot players who experience losing streaks during the
    week. However, bonus terms can be tough for new players, with high wagering and several excluded payment
    methods. Additionally, SkyCrown offers tables hosted in multiple languages, creating a welcoming environment for players from diverse backgrounds.

    Responsible‑gaming tools (limits, cooling‑off, self‑exclusion) are available from account
    settings. Traffic is SSL‑encrypted, cashier processors are PCI‑aligned and accounts support 2FA.

    For quicker resolutions, have your ID and recent transaction details handy; that speeds up AML‑compliant checks and gets
    withdrawals approved faster. Skycrown offers 24/7 live chat for quick fixes and email for
    longer threads such as verification reviews or payment follow‑ups.

    Promotions mix matched bonuses with free spins and tournaments, while cashback cushions volatility for regulars.
    Skycrown 2 Casino is a strong contender for your go-to online gaming site.
    The process is simple and secure, even if you’re brand new
    to online casinos. The support staff are professional and
    friendly, trained to assist with everything from payment issues to bonus terms.
    Whenever you have a question or run into a problem,
    Skycrown 2′s support team is ready to help.

    With thousands of titles from top-tier providers, there’s something
    for every type of player.

    References:
    https://blackcoin.co/everything-you-need-to-know-about-online-pokies-in-australia/

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>