Greetings for the festive season!! I am using JDBC driver for
integrating MySQL with IDM 4.0.2. We are using "indirect" approach. User
has been created successfully & everything logs shows fine. But when we
try to login in mysql server with user created by JDBC driver, It is not
allowing to login with IDM credentials. It displays error as follows:
-------------------------------- linux-tyya:~ # mysql -u Kumar5 -p Enter
password: ERROR 1045 (28000): Access denied for user
'Kumar5'@'localhost' (using password: YES)
-------------------------------- Below is the entry for this user as
follows: mysql> select * from user where User='Kumar5';
+-----------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| Host | User | Password |
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv |
Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv |
Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv |
Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv
| Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher |
x509_issuer | x509_subject | max_questions | max_updates |
max_connections | max_user_connections | plugin | authentication_string
|
+-----------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| % | Kumar5 | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N
| N | N | N | N | N
| N | N | N | N | N |
N | N | N | N | N |
N | N | N | N
| N | N | N | N
| N | N | N | N
| N | | | |
| 0 | 0 | 0 |
0 | | NULL | | localhost | Kumar5 |
| N | N | N
| N | N | N | N | N |
N | N | N | N | N | N
| N | N | N | N
| N | N | N | N
| N | N | N | N
| N | N | N |
| | | | 0 |
0 | 0 | 0 | | NULL
|
+-----------+--------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
mysql> SHOW GRANTS FOR 'Kumar5';
+-------------------------------------------------------------------------------------------------------+
| Grants for Kumar5@%
|
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'Kumar5'@'%' IDENTIFIED BY PASSWORD
'*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' | | GRANT SELECT ON
`indirect`.* TO 'Kumar5'@'%'
|
+-------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec) I also tried to change password in mysql DB
directly using SET PASSWORD command but still unable to login. Any
help would be appreciated!!


--
rajeshemailto
------------------------------------------------------------------------
rajeshemailto's Profile: https://forums.netiq.com/member.php?userid=196
View this thread: https://forums.netiq.com/showthread.php?t=46439