Locked Out of Your Ghost Blog on Zeabur? Don't Panic, Here's How to Reset Your Admin Password

One of the most frustrating moments for any creator using Zeabur's one-click Ghost deployment is realizing you've forgotten your admin password. When you're locked out, you can't publish new content or manage your site.

But don't worry. This guide will walk you through how to securely reset your Ghost admin password by directly accessing the database through the Zeabur platform.

Step-by-Step Guide

Step 1: Locate Your MySQL Service

First, log in to your Zeabur dashboard and navigate to the project where your Ghost blog is deployed. You'll see a list of all related services. Click on the mysql service.

Step 2: Access the Database Management Interface

Once you're on the MySQL service page, select the "Database" tab. You will see a database named zeabur—this is the primary database your Ghost installation uses.

Step 3: Generate a New Hashed Password

For security reasons, Ghost doesn't store your password in plain text. Instead, it uses a strong encryption algorithm called bcrypt. Therefore, we first need to convert your new password into this hashed format.

1. Go to an online bcrypt tool: Bcrypt Generator
2. In the "Password to hash" field, type the new password you want to use.
3. Click "Hash." The tool will generate a hashed password string, usually starting with $2a$. Copy this entire string to your clipboard for the next step.

Step 4: Execute the SQL Command to Update Your Password

Return to the database page on Zeabur and click the "Execute SQL Command" button.

In the command input box, paste the following query:

UPDATE zeabur.users SET password='PASTE_YOUR_HASHED_PASSWORD_HERE' WHERE email = 'your_login_email@example.com';

Be sure to replace two parts of this command:

1. PASTE_YOUR_HASHED_PASSWORD_HERE: Replace this with the bcrypt hash you generated in the previous step.
2. your_login_email@example.com: Change this to the admin email address you use to log in to your Ghost blog.

Once you've double-checked the command, click "Execute." After it runs successfully, your password has been reset.

You can now head back to your Ghost login page and sign in with your email and the new password you just set!

More information: https://zeabur.com/blogs/vibe-coding-ai-zeabur-nextjs-react-ghost-seo