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
As a web designer and web developer your experience must have reached to new height, right? Further, you need to…
In today's digital landscape, timing is everything. Whether you're a social media manager, business owner, or content creator, the success…
Are you a website owner? Maintaining the website is the prime concern for any website owner. Yes, it’s equally important…
If you’ve planned to launch a WordPress website, you might get a question, “How do I log in to WordPress?”…
As the demand for virtual private servers (VPS) continues to grow, businesses and individuals are faced with a crucial decision:…