How to reset mysql root password ?

Category : Linux Helpline (Easy Guide)
Posted on : Jun 06, 2019
Views : 2,833
By : Tadashi P.

# service mysql stop #pkill -9 mysqld

2) Start the mysql in safe mode as follows

# mysqld --skip-grant-tables --user=root &

3) Now update the mysql user tables and root password as follows

#mysql
 mysql>use mysql;
 mysql>UPDATE user SET Password=PASSWORD('YOUR_PASSWORD')  WHERE Host='localhost' AND User='root';
 mysql>flush privileges;

Now add the new password “YOUR_PASSWORD” in /root/.my.cnf and start mysql

# service mysql start

Previous Post
csf + lfd firewall configuration in vps (virtuozzo /openvz)

Next Post
Upgrading Python in Cpanel Servers without breaking yum

Archive Calendar

Sat	Sun	Mon	Tue	Wed	Thu	Fri
	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30

Born in 2004 ... Trusted By Clients n' Experts

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

HostSEO Blog