Logging in to the EUM database manually
1. From $EUM_HOME/mysql/bin folder run the below command:
./mysql -u root -p eum_db --protocol=TCP --protocol=TCP -P [EUM-MySQL-Port]
2. When you execute this command, it will ask you for your EUM user password to log in. provide eum_user_password:[plain eum_user password],
3. The default EUM-MySQL-Port is 3388.
Changing the EUM root user database password.
If you wish to change the EUM root user db password, follow the steps below:
Usually, EUM doesn’t need a root user password and changing it can a little tricky. However, if you know the current root user password and you wish to change the EUM root user db password, you can change it by logging in as the root user (not the EUM user) and following the steps below:
1. Log in to the EUM db as the root user (not as eum_user) using the command below:
./mysql -u eum_user --password eum_db --protocol=TCP -P [EUM-MySQL-Port]
2. Next, run the below query:
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass')WHERE User = 'root' AND Host = 'localhost';
If you do not know the current root user password, then it's a bit tricky because EUM MySQL does not have any startup command separately so starting it in unsafe mode would be a difficult task that we do not have steps for.
