How to Change MySQL Root Password on Oracle Big Data Appliance

Asset ID:	1-71-1611295.1
Update Date:	2018-05-01
Keywords:

Solution Type Technical Instruction Sure

Solution 1611295.1 : How to Change MySQL Root Password on Oracle Big Data Appliance

Applies to:

Big Data Appliance Hardware - Version All Versions and later
Linux x86-64
Currency Check on April 2016

Goal

Goal of this document is to provide the steps for changing mysql root password on Oracle Big Data Appliance(BDA)

Solution

Requirement on BDA is that MySQL database root password associated with locathost and root password associated with explict hostnames of ALL the BDA nodes needs to be the same.

Note: In the steps below if the new password contains special characters, then to avoid errors it is necessary to use single quotes like:

mysqladmin -u root -p'<old-pwd>' password '<new-pwd>'

For MySQL command usage please refer to http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html

1) Alter MySQL root password of local host .

a) Below command needs to be executed on node03(As root or oracle OS user) to change mysql root password of localhost to the desired new password.

mysqladmin -u root -p'<old-pwd>' password '<new-pwd>'

Sample command of changing password from welcome1 to oracle

mysqladmin -u root -p'welcome1' password oracle

2) Log into node03 as oracle OS user then log into MySQL database as root user

$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is **
..........
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

3) Alter MySQL root password associated with explict hostnames of ALL the BDA nodes

Please note that you need to use the fully qualified domain name of each of the nodes in the update statements

update mysql.user set password=PASSWORD("<new_pwd>") where User = 'root' and Host = '<fqdn-of-node-1>';
update mysql.user set password=PASSWORD("<new_pwd>") where User = 'root' and Host = '<fqdn-of-node-2>';
.....
update mysql.user set password=PASSWORD("<new_pwd>") where User = 'root' and Host = '<fqdn-of-lastnode>';

Sample update command output

mysql> update mysql.user set password=PASSWORD("oracle") where User = 'root' and Host = 'bdanode.us.oracle.com';

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

4) Reloads the privileges from the grant tables in the mysql database.

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

5) Ensure local and explict host mysql root passwords match

mysql> SELECT User, Host, Password FROM mysql.user where user='root';

6) Exit from MySQL database

mysql> exit
Bye

Attachments

This solution has no attachment