Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: wyron on April 14, 2004, 11:39:44 AM
-
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 ???
-
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
-
Thanks for the pointer, AJ.
But no - that isn't it !
-
Problem solved.
I upgraded to 4.0.18 and remembered to grant privileges this time round!
-
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