upgrade uses different db host

you have to change the access rights via phpmyadmin. i wrote something about it when i upgraded to 2.2.2 but it should apply to 2.3 as well.

no guarantees though so take precautions.

Presumably, if upgrading, you’d use the exact same settings in wp-config.php as you were previously.

Have you changed something in it?

Don’t know why Yahoo does this but the user they put in wp-config.php does not have all the rights to drop/create tables.

So with that said, and as is illustrated on headlessspider’s post, use phpMyAdmin to access the ‘mysql’ database and the ‘user’ table, and edit the DB_USER in your wp-config.php file so that it is given ALL the rights/privileges. That means saying Y to each privilege field (I believe those ended in _priv so DROP_priv would be an example.)

Then you should be able to run the upgrade.

It’s a privileges issue.

headlessspider, I see what you’re saying but my mysql db has no files in it. The blog db has 20 tables but none say users. I have a wp_users but that’s not it. It seems yahoo corrupted it but not sur.

There should be a mysql database (and yes there is your wordpress database also) and the user table is in that.

Please note, if you can’t find it, then FIRST do a backup of the database. Then make sure you have a backup of your database. And after you know you have a backup of your database, call Yahoo support.

Did you note my recommendation to get a backup of your database ??

Resource:
Backing_Up_Your_Database

Under my mysql db, it shows just this:

Error
SQL query:
SHOW TABLE STATUS FROM mysql ;
MySQL said:

#1044 – Access denied for user ‘yscr_bbe5Tp’@’localhost’ to database ‘mysql’

but my config file said host is mysql.

You have to login as the Database Administrator as you defined it in the Yahoo control panel. If you don’t know the Database Administrator password, change it to a known value and then login to phpMyAdmin using the Database Administrator.

But please do a database backup first!

Yes, I have a db backup. I restored it a few times. I hope that didn’t do it. Problem is it’s not my account. I’m doing it for another person. I guess I have to use her email for tech support. I hate yahoo.

Um, yahoo set the info. I’m using what they put in config. Here’s my config.

// ** MySQL settings ** //
define(‘DB_NAME’, ‘blog’); // The name of the database
define(‘DB_USER’, ‘xxxx’); // Your MySQL username
define(‘DB_PASSWORD’, ‘xxxx’); // …and password
define(‘DB_HOST’, ‘mysql’); // 99% chance you won’t need to change this

I need the mysql db login? is that it?

when I go to Database administrator, it just shows a blank for user & pw.

Ah, found it. yahoo is screwy!

yes they are. ??

Thanks guys!