thnx Iikka .... pardon my ignorance but i ve no clue as how to give RWXD except through phpmyadmin .... and this is the situation there on the home of phpmyadmin ...
Edit Delete Grants % root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants % sir Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost zaban Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter --------------------------------------------------- some how i ve got 2 roots instead of 1 n both my users ... zaban && sir given me the same accessdenied error ... code 13 .... :s .... i HAVE given them all the rights i possibbly cud ... editting the grants and even revoking them ... but nothing seem to b workin .... n im lost at sea .... :'( .... n no clue vat to do ... i feel like takin the whole thing out n reinstallin it ... :S .... vat else can i do ???? thnx a zillion guyz ... toby ..... >From: Iikka Meriläinen <[EMAIL PROTECTED]> >To: toby - <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: access denied ???? >Date: Wed, 25 Sep 2002 15:08:04 +0300 (EEST) > >On Wed, 25 Sep 2002, toby - wrote: > > > thnx iikkaa .... > > > > im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 > > all workin fine ..... > > > > my mysql4.0.1 alfa is givin me these night-mares .... > > > > cud this be the problem ???? 4.0.1 ALFA ????? it was a win zip file i >guess > > not the source but a binary ..... > > > > plz do lemme know what can i do ???? > > > > n thnx a lot again .... > > > > toby ...... > > > > > >> > > > > >> > > > > >>Error on rename of '.\zabandb\ctnt_inf.MYI' to > > > > >>'.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) > > > > >> > > > > >> > >perror 13 --> Permission denied > >So it's probably due to your NTFS file/directory permission on Windows. >Please >try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights >to >the whole data directory. This has, of course, a major problem with >security >but that way you could check if it's really a permissions problem. Also, a >more secure way to accomplish this is to run the MySQL service as a >ordinary >user (rather than the SYSTEM account) and grant that user full rights to >the >whole data directory structure (make sure the subdirectories and files get >their correct permissions, too). > >Regards, >Iikka > >****************************************** >* Iikka Meriläinen * >* E-mail: [EMAIL PROTECTED] * >* Vaala, Finland * >****************************************** _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php