Articles in this section

"Invalid authorization specification, message from server: "Access denied for user (using password: YES)""

Brad Alexander
  • Updated
Follow
  1. Product Version:
    2. ServosityPro: All
    OS: All platforms
  2. Problem Description:
    3. When performing a mysql database backup, the following error message is received in the backup report:
    Backup Logs
     No.  Type  Timestamp  Backup Logs
    1 Info YYYY/MM/DD hh:mm Start [ All platform (Test), ServosityPro 5.x.x.x ]
    2 Info YYYY/MM/DD hh:mm Start running pre-commands
    3 ... ... ...
    *  Error  YYYY/MM/DD hh:mm

    mysqldump: Got error: 1045: Access denied for user
    'root'@'localhost' (using password: YES) when trying to connect
  3. Cause:
    4. The message suggests that the login credentials specified in the "Database Backup Setting" is invalid.

    Example on ServosityOBS management console:


    The issue can also occurs if the mysql password contains non alphanumeric character, such as the equal sign "=" or ampersand "&".
  4. Resolution:
    5. To resolve the issue, please ensure that the login credentials specified in the "Database Backup Setting" is valid.

    In the cases where the mysql password contains non alphanumeric character. Please follow the instructions below:

    1. Change the MySQL password using the follow commands:

      Example with ServosityPro installed on the mysql server:
      >grant all privileges on *.* to 'root'@'localhost' identified by 'new_password';
      >flush privileges;

      Example with ServosityPro not installed on the mysql server:
      >grant all privileges on *.* to 'root'@'ip_address' identified by 'new_password';
      >flush privileges;

      Notes:
      ip_address is the IP address of the machine that ServosityPro is installed on.

    2. In the "Database Backup Setting" of the corresponding backup set, ensure that the hostname entered is "localhost" or IP address of the mysql server

    3. Perform the mysql database backup afterward