HDP 2.6.5. Mysql. Password for the root user

[#1]

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]

@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

[#3]

@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!!!!!