Home / server / Questions / 247787
Accepted
hourback
Asked: 2011-03-16 11:48:18 +0800 CST

Can't connect to MySQL 5.0 with ColdFusion 6.1 + JRun

  • 772

Obviously, this is not a desirable platform in 2011. :-) HOWEVER. . . .

I was using ColdFusion 6.1 and JRun to connect to MySQL on another host. It seemed like it connected okay, but I kept getting:

[]java.sql.SQLException: Invalid authorization specification: Access denied for user 'user'@'hostname' (using password: YES)
mysql jrun coldfusion

1 Answers

  1. Best Answer

    Turns out that connecting with a user having no password worked. After looking at MySQL documentation and trying out a few things, I still couldn't get passwords to work, even using "OLD_PASSWORD()". Guess I'm stuck with a password-less login for now.

    • 1