Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Mysql database error:

avatar
Super Collaborator

Hi,

I am trying to login to my mysql prompt on HDP 2.5. Its doesn't allow me to login. Not sure whats the password set on it.

please find the attached.

Any help is highly appreciated.

Thanks,

Sujitha

6667-screen-shot-2016-08-15-at-40555-pm.png

1 ACCEPTED SOLUTION

avatar

@sujitha sanku : "hadoop" is the root password of mysql server in HDP 2.5 sandbox.

View solution in original post

2 REPLIES 2

avatar
Super Guru

@sujitha sanku

set the new password for root user using the following command

mysqladmin -u root -h localhost password 'newpassword'

avatar

@sujitha sanku : "hadoop" is the root password of mysql server in HDP 2.5 sandbox.