Change a WordPress password with SSH

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced
Advanced campaign settings
All about analytics
All about images
Basic steps
Calendar
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
keep my account secure
Keep my email secure
know your privacy rights
Legacy
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
online store
organize
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
renewals
Security
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
troubleshooting
Troubleshooting
Uncategorized
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
Websites
work with databases
work with delegates
working with blogs

You can make changes to your database through SSH, which you can use update your WordPress password.

Warning: The information in this article is advanced material we make available as a courtesy. Please be advised that you are responsible for properly following the procedures below. Customer Support can’t assist with these topics.

  1. You should always backup your site before performing any changes.
  2. Connect to your server or shared hosting account with SSH
  3. Connect to MySQL using the following command:mysql -u username -h host database -P port -pEnter the database information from your database as follows:
    • username is your database username
    • host is your database hostname or IP address
    • database is the database name
    • port is the port MySQL is running on (by default this is 3306)
  4. When prompted, enter the password for that MySQL user.
  5. Enter the following MySQL command to switch to your WordPress database:mysql> use database
    • database is the database name
  6. Enter the following command to see a list of the tables in the database. Make notes of the table containing “_users”.mysql> show tables;
  7. Enter the following command to see the contents of your “users” table. Make note of the number in the “ID” column for the user you want to update.mysql> SELECT * FROM table;
    • table is the name of your users table.
  8. Use the following command to set your new password.mysql> UPDATE table SET user_pass = MD5(‘password’) WHERE ID = id;
    • table is the name of the users table.
    • password is your new password
    • id is the number you located in Step 7

You can now login with your new password

More Info

Changing the currency for the products.

Prices shown in US Dollars. You can convert to your own currency after selecting a product.