Title: DATABASE CONNECTION FAILED! Last modified: August 22, 2016 --- # DATABASE CONNECTION FAILED! * [PremiumExport](https://wordpress.org/support/users/premiumexport/) * (@premiumexport) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/) * Hi, I’m moving my site from local to live, but i’ve had some issues with connecting to my new database. I’ve also tried a “clean” wp install and it still wont connect to database. I am 100% sure I’ve entered the right database name, address and password. * I dont know if this is relevant, but I’ve cleaned the domain from ExpressionEngine and the database I’m going to use is the same that was once used with EE. (I have deleted all the tables from the database) * server code: 200 status: OK response: INSTALL ERROR! DATABASE CONNECTION FAILED! The server requested authentication method unknown to the client * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/) Viewing 15 replies - 1 through 15 (of 15 total) * [Mark](https://wordpress.org/support/users/mharris_wlaes/) * (@mharris_wlaes) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294542) * I’m having exactly the same problem. * I’ve taken the dbname, host location, db username and password from the wp_config file on my new GoDaddy install so I know these are correct. * Help!?! * [JohnnyP](https://wordpress.org/support/users/johnpottermedia/) * (@johnpottermedia) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294605) * same thing has happened to me on ipower.com server. What happened to the plugin? It was awesome until today! * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294650) * Hey Guys, * Nothing has changed with 0.5.6 for the last few months and the next version will also have no changes around this portion of the plugin, this is most likely related to how the connect is made to your host. I have test on 4 separate hosts without issues… * I would double check with your host and see if they have changed anything. They will give you the exact credentials you need to connect. Every host is different and needs the **exact** settings or else it won’t work. The test connection call is a very generic PHP call so their really isn’t anything in the plugin that can be updated/fixed… * Also be sure your host has not changed anything around how they use the mysqli lib. * Hope this helps! * [smelsworst](https://wordpress.org/support/users/smelsworst/) * (@smelsworst) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294713) * I’d like to echo this problem. * To help us hone in on a solution, a couple of questions to the others: Who is your host? Looking to duplicate a single site or an entire multisite network? which version of WordPress are you all working with? * [@cory](https://wordpress.org/support/users/cory/): you first mention “exact credentials” and then mention “exact settings” – are you referring to something beyond the credentials when you say “settings” or were you using the terms interchangeably? Should our host/s have not changed anything around mysql lib, what would be your next guess.. seems interesting to have four separate parties all report suddenly experiencing the same problem for the first time within the last week. * [JohnnyP](https://wordpress.org/support/users/johnpottermedia/) * (@johnpottermedia) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294714) * Just learned it was a problem at my hosting company. They updated the php from 5.3 to 5.5 and when they turned it back to 5.3 for me the plugin worked fine. Hope this helps. BTW. I love the Duplicator Plugin and willing to pay for pro version * [Celeste1212](https://wordpress.org/support/users/celeste1212/) * (@celeste1212) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294715) * My hosting service is Hostgator and php is 5.4.32. I haven’t tested the recent version of Duplicator yet, but I’m wondering if anyone else has version 5.4.32 and has updated Duplicator without any problems. Thanks 🙂 * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294716) * The code around the installers “Test Connection” is pretty basic and hasn’t changed in several versions, The call basically uses the [mysqli_connect](http://php.net/manual/en/mysqli.construct.php) function. * If its not working on a specific PHP version then it may be that when that PHP version was built it wasn’t compiled with mysqli lib support. You would need to double check with your host and you can also validate with a [php_info](http://php.net/manual/en/function.phpinfo.php) call. * If you have validated the credentials with you host and they say their good to go and the mysqli lib is installed, I can have a look at your system, but I’m not quite sure what I can do at this point… * [smelsworst](https://wordpress.org/support/users/smelsworst/) * (@smelsworst) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294726) * okay.. i was actually trying to move a multisite network. turned out that when I commented out the multisite lines in wp-config, I could connect (albeit, only to site-1). Still chasing down the issue which will likely have something to do with updating references to the base URL in the DB or a clash somewhere of site IDs between site and DB. i.e. nothing to do with this plugin and only echoes Corey’s previous claims that this plugin isn’t the best for multisite 😉 I knew the risk I was taking and gambled anyway. * For future multisite folks that try to move using this otherwise awesome plugin, and that encounter this problem, all is not lost! I’d suggest also checking out the below two links: [http://goo.gl/8FkqW9](http://goo.gl/8FkqW9) [http://goo.gl/rSvK6L](http://goo.gl/rSvK6L) * I’d otherwise had plans to test whether simple moves (i.e. single site backup& redeploy) were still working for me or not, but I haven’t had the chance – my assumption is it’ll work fine and it was only that I was trying to be too clever. * hope you guys can get your moves sorted out! * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294728) * Thanks for posting the work-arounds [@smelsworst](https://wordpress.org/support/users/smelsworst/)! * Cheers~ * [smelsworst](https://wordpress.org/support/users/smelsworst/) * (@smelsworst) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294729) * I resolved mine by doing a manual move of my network, I haven’t retested with Duplicator but I have a suspicion the plugin works ‘fine’ for moving a multisite network, except that the user just has to go into their DB and update a number of links that Duplicator doesn’t get, namely: * – wp_blogs – wp_site – wp_options _ wp_x_options (one for each blog in the network) * Ben * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294730) * I think a better option for MU sites is [NS Cloner](https://wordpress.org/plugins/ns-cloner-site-copier/). Duplicator isn’t really wired for MU setups at this point in time. * [smelsworst](https://wordpress.org/support/users/smelsworst/) * (@smelsworst) * [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294731) * NS Cloner is awesome for copies of blogs/sites within a network, but the use case I’m describing is about copying/backing-up/moving the network (incl. to a different server or directory). From what I can tell (and god knows I’ve tried!), NS Cloner isn’t up to that task. * I think Duplicator can do the job, it’s just not plug-and-play like it is on single sites – so admins have to be happy to jump into the DB. after running installer.php * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294732) * Hey smelsworst, * If you want to put together a list of things that you are having to do manually and just send me an email or put it in a ticket here: lifeinthegrid.com/support( refer to this thread) * I’ll see if I can improve the migrations for MU… * Cheers~ * [smelsworst](https://wordpress.org/support/users/smelsworst/) * (@smelsworst) * [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294735) * It’s probably a little dependent upon which plugins are installed/etc.. but the main things are: * DB Changes: – _wp\_site_: update values for _domain_ and _path_ – _wp\_blogs_: update values for _domain_ and _path_ for each sub-site/blog – _wp\_x\_options_( one for each sub-site/blog, where x is the _blog-id_): update values for _option\ _name like ‘siteurl’_, _option\_name like ‘home’_, _option\_name like ‘upload\ _url\_path’_ and there’ll be others if you’ve got things like woocommerce, etc. installed, but the user can also update these via the _network admin>sites>SITE\ _NAME>edit>settings_ themselves.. * wp-config.php will need to be updated: _define(‘DOMAIN\_CURRENT\_SITE’, ‘NEWVALUE’); define(‘PATH\_CURRENT\_SITE’, ‘NEWVALUE’); * the rest of the multisite lines in wp-config.php should not need to be changed. * AND, seems that many users (myself included) have issues with the .htaccess file, so that might also need to be updated, see here: [http://codex.wordpress.org/Multisite_Network_Administration#.htaccess_and_Mod_Rewrite](http://codex.wordpress.org/Multisite_Network_Administration#.htaccess_and_Mod_Rewrite) * once you’ve done that it “should” work, but for me, it’s still not – likely something up with the rewrite rules in .htaccess. time for the ametur to step out of the way and pay for a professional! * hope that helps. * [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * (@corylamleorg) * [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294743) * Thanks Ben! I’ll also look at the info from linked in… * Cheers~ Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘DATABASE CONNECTION FAILED!’ is closed to new replies. * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985) * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/) * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq) * [Support Threads](https://wordpress.org/support/plugin/duplicator/) * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/) * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * 15 replies * 6 participants * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/) * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/database-connection-failed-2/#post-5294743) * Status: not resolved