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.)
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- 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
>
---------------------------------------------------------------------
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
