Incorrect user password

This topic describes errors related to an incorrect user password and the troubleshooting procedure.

Error: ERROR 1045 (42000)

Error code

1045

Error message

ERROR 1045 (42000): Access denied for user '%.*s'@'%.*s' (using password: %s)

Example

When you log on as the ny1 user but enter an incorrect password, this error is returned.

[admin@k08j13249.eu95sqa /home/admin]
$obclient -h10.10.10.1 -P2881 -uny1@MySQL -p****** -A
obclient: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (42000): Access denied for user 'ny1'@'xxx.xxx.xxx.xxx' (using password: YES)

Troubleshooting procedure

1. Log on as the root user.

   [admin@**** /home/admin]
   $obclient -h10.10.10.1 -P2881 -uroot@MySQL -p_*******_ -A
   obclient: [Warning] Using a password on the command line interface can be insecure.
   Welcome to the OceanBase monitor.  Commands end with ; or \g.
   Your OceanBase connection id is 3221678880
   Server version: 5.7.25 OceanBase 4.0.0 (r20220110212853-f55615d0df8c3c2ca5dcd6b5dba8f0acd18c6264) (Built Jan 10 2022 22:09:16)
   
   Copyright (c) 2000, 2022, OceanBase and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   

2. Change the password of the ny1 user.

   obclient> ALTER USER 'ny1' IDENTIFIED BY '******';
   Query OK, 0 rows affected
   

3. Log on as the ny1 user again.

   [admin@**** /home/admin]
   $obclient -h10.10.10.1 -P2881 -uny1@MySQL -p****** -A
   obclient: [Warning] Using a password on the command line interface can be insecure.
   Welcome to the OceanBase monitor.  Commands end with ; or \g.
   Your OceanBase connection id is 3221678797
   Server version: 5.7.25 OceanBase 4.0.0 (r20220110212853-f55615d0df8c3c2ca5dcd6b5dba8f0acd18c6264) (Built Jan 10 2022 22:09:16)
   
   Copyright (c) 2000, 2022, OceanBase and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.