List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 1 2001 1:44pm
Subject:Re: problem
View as plain text  
Mysql does not own its own files, so it can't open them
chown -R mysql /usr/local/mysql/var
or
chown -R mysql /var/mysql

whichever is correct for your system.


aditya shanker wrote:

> hi 
> i am attaching a log file which was generated by the server in starting up mysql 
> could any please tell me what exactlly the problen is 
> 
> 
> log file 
> =====================================
> 010427 18:25:29  mysqld started
> 010427 18:25:29  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010427 18:25:29  mysqld ended
> 
> 010427 18:26:05  mysqld started
> 010427 18:26:05  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010427 18:26:05  mysqld ended
> 
> 010427 18:34:12  mysqld started
> /usr/local/mysql/bin/mysqld: ready for connections
> 010427 20:23:30  Aborted connection 10 to db: 'unconnected' user: 'root' host:
> `localhost' (Got an error reading communication packets)
> 010427 20:27:15  Aborted connection 17 to db: 'unconnected' user: 'root' host:
> `localhost' (Got an error writing communication packets)
> 010427 20:27:15  /usr/local/mysql/bin/mysqld: Normal shutdown
> 
> 010427 20:27:15  /usr/local/mysql/bin/mysqld: Shutdown Complete
> 
> 010427 20:27:15  mysqld ended
> 
> 010430 12:10:00  mysqld started
> 010430 12:10:01  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010430 12:10:01  mysqld ended
> 
> 010430 15:45:30  mysqld started
> 010430 15:45:30  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010430 15:45:30  mysqld ended
> 
> 010430 15:46:20  mysqld started
> 010430 15:46:20  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010430 15:46:20  mysqld ended
> 
> 010501 10:29:42  mysqld started
> 010501 10:29:42  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 10:29:42  mysqld ended
> 
> 010501 10:30:34  mysqld started
> 010501 10:30:34  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 10:30:34  mysqld ended
> 
> 010501 10:41:05  mysqld started
> 010501 10:41:05  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 10:41:05  mysqld ended
> 
> 010501 11:06:18  mysqld started
> 010501 11:06:18  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 11:06:18  mysqld ended
> 
> 010501 11:42:37  mysqld started
> 010501 11:42:37  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 11:42:37  mysqld ended
> 
> 010501 11:52:29  mysqld started
> 010501 11:52:29  /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
> 010501 11:52:29  mysqld ended
> 
> 010501 12:37:43  mysqld started
> Fatal error: Can't change to run as user 'ser=mysql' ;  Please check that the user
> exists!
> 010501 12:37:43  Aborting
> 
> 010501 12:37:43  mysqld ended
> 
> 010501 12:47:05  mysqld started
> /usr/local/mysql/bin/mysqld: ready for connections


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
problemaditya shanker1 May
  • Re: problemGerald Clark1 May
  • Re: problemThalis A. Kalfigopoulos1 May