Incorrect user password

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

Error: ERROR 1045 (42000)

Error message

ERROR 1045 (42000): Access denied for user 'NY'@'xxx.xxx.xxx.xxx' (using password: YES)

Examples

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

[admin@k08j13249.eu95sqa /home/admin]
$obclient -h10.0.0.0 -P2881 -uny@Oracle -p -A
Enter password:
ERROR 1045 (42000): Access denied for user 'NY'@'xxx.xxx.xxx.xxx' (using password: YES)

Troubleshooting procedure

1. Log on as the SYS user.

   [admin@k08j13249.eu95sqa /home/admin]
   $obclient -h10.0.0.0 -P2881 -usys@Oracle -p -A
   Enter password:
   Welcome to the OceanBase.  Commands end with ; or \g.
   Your OceanBase connection id is 3221583856
   Server version: OceanBase 4.0.0.0 (r100000172022101218-6ab80a3950710941946c004d805fcfded7a4aa2c) (Built Oct 12 2022 18:43:39)
   
   Copyright (c) 2000, 2018, OceanBase Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   

2. Modify the password of the ny user.

   obclient> ALTER USER ny IDENTIFIED BY ***3***;
   Query OK, 0 rows affected
   

3. Log on as the ny user again.

   [admin@k08j13249.eu95sqa /home/admin]
   $obclient -h172.30.xxx.xxx -P2881 -uny@Oracle -p -A
   Enter password:
   Welcome to the OceanBase.  Commands end with ; or \g.
   Your OceanBase connection id is 3221583856
   Server version: OceanBase 4.0.0.0 (r100000172022101218-6ab80a3950710941946c004d805fcfded7a4aa2c) (Built Oct 12 2022 18:43:39)
   
   Copyright (c) 2000, 2018, OceanBase Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.