Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HDP 2.6.5. Mysql. Password for the root user

HDP 2.6.5. Mysql. Password for the root user

New Contributor

Hi all,

I'm using HDP 2.6.5 docker sandbox and following the cross lineage tutorial (https://hortonworks.com/tutorial/cross-component-lineage-with-apache-atlas-across-apache-sqoop-hive-kafka-storm/).

One of the steps is to create a table in mysql using the root user. The password for root user in MySQL (hadoop) doesn't run. Any clue?....

Thanks!

2 REPLIES 2

Re: HDP 2.6.5. Mysql. Password for the root user

New Contributor

@Jenaro Gallego the root password should be "hadoop" so please check your syntax. You can always change the root password by following these steps:

  1. Stop the MySQL server process with "service mysqld stop"
  2. Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for a password. "mysqld_safe --skip-grant-tables &"
  3. Connect to the MySQL server as the root user. "mysql -u root"
  4. Set a new root password as hadoop:
    1. use mysql;
    2. update user set password=PASSWORD("hadoop") where User='root';
    3. flush privileges;
    4. quit;
  5. stop mysql service: service mysqld stop; killall mysqld
  6. Start service again : service mysqld start

Let me know if it helps solving the issue

Re: HDP 2.6.5. Mysql. Password for the root user

New Contributor
@Pedro Andrade

Thanks Pedro. Your instructions gave me the clue but the right one according to the MySQL version installed are in https://stackoverflow.com/questions/33510184/change-mysql-root-password-on-centos7

Thanks!!!!!