After upgrading MySQL 5.1 to 5.6, trying to start JBoss failed with this exception:
java.sql.SQLException:
Server is running in --secure-auth mode, but 'user'@'localhost'
has a password in the old format; please change the password to the new format
How to fix this issue?
This issue was fixed by:
1) Update the value of the password hash of the 'user' user
UPDATE mysql.user set password = PASSWORD('my password text') where user= 'user';
2) Stop 'mysql' server
/etc/init.d/mysql stop
3) Set the flag old_passwords=1
on the /etc/my.cnf
file
4) Start 'mysql' server
/etc/init.d/mysql start
See also documentation: MySQL password hashing
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With