Categories: Hostripples Featured

How to reset the mysql root password from mysql safe?

Steps to reset mysql root password from mysql safe:

# service mysqld stop
# mysqld_safe –skip-grant-tables &

That should start up mysql without the need for a root password. Once in, type
>use mysql
>UPDATE user SET password=PASSWORD(‘newpass’) WHERE user=’root’;
>FLUSH PRIVILEGES;
>quit

That will reset the root password for you.

Kill all old processes to shutdown
# killall -9 mysqld_safe; killall -9 mysqld

Start it up again with
# service mysqld start


HR-ADMIN

Recent Posts

Updated cPanel License Price in Jan 2025: A Comprehensive Guide

Are you ready for another cPanel price adjustment? As we have approached January 2025, cPanel has rolled out significant changes…

2 weeks ago

Finding Your Fit: Website Builder or WordPress for Your Site?

In this growing digital world, having a website is not enough—it’s a crucial and much-needed option. But here's the challenge…

3 weeks ago

From Hobbyist to Professional: Selling Photos Online

In today's digital age, the line between hobby photography and professional photography has become increasingly blurred. With the rise of…

3 weeks ago

Windows Web Hosting: Essential Insights for Beginners

Are you taking your first steps into the world of web hosting? You're not alone. Every day, countless individuals and…

3 weeks ago

Crafting a Professional Email: Step-by-Step Guide

Due to growing digitalization, Email Communication has become the backbone of professional interactions. Yet, surprisingly, many professionals struggle to craft…

1 month ago