The @ sign is just what PHPs mysql_error response returns. It represents mysqluser@mysqldatabase. A few things to mention:
– Be sure the mysql user account has access to the database.
– This video explains for cPanel users
– On some hosts ‘localhost’ for the host name doesn’t work you might need to validate with your hosting provider and see what the exact credentials are for connecting to a MySQL server.
– Here is a helpful link as well:
http://codex.wordpress.org/Installing_WordPress
Hope that helps!
Ok, I’ll check those things. By the way, when I use ‘localhost’ in place of the IP address and/or server name, I get:
DATABASE CONNECTION FAILED!
Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Does that mean anything to you?
That error can sometimes indicate that you don’t have a mysql server running at that location…
Sometimes hosts will give you name like this “mysql.s032.example.com” which is how they want you to connect. Most of these issues can be easily solved by finding out your hosts preferred method of connection.
RESOLVED!
Ok, so the resolution to this issue is that you CANNOT deploy to a database that was created via the hosting company’s one-click WordPress installation script. Instead, you must create a stand-alone MySQL database and populate the Duplicator installer script with those values.
In my case, it was Network Solutions. It has to do with the permissions associated with the database that was automagically created (via one-click install). I’m sure you guys have captured this somewhere, but for those searching the forum….this is likely your issue. ; )
Doh! next issue (likely unrelated):
server code: 200
status: OK
response:
Fatal error: Class ‘ZipArchive’ not found in /data/24/2/29/107/2844596/user/3128284/htdocs/wordpress/installer.php on line 572
What does it mean?
Thanks for posting your solution back to the forum for your database issue…
For the installer portion of the tool you don’t need ZipArchive installed. You can use “Manual Extraction” see the User Guide for more details.
Hope that helps!
Yep. I figured that out once I expanded the Advanced features. ; )
Thanks a bunch for your help. I sincerely appreciate it.
cjv
No Problem… Glad you got things going…
Hi
I’m using this great plugin on different servers and while it just works on some setups I have experienced that some hosts does not have mysqli module and ZipArchive compiled into the Apache / PHP build.
The mysqli module will prevent the script from starting as the System requirements check find it. The ZipArchive however throws a runtime error just after you start the scripts.
In most cases you can ask you host to add this if you run on cPanel. If you have a more advanced setup with WHM access (typical for VPS and dedicated servers) you can use the EasyApache (Apache Update) tool to add mysqli module and ZipArchive yourself.
Hey Ivraa,
Thanks for posting the those requirements you are 100% correct…
