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

Will AI Replace Developers in the Future?

Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…

2 days ago

What is Bot Traffic? Easy Ways to Detect and Block It

Introduction to Bot Traffic Bot traffic refers to visits to a website that come from automated software programs rather than…

2 weeks ago

100+ Essential Windows Commands You Can’t Ignore

Windows may look like a point-and-click operating system, but under the hood, commands still do a lot of the heavy…

3 weeks ago

YouTube Shorts for Beginners: Step-by-Step Guide (2026)

YouTube Shorts are short-form vertical videos designed for quick consumption, typically lasting up to 60 seconds. In 2026, they’ve become…

3 weeks ago

YouTube SEO Secrets That Actually Work in 2026

YouTube SEO Secrets That Actually Work in 2026 YouTube SEO 2026 YouTube SEO Secrets That Actually Work in 2026 If…

4 weeks ago