Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

HDP 2.6.5. Mysql. Password for the root user

Hi all,

I'm using HDP 2.6.5 docker sandbox and following the cross lineage tutorial (

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?....




@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

@Pedro Andrade

Thanks Pedro. Your instructions gave me the clue but the right one according to the MySQL version installed are in


Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.