Thought some people might find it useful to see how I managed to solve this…
So, this week I determined to do a little more work on the code for this blog – a new plugin. However, as I have recently updated my laptop I needed to re-install all the tools – Eclipse, Ant, XAMPP – and setup the XAMPP test instances of the blog.
I ran up XAMPP and used phpMyAdmin to setup a test WordPress database and user. Then I used Eclipse to edit the wp-config.php file for the XAMPP installation and finally a little ANT script to rebuild the blog into the XAMPP directory.
At this point, I expected to launch immediately in to the blog at “http://localhost:8080/www.kajabity.com” ready to do the setup and install a backup from the live blog to play around with.
No such luck! Instead I got the following:
Well, I tried all the obvious things – checked the password, username, checked everything was up and running. Nothing obvious. I added and removed the user and database several times – but to no avail.
I tried Google – and found a few others with suggestions, but nothing that worked.
But, eventually, I noticed that the one detail was a little odd. When creating the users I had left the “Host” setting to be the default “Any host” – which results in the “Host” column in the Users list showing “%”.
So, I changed the user (using the Edit Privileges link) and set the Host to be “localhost” – using the “Create a new user with the same privileges and … delete the old one from the user tables.” option.
That worked.
I’ve shown the user that worked (wordpress_user) and another one that causes the problem (badwp_user) in the screenshot below:
Hope that helps some of you.
Just wanted to thank you as I was having this problem and it was driving me crazy. Nothing I could find helped aside from this which seems to have been posted just 5 days ago. Just in time!
create a database manually in phpadmin. point that database name in your wp-config.php script and run the script.
Thank you…
The problem may be due to high memory usage and you may not have created the swap file. Follow the link to get the procedure to create swap file
http://teknosrc.com/mysql-linux-ubuntu-crashing-create-swap-space-memory-solution/
Thank you, looked at various fixes but your artitcle helped as I had not set the user to localhost.
Thanks
Thanks very much, you do not just helped me out, youvteqch me something new.thanks ones again.
Thank you, only page that show this real solution. You rock, man!
Hi Simon, Thank you so much for this! Googled allot but this is the only good answer i could find on the whole www.
THANK YOU! It has eaten all my neurons so thank you for postin this.
thank u so much buddy.. wasted my precious 2 hour thanks..
Thank you so much.
All along, I had assumed that Any host meant any host including localhost.
I have been struggling with this for days until your post saved me.
Thank you
Thanks alot. It really solved the issue.
Thank you. With the help of this article the 5-minute ‘easy install’ actually took 3 minutes, plus the 2 hours it took me to find this article.
Thank you .. that worked for me too.
thanks! that did the trick.
THANKS!
Thanks man, this was driving me crazy.
Thank you sooo much! You are my master :))))
Thanks buddy ! It worked for me, I lost so much time trying to figure it out
Thank you so much!