Since OVA images for mysql had its defaults, changing the root password from phpmyadmin seems not enough. Changed also: /usr/local/ispconfig/server/lib/mysql_clientdb.conf Did a mysql> update mysql.user set plugin = ‘somelongpass’ where user=‘root’; Still seeing in ISPc System log the following: Unable to connect to mysql: Access denied for user 'root'@'localhost' (using password: YES) What else needs to be done? Thanks
This sql query is wrong. The plugin field does not contain the MySQL password. Use phpmyadmin user manager to change the password or use the command: mysql_secure_installation
