or if you would like, try running this query on mysql.
SET PASSWORD FOR some_user@some_host = OLD_PASSWORD('your_old password_here');
are you using mysql 5?
Main Topics
Browse All TopicsI have 3 active blogs on addon domains. The parent domain is http://www.mistywindow.com
2 blogs are OK, but the one at the add-on domain http://mywitsend.co.nz gives this error when opening in a browser:
"Error establishing a database connection"
1. I had not made any changes to this blog (or anything else) since the last successful logon in a browser. It therefore seems likely that there's been a glitch at the server end.
2. I have run a database repair but it didn't fix the problem.
3. Bluehost gave this reply:
"We apologize for the trouble you've been having, there was a bump in the msql service all should be working now however"
4. I advised them that it hadn't fixed the problem and they ignored my plaintive cries for several days.
Eventually they suggested that I:
"logon and change the theme to default then back and everything should work."
5. If I login here:
http://mywitsend.co.nz/wp-
Logging on appears to work, but I can't actually go anywhere from the logon. I get a "back to mistywindow" link which goes to a blank page.
:o(
I've tried going directly to various PHP pages after logging on. No joy.
If any Expert wishes to logon to my Control Panel or the blog I'll send logon details off-list.
I have a current backup of the whole site. Unfortunately, it's supposed to be a 150MB compressed file but it's only half that size and won't extract.
Bugger.
Can someone help? Or do I need to bite the bullet and get on with my life?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I think I'm out of my depth here.
1. An install bug.
I don't understand. My knowledge of PHP is very limited - MySQL zero. This blog has been in successful use since the last upgrade to WordPress 2.5.1.
2. BlueHost is running MySQL5. The current password seems to work. It's just that logging on doesn't take me anywhere.
Just to confuse the issue (for me at least). I have 5 MySQL databases and I can't figure out in cPanel which belongs to this particular blog.
A little knowledge is a dangerous thing...
:o(
3.
you need to look for the prefix that you had given while installing it. If its default, it should have a wp_yourdatabasename or wp_youtablename within our databases. If you go to phpmyadmin and look at the databases you will see that.
Once in the database, run the sql for that database I have posted above.
thanks
That's another problem syedasimmeesaq. See this new question:
http://www.experts-exchang
:o)
>>>>OK. I now know which database I'm working with.
if you know the database, go to phpmyadmin. click on the database name and then click SQL and run the above query by just copying and pasting from here
SET PASSWORD FOR some_user@some_host = OLD_PASSWORD('your_old password_here');
change some_user@some_host with your username and 'your_old password_here' with your old password
I get this when I use my site logon and similar if I use my blog logon:
__________________________
SQL query:
SET PASSWORD FOR mistywin = OLD_PASSWORD( 'myOldPassword' )
MySQL said: Documentation
#1044 - Access denied for user 'mistywin'@'localhost' to database 'mysql'
__________________________
Attached is the wp-config.php file. Looks alright to me, but what do I know? !
I note that the size of this database is about half that of my other blogs, but this one should be the biggest. It had more posts and more comments. Not a good sign I suspect.
try this
SET PASSWORD FOR mistywin_wrdp1 = OLD_PASSWORD( 'k2FXYPZfWrR4' )
Option 2:
if that doesn't work then go to myadmin and add a user and give the user the previllages that you want to give him. Make sure the user have previlages to this database mistywin_wrdp1 then in your configuration file change this part
define('DB_USER', 'Newuser');
define('DB_PASSWORD', 'Newpassword');
XXXXXXXXXX
by the way just looking at your config file you mentioned your username in query is
mistywin
where as in your configuration file it shows the user as
mistywin_wrdp1
maybe you just want to change the user name in configuration file first and see if that works. If not try what I suggested above
Hope it helps
Thanks for your patience.
I'd already tried that first option logon and password.
I'll now try your option 2. May take a while for me to figure it out. I'll probably wait until I get another reply from BlueHost - sometime next century - before making any changes. Just in case I stuff things up further OR BlueHost say that I have.
Bluehost have been no help and communication with them is so slow as to be useless. They can't log onto my database using my logon details.
The same problem occurred with this same blog some months ago.
I got this answer after Bluehost went in and changed the password:
"Generally speaking this will happen for only one of two reasons: Either the password associated with the user name was changed somehow, or someone changed the password in the wp-config.php file. Chances are the password simply became corrupted and needed to be refreshed."
Great.
Current situation:
1. I tried to reset the password as suggested above without success.
2. Now, instead of the original error message I just bet a blank screen if I go to the blog's URL.
3. If I go here: http://mywitsend.co.nz/wp-
4. If I click on the lost password link I get an email with a reset link: http://www.wp-login.php/?a
That link doesn't exist.
I am resigned to probably having to set up this blog again from scratch, but would be very pleased if I could recover the text of my posts.
@ syedasimmeesaq:
You said above:
"..... go to myadmin and add a user and give the user the privileges that you want to give him......"
If you mean my blog Admin, I can't access the site so I can't do that.
Or am I misunderstanding you?
I can only access this blog, which is an addon domain, from my host's control panel.
Business Accounts
Answer for Membership
by: syedasimmeesaqPosted on 2008-06-04 at 11:06:42ID: 21712465
It's an install bug. You'll have to edit the database and change the domain and path settings manually.