leonsmith
Posts: 22
|
| Posted: 02/20/2006, 4:11 PM |
|
I had a project working well. I bought a new, faster computer and transferred everything over to it the "right" way meaning reinstalled mysql driver, code charge, pulled my projects from my cvs server, etc.
Now I am getting the dreaded "provider initialization error access denied for user..." when trying to connect to my database.
I am using the exact same settings on my db utility sqlYog, and it tests fine as does the ODBC test. The database is on a remote server so my new computer is not the culprit there.
From reading this forum extensively I have deleted the connection and added it again, even going into the .css file and checking the settings there with a text editor. I have tried with username and password on the first pane and without.
I have turned off my firewall and anti-virus even though I was able to connect with other programs and that had no effect. I simply cannot find anything wrong.
You cannot believe how frustrating this is. Any ideas will be much appreciated and investigated.
Thanks, Leon.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 02/21/2006, 11:12 AM |
|
leonsmith
Don't forget that you can always contact support to see if they may be able to help you???
|
|
|
|
matheus
Posts: 386
|
| Posted: 02/21/2006, 11:32 AM |
|
Look IP table permission to database.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
leonsmith
Posts: 22
|
| Posted: 02/21/2006, 11:40 AM |
|
Thank you mamboBrown, I just did submit a support ticket. I thought the forum might be faster, but...
matheus - This is a database hosted by a provider and they don't give me remote access to the system tables. But, like I said, I have other utilities on my development machine that can access the database just fine with the same settings and ODBC has a test feature that works with these settings, AND my previous version of codecharge on the old machine works fine.
The main difference is that the new machine is running Windows 2000 Pro and my old one was running Windows ME. Even so, I connect with other apps on the new machine.
|
|
|
|
Will
|
| Posted: 02/21/2006, 4:14 PM |
|
What version of PHP/MySQL are you using ?
You wouldn't happen to be using PHP 4 with MySQL 4 ?
|
|
|
|
leonsmith
Posts: 22
|
| Posted: 02/21/2006, 4:43 PM |
|
Will, I'm using MySQL 4.0.26 and PHP 4.something, so yes, but I get this error from within CodeCharge when I try and create or edit a connection. I don't think they are using PHP at that point.
Why do you ask ? Is there a problem with that combination ?
Thanks for the response.
Leon
|
|
|
|
Will
|
| Posted: 02/21/2006, 5:12 PM |
|
Hi Leon,
Yes, there's a known issue with that combo, as the MySQL authentication changed with that version. PHP 4 uses an outdated mysql.lib, so the hashing algorithm matches MySQL 3.x, not 4.x.
The way I solved the problem was to change the user password to use the old algorithm.
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Before you run this, you might want to check the length of the hashed password stored against your mysql user account to see if it's using the old or new encryption mechanism.
Hopefully this will work for you.
Cheers,
Will.
Quote leonsmith:
Will, I'm using MySQL 4.0.26 and PHP 4.something, so yes, but I get this error from within CodeCharge when I try and create or edit a connection. I don't think they are using PHP at that point.
Why do you ask ? Is there a problem with that combination ?
Thanks for the response.
Leon
|
|
|
|
leonsmith
Posts: 22
|
| Posted: 02/22/2006, 5:49 AM |
|
Well I got responses from Tech support at YesSoftware and from my web host and both tell me to try the things that I told them I already tried. After wasting days on this I am installing a local copy of mysql so I can get going again. I guess I will never know why it stopped working. Thanks to everyone that responded - very much appreciated.
|
|
|
|
|
