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

How to Design a Website for Black Friday 2025 (Complete Guide)

Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…

3 days ago

301 Redirects for WordPress: What, Why & How (SEO Best Practices)

When you move or delete a page on your WordPress website, visitors — and search engines — can easily hit…

6 days ago

Meet Perplexity: AI That Thinks Like a Researcher

Introduction Artificial Intelligence has made remarkable strides — from writing poetry to generating code. Yet, most AIs still act like…

3 weeks ago

Top 15 AI Text Writers in 2025 — Features, Uses, Pros & Cons Explained

Introduction Artificial Intelligence has revolutionized the way we create, refine, and scale written content — from blogs and marketing campaigns…

3 weeks ago

This Diwali, Give Your Website the Glow It Deserves — Host Smarter,Rank Higher

Every Diwali Brings New Light, New Beginnings, and New Opportunities In today’s digital world, your website is the Diya that…

1 month ago