[ERROR] /usr/sbin/mysqld: Can"t find file: "./mysql/user.frm"

[ERROR] /usr/sbin/mysqld: Can"t find file: "./mysql/user.frm"

am 14.03.2011 06:32:52 von Adarsh Sharma

--------------080504090702060201070907
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear all,

I am facing the below problem while installing mysql in a debian based
system from the last 2 days.

I tried the command apt-get install mysql-server but the server doesn't
start properly due to below exception in /var/log/syslog

41 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
Mar 14 10:36:41 sun-cloud mysqld[3500]: ERROR: 1017 Can't find file:
'./mysql/user.frm' (errno: 13)
Mar 14 10:36:41 sun-cloud mysqld[3500]: 110314 10:36:41 [ERROR] Aborting
Mar 14 10:36:41 sun-cloud mysqld[3500]:

Don't know what is the reason behind this. I attached my debian.cnf file
also.

Please guide me how to resolve this permanently and also I need to
access the mysql server from many client servers.

My /var/lib/mysql permissions are :
root@sun-cloud:/var/lib# ls -ls | grep mysql
4 drwx------ 3 mysql mysql 4096 2011-03-14 10:36 mysql



Thanks & best Regards,

Adarsh Sharma

--------------080504090702060201070907
Content-Type: text/plain;
name="debian.cnf"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="debian.cnf"

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = l7MZwYyF45QH8wrY
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = l7MZwYyF45QH8wrY
socket = /var/run/mysqld/mysqld.sock
basedir = /usr


--------------080504090702060201070907
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--------------080504090702060201070907--

Re: [ERROR] /usr/sbin/mysqld: Can"t find file: "./mysql/user.frm"

am 14.03.2011 06:50:41 von Nilnandan Joshi

--90e6ba6148a68251cf049e6ae5b5
Content-Type: text/plain; charset=ISO-8859-1

errono:13 is "Permission Denied". Check permissions for mysql data dir.

On Mon, Mar 14, 2011 at 11:02 AM, Adarsh Sharma wrote:

> Dear all,
>
> I am facing the below problem while installing mysql in a debian based
> system from the last 2 days.
>
> I tried the command apt-get install mysql-server but the server doesn't
> start properly due to below exception in /var/log/syslog
>
> 41 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno:
> 13)
> Mar 14 10:36:41 sun-cloud mysqld[3500]: ERROR: 1017 Can't find file:
> './mysql/user.frm' (errno: 13)
> Mar 14 10:36:41 sun-cloud mysqld[3500]: 110314 10:36:41 [ERROR] Aborting
> Mar 14 10:36:41 sun-cloud mysqld[3500]:
>
> Don't know what is the reason behind this. I attached my debian.cnf file
> also.
>
> Please guide me how to resolve this permanently and also I need to access
> the mysql server from many client servers.
>
> My /var/lib/mysql permissions are :
> root@sun-cloud:/var/lib# ls -ls | grep mysql
> 4 drwx------ 3 mysql mysql 4096 2011-03-14 10:36 mysql
>
>
>
> Thanks & best Regards,
>
> Adarsh Sharma
>
> # Automatically generated for Debian scripts. DO NOT TOUCH!
> [client]
> host = localhost
> user = debian-sys-maint
> password = l7MZwYyF45QH8wrY
> socket = /var/run/mysqld/mysqld.sock
> [mysql_upgrade]
> host = localhost
> user = debian-sys-maint
> password = l7MZwYyF45QH8wrY
> socket = /var/run/mysqld/mysqld.sock
> basedir = /usr
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=nilnandan@gmail.com
>

--90e6ba6148a68251cf049e6ae5b5--