Connecting to database using Eclipse
Posted by: Macamba .
Date: April 07, 2017 03:20AM

I have problems with accessing my database from Eclipse. Before it worked as a charm, but since I wanted to use the contents of my production database in my development I get the following error message:
java.sql.SQLException: Your password has expired. To log in you must change it using a client that supports expired passwords.

What did I do? I exported my production database using phpMyAdmin, dropped the development database, and imported the script containing the production database data.

At the moment I changed the password policy for my account:
mysql> alter user 'macamba'@'localhost' password expire never;
Query OK, 0 rows affected (0.00 sec)
(0 rows probably because I already executed this command yesterday)

I checked the significant field in the mysql.user table with:
mysql> show databases;
| Database           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| mydatabase         |
5 rows in set (0.00 sec)

mysql> use mysql;
Database changed
mysql> select password_expired from user where user='macamba';
| password_expired |
| N                |

Apologies if this question is asked ad infinitum, but I can't find the answer.

1 row in set (0.00 sec)

But still I have no access to the database? What am I missing, doing wrong, need to do to get back my access?

Options: ReplyQuote

Written By
Connecting to database using Eclipse
April 07, 2017 03:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.