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

eZ debug

Timing:	Jan 18 2025 21:17:41
Script start
Timing:	Jan 18 2025 21:17:41
Module start 'layout'
Timing:	Jan 18 2025 21:17:41
Module start 'content'
Timing:	Jan 18 2025 21:17:42
Module end 'content'
Timing:	Jan 18 2025 21:17:42
Script end

Main resources:

Total runtime	0.9552 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.0313	152.6406
Module start 'layout'	0.0064	0.0034	740.6719	39.4766
Module start 'content'	0.0098	0.9438	780.1484	428.0938
Module end 'content'	0.9536	0.0015	1,208.2422	8.1484
Script end	0.9552		1,216.3906

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.3956	16	0.0002
Check MTime	0.0014	0.1435	16	0.0001
Mysql Total
Database connection	0.0011	0.1168	1	0.0011
Mysqli_queries	0.9040	94.6409	52	0.0174
Looping result	0.0006	0.0661	50	0.0000
Template Total	0.9069	94.9	2	0.4534
Template load	0.0025	0.2643	2	0.0013
Template processing	0.9043	94.6721	2	0.4522
Template load and register function	0.0002	0.0204	1	0.0002
states
state_id_array	0.0025	0.2622	1	0.0025
state_identifier_array	0.0027	0.2811	2	0.0013
Override
Cache load	0.0021	0.2178	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1168	1	0.0011
Fetch class attribute name	0.0024	0.2474	2	0.0012
XML
Image XML parsing	0.0003	0.0307	1	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0011	2	0.0000
General
dbfile	0.0007	0.0752	10	0.0001
String conversion	0.0000	0.0010	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs