Mysql database issue and solution

We have noticed that, some mysql installations does not allow us to connect as root.
So, we updated the installer to overcome that (Ver 0.37.10.b).

Tha problem is described shortly at http://ubuntuforums.org/showthread.php?t=2275033&p=13272495#post13272495

If you live problem in adding mysql db’s, in your existing ehcp installations, you need to run:

shell$ sudo mysql -u root

(
If you are unable to connect as mysql root, try to run mysql in safe mode:
mysqld_safe –skip-grant-tables &
and then, login.
Later on, restart mysql to switch normal mode
)

[mysql] use mysql;
[mysql] update user set plugin=” where User=’root’;
[mysql] flush privileges;