This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password :
root@server [~] /etc/init.d/mysqld stop
Now start MySQL server without password:
root@server [~] mysqld_safe –skip-grant-tables &
root@server [~] mysql
After that you can get the mysql prompt then run the following command
mysql >use mysql;
mysql >update user set password=PASSWORD(“NEWPASSWORD“) where User=’root’;
mysql > quit;
root@server [~] /etc/init.d/mysqld stop
root@server [~] /etc/init.d/mysqld start
Now you can access your mysql service by using the password you have set
[root@server ~]# mysql -u root -p
DONE !! 😀
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:…