ISPc reporting mysql connection issue

Discussion in 'ISPConfig 3 Priority Support' started by markelino, Mar 19, 2020.

  1. markelino

    markelino Member

    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?

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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

Share This Page