Forums / Install & configuration / Reset rights on mysql tables
Søren Knudsen
Tuesday 09 January 2007 2:22:40 pm
Hi there,
I have reached a pretty bad situation during a hard drive crash. I can basically see the tables fine, but it seems that the user rights to the database are gone.
I am running:
--- Server version: Apache/2.0.58 Server built: Jan 8 2007 22:39:26 --- PHP 4.4.4-pl6-gentoo---
mysql Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.1---
The system is Gentoo, compiled from 2006.1, stage3
Does anyone have a suggestion for what to try out?
Best regards, Søren KDK
Thursday 11 January 2007 2:59:10 am
Nevermind. I had this stupid fault of not setting write permissions on subdirs and the files therein in /var/lib/mysql/. This did the trick:
chown -R mysql:mysql /var/lib/mysql/
I wasnt aware of all the subdirs and only by pure luck did I notice when I for the third time did an ls -l on the /var/lib/mysql/ dir did i notice it.
Thanks for the very nice product btw. I have been using EZ Publish for over a year now, and are liking it more and more for each day:)
Best regardsSøren Knudsen