ricknew Posted February 28, 2013 Share Posted February 28, 2013 Hi Folks, Ran an install at Media Temple hosting which went just fine. Downloaded the remote files to my local machine. Updated Config.php for external DB access. I'm getting the following error when trying to run the site: Exception: DB connect error 2000 - mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file (in \Projects\UntyeNet\wire\core\ProcessWire.php line 96) I tried updating my password as I think the error message suggests, but no luck. Any one else run into this issue or have an idea for a fix? Thanks! Rick Link to comment Share on other sites More sharing options...
ricknew Posted March 1, 2013 Author Share Posted March 1, 2013 Looks like my local version of PHP (5.3) wasn't compatible with mySQLs authentication approach. I rolled back to PHP 5.2 and the error is resolved. 1 Link to comment Share on other sites More sharing options...
diogo Posted March 1, 2013 Share Posted March 1, 2013 Not the ideal solution though... Maybe something went wrong when you installed PHP? Link to comment Share on other sites More sharing options...
ricknew Posted March 2, 2013 Author Share Posted March 2, 2013 Agreed. How would I figure out if something went wrong with the PHP install? It seems to be running fine except for the connection issue. Link to comment Share on other sites More sharing options...
Pete Posted March 2, 2013 Share Posted March 2, 2013 I'm not sure how to troubleshoot that but I do believe ProcessWire will require PHP 5.3 minimum at some point in the not-too-distant future so I'm hoping someone can help you with the 5.3 issue you encountered. You should be fine for now though but thought that that was worth mentioning. Link to comment Share on other sites More sharing options...
ryan Posted March 2, 2013 Share Posted March 2, 2013 Exception: DB connect error 2000 - mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Media Temple isn't still using MySQL 4.1 are they? I thought they finally switched to 5 about a year ago. I had a client there that was using a legacy application that was not MySQL 5 compatible. Media Temple's little "change" broke their entire site. I had to setup a MySQL 4.1 server for them elsewhere just to bring it back. Link to comment Share on other sites More sharing options...
ricknew Posted March 2, 2013 Author Share Posted March 2, 2013 The issue is only on my local machine. The site runs fine on Media Temple with PHP 5.3. I've just installed a fresh version of XAMPP so I'm confused at what's going on. I'm moving over from .NET, so this world is new to me. Link to comment Share on other sites More sharing options...
ricknew Posted March 3, 2013 Author Share Posted March 3, 2013 Created a local database for PW and everything now works fine, even when running on PHP 5.3. I still don't understand why I can connect to MT mySQL on the remote server but not locally (PHP 5.3 on both servers) MT is running mySQL 5.1.66 Link to comment Share on other sites More sharing options...
ryan Posted March 4, 2013 Share Posted March 4, 2013 Created a local database for PW and everything now works fine, even when running on PHP 5.3. I still don't understand why I can connect to MT mySQL on the remote server but not locally (PHP 5.3 on both servers) MT is running mySQL 5.1.66 Are you actually trying to connect to MT's MySQL server from outside of MT's network? I'm guessing they don't allow outside connections to their MySQL servers. Actually, I'm almost sure of it, as I've tried before (though it was while ago). Link to comment Share on other sites More sharing options...
ricknew Posted March 4, 2013 Author Share Posted March 4, 2013 Yes, I was trying to connect outside of the network.. However, MT does provide an external hostname and an allowed IP list for external access. There seem to be a lot of folks running into the "Exception: DB connect error 2000 - mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication." issue,but none of the fixes worked for me. Some of the fixes require access to the DB configuration settings which cost extra at MT. Thanks. On another note, I'm enjoying delving into the Blog Profile setup. It's a great way to start understanding PW. For my first foray into PHP you've made a really nice space to learn. Link to comment Share on other sites More sharing options...
OrganizedFellow Posted March 4, 2013 Share Posted March 4, 2013 @ricknew Why would you need to connect to Media Temple MYSQL from your XAMPP localhost? If you create a dump from the site and import it to your localhost, your connects will be MUCH faster. I'm sure you are running it locally for testing/development, right? Link to comment Share on other sites More sharing options...
ricknew Posted March 4, 2013 Author Share Posted March 4, 2013 Hi OrganizedFellow, I don't need to connect to the MT mySQL (staging) instance, but I'd like to have that option. It bugs me that I can't make a simple remote connection. Link to comment Share on other sites More sharing options...
OrganizedFellow Posted March 5, 2013 Share Posted March 5, 2013 Hi OrganizedFellow, I don't need to connect to the MT mySQL (staging) instance, but I'd like to have that option. It bugs me that I can't make a simple remote connection. I'm sure it's a security issue with MediaTemple. I once tried that same scenario, to connect from my localhost LAMP install, to my webhost MySQL database. Everything I tried would NOT work. I finally decided to LiveChat with a host rep and they said it was disabled would could be turned on on a case-by-case basis, as long as I submitted a ticket request. Link to comment Share on other sites More sharing options...
ricknew Posted March 5, 2013 Author Share Posted March 5, 2013 I talked with the MT support folks, too. They allow for remote connections, have an "external" hostname and have a field for allowed IPs. Nonetheless, everything I tried would NOT work either :-( Link to comment Share on other sites More sharing options...
OrganizedFellow Posted March 5, 2013 Share Posted March 5, 2013 Windows firewall would be my last guess. Maybe your antivirus disables that connection also?! Link to comment Share on other sites More sharing options...
ricknew Posted March 5, 2013 Author Share Posted March 5, 2013 "Exception: DB connect error 2000 - mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication." I don't think there are any firewall or AV issues. The connection is happening. It is the authentication that is failing. Link to comment Share on other sites More sharing options...
Joss Posted March 5, 2013 Share Posted March 5, 2013 Sounds like you have a password incompatibility problem - there is a different character length between versions. Have a search on Stack Overflow - there are a lot of posts about this - maybe one will help you. Link to comment Share on other sites More sharing options...
ricknew Posted March 5, 2013 Author Share Posted March 5, 2013 Thanks Joss. I've been through those threads, but I need access to a file on MT that isn't available with my plan. The local DB solution should be fine for now. Link to comment Share on other sites More sharing options...
jacksprat Posted July 21, 2013 Share Posted July 21, 2013 Yes, check the password length for mysql. SELECT user, Length(`Password`) FROM `mysql`.`user`; SHould be a 41 character field. If not see the link below. http://blog.mixu.net/2010/06/06/quick-tip-how-to-fix-mysqlnd-cannot-connect-to-mysql-4-1-using-old-authentication-onphp5-3/ 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now