Dear Ling,
> Thank you so much. Can I ask why?
you have to keep in mind that the mysqld (that's the MySQL server, or
the daemon) is the only one that must have read/write access to datadir
(the database directories). On your machine, /var/lib/mysql/ is datadir,
and mysqld will run as user "mysql" by default. If mysql is the owner of
the datadir directories and files, mysqld will have read/write access to
your databases and tables, otherwise it has not.
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: "Ling Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 3:51 AM
Subject: Re: Can't start MYSQL on Linux
> Yes, that's it. It worked!!!
> Thank you so much. Can I ask why?
>
> Ling
>
>
> >From: Gerald Clark <[EMAIL PROTECTED]>
> >To: Ling Wang <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: Can't start MYSQL on Linux
> >Date: Tue, 07 Aug 2001 10:29:21 -0500
> >
> >chown -R mysql /var/lib/mysql
> >
> >Ling Wang wrote:
> >
> >>I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36
was
> >>installed together with the Redhat Linux. I can not start the mysql
> >>server by executing /usr/bin/safe_mysqld &. It always ends
immediately.
> >>When I look at the /var/log/mysql.log, the message says:
> >>
> >>mysql started
> >>/usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13)
> >>mysql ended
> >>
> >>
> >>I tried start safe_mysqld from many directories and without any
success.
> >>Can anyone please help me out?
> >>
> >>Thanks.
> >>
> >>Ling Wang
> >>
> >>_________________________________________________________________
> >>Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
> >>
> >>
>
>>---------------------------------------------------------------------
> >>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
> >
> >
> >--
> >Gerald L. Clark
> >[EMAIL PROTECTED]
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> 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
