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

The Ultimate Guide to WordPress Maintenance: Tips and Tricks

When you’re running a business that relies on website traffic and sales to succeed. Then you need to keep it…

1 week ago

Migrate In 2024: Our Comprehensive Website Migration Manual to the Next Level

Migration! Yes, this word is very big in the web hosting industry and it has its importance. Especially for businesses…

2 weeks ago

Unveiling the Importance of Server Maintenance Plans: A Comprehensive Guide

The server is the backbone of the web hosting industry and it acts like a HERO in the web hosting…

3 weeks ago

IP Address is Blocked? A handpicked list of Solutions to Fix it?

Imagine you are on holiday having a cup of tea and browsing your website or blog.Then, what next?You will get…

4 weeks ago

Explained: Difference between Nameservers Vs. DNS

The web hosting industry is growing every minute, day, and year. It has many terminologies that are important to understand…

1 month ago