Support Questions

Find answers, ask questions, and share your expertise
Announcements

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
Super Guru

@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
Super Guru

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