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
The app development industry is evolving at an incredible pace. A decade ago, creating an application required extensive programming knowledge,…
Introduction to Cloud Hosting In today's digital world, website performance can make or break an online business. Whether you run…
In the world of digital marketing, getting attention is only half the battle. The real goal is to convince people…
Introduction In today's digital world, understanding website bandwidth is essential for anyone running a website. Whether you own a blog,…
Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…