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?