List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 6 2001 1:44pm
Subject:Re: MySQL startup problem - Linux 7.1
View as plain text  
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
> guelphdad@stripped
> 
> 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 <mysql-thread84651@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
MySQL startup problem - Linux 7.1Dave Lake5 Sep
  • Re: MySQL startup problem - Linux 7.1Gerald Clark6 Sep