For more information, see Using the Apply Immediately setting. This action can cause an extended outage for your Amazon RDS for MySQL instance. Note: If you choose Apply Immediately when updating your cluster configuration settings, all pending modifications are applied immediately (instead of during a maintenance window). Then, choose Password and IAM database authentication and Continue to update your configuration settings. From the Amazon RDS console, you can modify the instance by choosing Database Authentication. Review the configuration settings for your Amazon RDS for MySQL cluster, and make sure that IAM authentication is turned off. Resolution IAM authentication is turned offīy default, IAM authentication is turned off. You can solve the problem by following the above steps.If you can't connect to an Amazon RDS for MySQL or Aurora DB instance using IAM authentication, then check for the following reasons: It is easier to solve the Navicat for MySQL 1045 error in Linux. Refresh the MySQL permission-related table: mysql> flushprivileges Log on to mysql:/usr/local/mysql/bin/mysql-u root mysqlĬhange PASSWORD: mysql> UPDATEuserSETpassword = PASSWORD ('newpswd ') WHEREuser = 'root' If the location of mysqld_safe is different, you can use the find command to find it. Run:/usr/local/mysql/bin/mysqld_safe - skip-grant-tables>/dev/null 2> & 1 & If you want to find a solution suitable for Windows, you can view the article: how to solve the Navicat for MySQL 1045 error. The following method applies to Linux systems. If you do not want to reinstall it, you need to retrieve the password or reset the password. The simplest solution is to uninstall and reinstall the MySQL database, however, the disadvantage is that the information in the database will be lost. When you log on to the MySQL database and see Error 1045, the user name or password you entered is denied access. If you do not want to reinstall it, you need to retrieve the password or reset the password.ġ045-Access denied for user 'root' 'localhost' (using password: YES) When connecting to the MySQL database, Navicat will inevitably encounter a 1045 error, mainly because the user's user name or password is incorrect and access is denied. How to solve the Navicat for MySQL 1045 error in Linux

Navicat 1045