Reset rights on mysql tables

Next topic

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

Author

Message

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