Topic: MySQL-problems after restore

[wyron]

Hi, all
Last week my server grew tired of my config changes.
Suddenly there was no mail going in or out (only the system-generated mail).
I suspected the qmail, the clam and the spamassassin so I restored from an earlier tape onto a fresh installation.
Things only got worse - not even root could access files anymore.
So I rebuilt my 6.0.1-01 from CD, and restored to a separate library (Thanks, Darrell, for making this so easy in your command-line backup-restore howto).
I have since copied the appropriate files back into my installation, including my databases (to /var/lib/mysql).
But I cannot access them anymore !
I have done the setprop thing and restarted MySQL, and granted sql-rights to a user without a password.
My php-scripts use the root-account to access databases, but that doesn't help.
The MySQL just returns (example):
Couldn't access database: gbog
Error: Access denied for user: 'www@localhost' to database: gbog

Anyone know why ???

[ajkeane]

I don't know if this will help mbut try resetting the root password if you haven't already done so.

Tony

The commands to do this are
# /etc/rc.d/init.d/mysqld stop
# /etc/e-smith/events/actions/conf-mysql-password
# /etc/rc.d/init.d/mysqld start

[wyron]

Thanks for the pointer, AJ.
But no - that isn't it !

[wyron]

Problem solved.
I upgraded to 4.0.18 and remembered to grant privileges this time round!

[gavincowie]

I don't know if this will help mbut try resetting the root password if you haven't already done so.

Thanks ajkeane! This was bending my brain in a nice catch-22 situation. Solved!

G