MySQL Database - Wordpress error ???

Status
Not open for further replies.

Ashleyuk1984

Active Member
1,242
2010
304
1,020
Hi,
I have hosting with "859compute", the hosting service has been reasonably good with fast speeds and hardly any downtime as such. But I have come across quite a strange problem???

My website has been online with them for just over two months, working perfectly, but recently I got this error...

[slide]http://www.nitropixel.net/wp-content/uploads/2009/03/500-internal-server-error.png[/slide]

(This is not my picture, this is just one I found on Google, but it's basically the same)

So, after loads of tweaking here and there, I still couldn't get this resolved. Thankfully I had made a backup of my website from a few days previous of this error, so I deleted everything, and uploaded my backup... Only to find the same problem ???

So I deleted everything again - including MySQL Databases.
I downloaded the original Wordpress setup files from the Wordpress website, and uploaded them.

I created a new database, I created a new username and password, I assigned that username to the database and gave it all privileges.

[slide]http://releasethread.com/data1.png[/slide]

I then went to the Wordpress setup files, and entered my details EXACTLY how I set them up. Done this numerous times with the same result.
Might be worth mentioning that Database Host is named 'localhost' in PHPMyAdmin, and this is how it was when my website was working, so that hasn't changed from what I can tell.

So, I complete the Wordpress Install page, and I get this page.

[slide]http://releasethread.com/data2.png[/slide]


Username and Password is OK..... It just can't connect to the database server??
It definately exists... The Username has permissions, and yes the username is prefixed... but I have taken that into account.

Anyone got any ideas what might be the problem??
My support ticket is now being looked at, but if they can't solve the problem, then I might have to change host again :(
 
14 comments
Are you doing username_username & username_database ?
Also have you edited your WP_Config.php file so that it matches your sql
 
Hi thanks for your comments, I'm using the Wordpress setup files, that sets up the wp_config.php for me. But when I complete the process, wp_config.php can't find the database that IS there.

"username"_username & "username_database, I presume you mean, the prefix that the server has assigned me.... Yes I am. I'm doing everything correctly - from what I can see anyway.

My prefix is 'releaset' so my database name could be "database" or "123456789", but I will always have to input it as releaset_database or releaset_123456789
 
Yeah your doing that part right then.
Have you tried making a new database and installing a blank wordpress .. just to test it out and see if it is something to do with your SQL or what
 
Yeah, I have deleted EVERYTHING, all files / all databases - EVERYTHING.
I uploaded the setup files from Wordpress.com (to start a totally fresh new blog), and this is the errors that I'm coming up with. It just wont read the database for some reason?? My host is still looking into it, it's GOT to be something on their end. It just makes no sense.
 
wordpress.com or wordpress.org because they are almost two completely different things. one hosts sites with wp cms and one is the cms. assuming you've installed this yourself ill assume you mean .org

delete your DB and all content from your public_html
upload the contents of /wordpress/ from wordpress-3.0.4.zip
dont create a dB via cP, let wp create the dB
prefix, name, server, pw -- all match.
also before you start over, check your htaccess or just delete it to make sure it's not limited anything.
as far as file permissions are concerned:


Name File/Dir Needed Chmod Current Chmod
root directory../0755 755.
wp-includes/../wp-includes0755 755..
htaccess../.htaccess0644 644.
wp-admin/index.phpindex.php0644 644.
wp-admin/js/js/0755 755.
wp-content/themes/../wp-content/themes0755 755.
wp-content/plugins/../wp-content/plugins0755 755.
wp-admin/../wp-admin0755 755.
wp-content/../wp-content0755 755.
all else fails it probably is your host.
 
I am getting same problem for last 3-4days.Before it was working as I got a few wordpress blog hosted on my VPS already.Now when I am trying to add wordpress on a new domain then getting this problem.

I am using servedome vps with kloxo panel.

I am getting same error when trying to install wordpress(it says can't select database).So I tried to use a wordpress backup of my other blog to use on the new domain.Now the website works but can't login into wp-admin using same id&pass.

Now I used the installapp feature from kloxo to install wordpress.After installing from installapp I don't got any confirmation about install.When I visit the website then it says to input Blog title,admin username,email address.But when submit it says I haven't emtered email but I entered my email address correctly

Now I tried mybb install with installapp.The forum got installed but can't login into mybb.

Its not cookie error as I checked both firefox and IE8 after deleting cookie.
 
Just a quick update, I've checked ALL folder permissions, everything is correct on my part.
Yes __Doc_ I meant wordpress.org :-) and I have already done everything that you mentioned. Thanks anyway.

A ticket was submitted with the host on Saturday, still waiting for a response, I will update again when they get back to me with a possible solution.
 
Fixed the problem.Just took a kloxo backup on a remote server and then reinstalled the centos with kloxo.Then restored the backup.Done in 10minute.Now the problem solved.
 
Status
Not open for further replies.
Back
Top