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
[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
