That sounds more accurate to me, but I still seem to be getting table is
read only error messages when trying to do updates/grants (haven't tried
inserts). I'm lost as to why it's in read only mode.
> -----Original Message-----
> From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 2:23 AM
> To: Adam Douglas; 'Gerald Clark'; [EMAIL PROTECTED]
> Subject: Re: Upgrading to 3.23.37 from 3.22.32
>
>
> Dear Gerald,
>
> does mysqld run as user "mysql"? And does user mysql have the correct
> rights for datadir (e. g. /var/lib/mysql/) and all subdirectories?
>
> (The MySQL Daemon is supposed to be the only one who has rights for
> datadir. So, this could be 700 with user mysql as owner. No one else
> needs rights to this directory, as no one else will access the
> directories and files in datadir directly, only the daemon /
> server has
> to.)
> ----- Original Message -----
> From: "Adam Douglas" <[EMAIL PROTECTED]>
> To: "'Gerald Clark'" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Tuesday, August 07, 2001 11:02 PM
> Subject: RE: Upgrading to 3.23.37 from 3.22.32
>
>
> > MySQL reports read only table. As for file permissions,
> everything is
> fine.
> > Everyone has read and execute privileges.
> >
> > >
> > > They are probably not owned by mysql anymore.
> > >
> > > Adam Douglas wrote:
> > >
> > > > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37.
> All I did was
> > > > pkg_delete the old MySQL and install the new one. Before I
> > > delete the old
> > > > MySQL I copied all the database files to a temporary
> > > location. Once the new
> > > > installation was successful I copied over all the database
> > > files into the
> > > > proper location.
> > > >
> > > > My problem is I seem to have 3 extra tables now, A-1, A-9
> > > and A-ce. The
> > > > funny thing is they all seem to be linked to my tables.
> > > These tables to my
> > > > knowledge were not present in the MySQL 3.22.32. Also I
> > > can't seem to remove
> > > > the test user from mysql->db, MySQL says it's read only. I
> > > never made the
> > > > table read only and doesn't seem to be.
> > > >
> > > > Anyone have any ideas of what is going on? I feel kind of
> > > lost now, any help
> > > > would be greatly appreciated.
---------------------------------------------------------------------
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
