Unable to call mysql command line with credentials from mysql_clientdb.conf

Discussion in 'ISPConfig 3 Priority Support' started by jaypabs, Jan 5, 2023.

  1. jaypabs

    jaypabs Member

    I have the following error when running ispconfig_update.sh --force:
    Code:
    >> Update
    
    Operating System: Ubuntu 22.04.1 LTS (Jammy Jellyfish)
    
    This application will update ISPConfig 3 on your server.
    
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: no
    
    MySQL master server hostname [server1.mydomain.com]:
    
    MySQL master server port [3306]:
    
    MySQL master server root username [root]:
    
    MySQL master server root password []: mypassword
    
    MySQL master server database name [dbispconfig]:
    
    Checking ISPConfig database .. WARNING: Forcing protocol to  TCP  due to option specification. Please explicitly state intended protocol.
    mysqlcheck: Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect
    OK
    WARNING: Forcing protocol to  TCP  due to option specification. Please explicitly state intended protocol.
    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    Unable to call mysql command line with credentials from mysql_clientdb.conf
    
    I run this command after migrating master server to a new server. Just wondering what I am missing since I have the correct password.
    Any idea about this error?
    BTW, I'm running this on server 2 which also server as master in a master <> master server replication.
     
  2. jaypabs

    jaypabs Member

    Never mind. I already fixed it. I forgot to change the password in the ISPConfig file.
     
    till likes this.

Share This Page