• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

02 7903 0216

     

Open Ticket

    

Client Area

FASTDOT Web Hosting Australia

FASTDOT Web Hosting Australia

Australian Cloud Hosting

  • Web Design
    • eCommerce Development
    • Branding
    • Web Design
  • Domains
    • Register
    • Domain FAQ
    • Domain Extensions
    • MyDNS Manager
    • Domain Transfer
  • Hosting
    • WordPress Hosting
    • Sydney cPanel Hosting
    • Magento Hosting – eCommerce Website
    • eCommerce Options
      • Managed Magento Hosting
      • PrestaShop Hosting
      • OpenCart Hosting
      • CS-Cart Hosting
    • Business Emails
  • Cloud Servers
    • VMware ESXi Hypervisor
    • Equinix – ISO Certified Data Centres
    • Cloud Hosting Info
    • Virtual Machines
  • Resources
    • Partner Program
    • Transferring Websites
    • WordPress Tips
    • Email Tutorials
    • Hosting in Australia
    • Apps Galore
    • Tutorials & News
      • SEO
      • VMware VPS Cloud
      • PHP and MySQL
      • Security
      • Linux Guides
      • Server Management
Order Now
VMware Cloud Hosting

Australian Cloud Hosting

Solid Cloud Hosting for your Websites

Compare

December 22, 2016 by Editor

How to reset the MySQL root password in CentOS via SSH

This tutorial describes how to reset the MySQL root password via SSH command. You may need to do this, if you have forgotten the password and need access for Webmin, Virtualmin or phpmyadmin

Resetting the MySQL root password

To reset the root password for MySQL, follow these steps:

  1. Log in to your account using SSH.
    You must run the commands in the following steps as the root user. Therefore, you can either log in directly as the root user (which is not recommended for security reasons), or use the su or sudo commands to run the commands as the root user.
  2. Stop the MySQL server using the appropriate command for your Linux distribution:
    • For CentOS and Fedora, type:
      service mysqld stop
  3. Restart the MySQL server with the —skip-grant-tables option. To do this, type the following command:
    mysqld_safe --skip-grant-tables &
    • Make sure you type the ampersand (&) at the end of the command. This runs the command in the background and allows you to type the commands in the following steps.
    • Running MySQL with the —skip-grant-tables option enabled is highly insecure, and should only be done for a brief period while you reset the password. The steps below show you how to stop the mysqld_safe server instance safely and start the MySQL server securely after you have reset the root password.
  4. Log into MySQL using the following command:
    mysql
  5. At the mysql> prompt, reset the password. To do this, type the following command, replacing new-password with the new root password:
    UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
  6. At the mysql> prompt, type the following commands:
    FLUSH PRIVILEGES;
    exit;
    
  7. Stop the MySQL server using the following command. You will be prompted to enter the new MySQL root password before the MySQL server shuts down:
    mysqladmin -u root -p shutdown
  8. Start the MySQL server normally. To do this, type the appropriate command for your Linux distribution:
    • For CentOS and Fedora, type:
      service mysqld start

Did you find this article helpful? Then you’ll love our support.

VMware Cloud Hosting

 

More great articles

MySQL and phpMyAdmin
MySQL Database - How to Duplicate a MySQL Database in cPanel
Solving a 500 Internal Server Error
Features of PHP5

Category iconPHP and MySQL

Primary Sidebar

Recent Posts

  • How to Upload Files Using the cPanel File Manager?
  • How To Increase the PHP Max Upload Size in cPanel®?
  • Choosing a hosting platform in 2021
  • VARCHAR vs. TEXT for MySQL Databases
  • What Are the Best Shopify® Alternatives in 2021?
What is a phpinfo file and how to create it
Security Issues with allow_url_fopen
MySQL Database - How to Duplicate a MySQL Database in cPanel
Install your own local PHP web development environment

Categories

  • Application Hosting
  • Australian Cloud Hosting
  • cPanel Hosting
  • DNS and Domains
  • eCommerce Hosting
  • Email Tutorials
  • Legals
  • Linux Tutorials
  • Operating Systems
  • PHP and MySQL
  • Register a Domain Name
  • Search Engine Optimization
  • Security
  • Server Management
  • Tutorials
  • VMware Cloud Hosting
  • Web Hosting Tutorials
  • WordPress Tips & Tricks
Australian web hosting

Footer

Recent Posts

  • How to Upload Files Using the cPanel File Manager?
  • How To Increase the PHP Max Upload Size in cPanel®?
  • Choosing a hosting platform in 2021
  • VARCHAR vs. TEXT for MySQL Databases
  • What Are the Best Shopify® Alternatives in 2021?

Legals

  • Terms&Conditions
  • SLA
  • Acceptable Usage Policies
  • Privacy Policies
  • About FASTDOT
  • ISO Certified

Contact

Australia: +61 02 7903 0216
Submit a Support Ticket

Company

FASTDOT.COM.AU PTY/LTD
ACN 002 454 631
200 Bourke Rd, Alexandria NSW 2015 Australia
Processing by eWay, PayPal and Bitcoin

blankNSW Government Provider

Made with in Sydney/Australia

Copyright © 2022 FASTDOT.COM

All rights reserved. Return to top