Forums / Install & configuration / Reset rights on mysql tables

Reset rights on mysql tables

Author Message

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 K
DK

Søren Knudsen

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 regards
Søren Knudsen