No. Not in MySQL or phpMyAdmin but on the operating system / file system level instead. Open up the data directory in "My Computer" on your server, then right-click that directory, select "Security" tab, there add Everyone or the use that MySQL service runs as to the list and select "Full Access". Then click "Advanced permissions" or something like that below the permissions list (I'm not sure, running Finnish Windows 2000 right now). However, check the lower checkbox on the Permissions tab in order to enable permissions inheritance from a upper level to a lower one.
You might have to shut down MySQL during the permissions change. Regards, Iikka On Wed, 25 Sep 2002, toby - wrote: > 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 > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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
