RE: Problem with access settings on one database on mySQL

2002-01-17 Thread Keiran Wynyard
in to 700. Thanks again Keiran -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 15:30 To: Keiran Wynyard Cc: [EMAIL PROTECTED] Subject: Re: Problem with access settings on one database on mySQL The user under which mysql is running ( 'mysql&

Re: Problem with access settings on one database on mySQL

2002-01-17 Thread Gerald Clark
The user under which mysql is running ( 'mysql' ? Better check. ) does not have read permissions on the .frm files OR does not have execute (x) permissions on their parent ( or any ancestor ) directory. chown -R mysql:mysql /var/lib/mysql should do the trick. Replace /var/lib/mysql with the ac