Mysql does not own its files.
chown -R mysql /var/lib/mysql
Dave Lake wrote:
> Hi folks, just signed up to the list so I hope this is the correct place
> to send such a question:
>
> I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x
> I had successfully run MySQL under that distribution but am having
> problems with it under Red Hat 7.1
>
> I have installed mysql-3.23.36 from the RPM file.
>
> When I attempt to run mysql from teh command line I get the following
> message:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
>
> When I check my log file at /var/log/mysqld.log
>
> I get a message as follows:
> 010905 16:10:14 mysqld started
> 010905 16:10:14 /usr/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 010905 16:10:14 mysqld ended
>
> I have checked /var/lib/mysql directory and have the following items:
>
> mysql mysql.sock test
>
> I am assuming the test directory is the test database though it doesn't
> contain anything.
>
> Inside the mysql directory (so inside /var/lib/mysql/mysql) I can see
> the following items:
>
> columns_priv.frm db.frm func.frm host.frm tables_priv.frm user.frm
> columns_priv.MYD db.MYD func.MYD host.MYD tables_priv.MYD user.MYD
> columns_priv.MYI db.MYI func.MYI host.MYI tables_priv.MYI user.MYI
>
> -----
> I am not sure if I have included too little or too much information.
> above.
>
> I have attempted to figure out what I have done incorrectly by reading
> the installed mysql docs but can't figure out where I have gone wrong.
>
> Once I get MySQL running I more or less know what I am doing but to
> start it I am stumped.
>
> Any help would be appreciated.
> Dave Lake
> [EMAIL PROTECTED]
>
> p.s. Is it my imagination or did MySQL run when set up under Red Hat 6.x
> whereas there is more tweaking to do under Red Hat 7.1
>
> _________________________________________________________________
> 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]
---------------------------------------------------------------------
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