>-Original Message-
>From: Joerg Bruehe [mailto:joerg.bru...@oracle.com]
>Sent: Thursday, January 20, 2011 6:54 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi!
>
>
>Jerry Schwartz wr
Hi!
Jerry Schwartz wrote:
> [[...]]
>
>> [[...]]
>>
> [JS] Sorry, that still doesn't make sense to em. To authenticate the user,
> mysqld needs to read the mysql database. That is also where the databases are
> listed (in `mysql`.`db`). If the daemon can read `mysql`.`user`, why can't it
> re
gt;>> Sent: Wednesday, January 19, 2011 10:43 AM
>>> To: mysql@lists.mysql.com
>>> Cc: Jerry Schwartz
>>> Subject: Re: Can't read dir of '.' (errno: 13)
>>>
>>> Hi!
>>>
>>>
>>> Jerry Schwartz wrote:
>
anuary 19, 2011 2:56 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi !
>
>
>Jerry Schwartz wrote:
>>> -Original Message-
>>> From: Joerg Bruehe [mailto:joerg.bru...@oracle
Hi !
Jerry Schwartz wrote:
>> -Original Message-
>> From: Joerg Bruehe [mailto:joerg.bru...@oracle.com]
>> Sent: Wednesday, January 19, 2011 10:43 AM
>> To: mysql@lists.mysql.com
>> Cc: Jerry Schwartz
>> Subject: Re: Can't read dir of '.&
>-Original Message-
>From: Joerg Bruehe [mailto:joerg.bru...@oracle.com]
>Sent: Wednesday, January 19, 2011 10:43 AM
>To: mysql@lists.mysql.com
>Cc: Jerry Schwartz
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi!
>
>
>Jerry Schwartz
Hi!
Jerry Schwartz wrote:
>> -[[...]]
>>
> [JS] I have a related question: how can MySQL authenticate a user if file
> system permissions won't let it read any databases?
To me, your question sounds like you forgot the difference between
server and client:
- The MySQL server processes always r
>-Original Message-
>From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
>Sent: Wednesday, January 19, 2011 12:45 AM
>To: mysql@lists.mysql.com
>Subject: Can't read dir of '.' (errno: 13)
>
>Dear all,
>
>I am facing the issue mentioned
Check owner of the MySQL data directory.
2011/1/19 Pintér Tibor
> > mysql> show databases ;
> > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> > mysql> show databases;
> > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql> show databases ;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql> show databases;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql>
$ perror 13
OS error code 13: Permission denied
t
;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> show databases ;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql> show databases;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql>
r '\h' for help. Type '\c' to clear the current input
statement.
mysql> show databases ;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql> show databases;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql>
My Mys
Mysql daemon runs as the 'mysql' user
Chown -r mysql:mysql /storage/mysql/data
Regards,
Gavin Towey
-Original Message-
From: Carl [mailto:c...@etrak-plus.com]
Sent: Friday, December 11, 2009 11:55 AM
To: mysql@lists.mysql.com
Subject: errno: 13
Fresh install of 5.1.41 on a
EDERATED' is disabled.
091211 13:19:18 [Warning] /usr/local/mysql/bin/mysqld: ignoring option
'--innodb-use-sys-malloc' due to invalid value 'ON'
^G/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
091211 13:19:18 [ERROR] Can
/usr/sbin/mysqld: Can't find file:
'./siwebes_siweb05/Imagenes_Chunks.frm' (errno: 13) when i select.
Looking into log files i see that this message was already there. Is
there any temporary file where my data could be stored?
Any help or suggestions anyone can offer is greatly appre
Thanks Mike.
Thanks Mike. Don't know why the permissions were read only all of a
sudden but that was the problem.
Haig
Mike Zupan wrote:
[EMAIL PROTECTED] ~]# perror 13
OS error code 13: Permission denied
check permissions that it is read/write for the mysql user
On 9/14/07, Haig Dedeyan
[EMAIL PROTECTED] ~]# perror 13
OS error code 13: Permission denied
check permissions that it is read/write for the mysql user
On 9/14/07, Haig Dedeyan <[EMAIL PROTECTED]> wrote:
>
> Hi everyone,
>
> all of a sudden today, I keep getting the error mentioned in the subject
> when I open the dbas
Hi everyone,
all of a sudden today, I keep getting the error mentioned in the subject
when I open the dbase in phpmyadmin..
I have a dbase with 14 tables. When I open it in phpmyadmin, it will
list all the tables until it reaches the table "orderpc" and then stops
right there.
I went into
HI again,
This multiple mysql proccesses are nothing to worry about - these are the
threads that mysql opens to accept incoming connections. You can configure
the maximum number of connections and the mysql memory usage in the
/etc/my.cnf file.
On Wednesday 01 September 2004 02:14, Yannick Warn
Le mar 31/08/2004 à 16:21, Dobromir Velev a écrit :
> Hi,
> Make sure that the mysql user have permissions to write into the folder
> /var/lib/mysql (or whatever your data folder is) .
Thanks Eric and Dobromir. This was a problem of permissions on
/var/lib/mysql indeed. Although it did not work i
ease with Debian, I feel a little unconfortable and cannot find why I
> get an Error: errno 13 (Permission Denied) when I try to create a new
> database.
>
> Is there some place to look at first? I cannot find any way to do this
> easily. There is no strace installed on the system
d can write to it.
-Eric
On Tue, 31 Aug 2004 16:00:39 +0100, Yannick Warnier
<[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I need to install a database on a RedHat system. Although I'm pretty at
> ease with Debian, I feel a little unconfortable and cannot find why I
> get an Err
Hi there,
I need to install a database on a RedHat system. Although I'm pretty at
ease with Debian, I feel a little unconfortable and cannot find why I
get an Error: errno 13 (Permission Denied) when I try to create a new
database.
Is there some place to look at first? I cannot find any w
quot;data".
all files and
directories of var in this new directory -data-. I
changed with mysql
mysql all this file and directories (group and owner).
And I made :
create database X;
ERROR 1006: Can't create database 'X'. (errno: 13)
I hope what I explain is clear!
What did I forget
reate database 'X'. (errno: 13)
I hope what I explain is clear!
What did I forget ?
Do I have to put also var in this new other directory?
Do I have to reinstall completly MySQL because I
corrupted to much
this application?
I am lost.
Could anyone help me?
Thanks
l
-->Subject: Cannot start MySQL (errno 13)
-->
-->Hi all,
-->
-->I have been working on getting MySQL going all day.
-->Initially I had it working but had problems with
-->mysqladmin. Figured that one out shutdown the server
-->and tried to restart but I now have an error. This i
own...
031010 15:38:49 InnoDB: Shutdown completed
031010 15:38:49 /usr/sbin/mysqld: Shutdown Complete
031010 15:38:49 mysqld ended
031010 15:40:36 mysqld started
031010 15:40:36 InnoDB: Started
031010 15:40:36 Fatal error: Can't open privilege
tables: Can't find file: '
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote:
>
> I am installing MySQL on my Mac OS Jaguar system. I was having some
> trouble with the starting up my MySQL Server. I kpt getting "mysqld
> ended" error and my logs showed that file "user.MYI" was corrupted. So
> I decided to uninstall
Can't find file:
> './mysql/host.frm' (errno: 13)
run "perror 13"
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list arc
rted
030623 15:59:05 Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno: 13)
030623 15:59:05 Aborting
030623 15:59:05 InnoDB: Starting shutdown...
030623 15:59:07 InnoDB: Shutdown completed
030623 15:59:07 /usr/l
via the
network and I am getting the following message:
DBD::mysql::st execure failed: Can't lock file (errno: 13) at (gives the
location in the script where error is happening.
Not sure how to trace this down. Any and all help apprec
> chown -R mysql /var/lib/mysql
>
> eh wrote:
>
> >Errno 13 on starting mysqld
> >
> >I am using SUSE 8.0
> >on a 586 computer
> >I installed MYSQL 3.23.48 from the Suse-CD (By the while four times)
> >
> >At first I was running (as described
MySQL doesn't own the files.
chown -R mysql /var/lib/mysql
eh wrote:
>Errno 13 on starting mysqld
>
>I am using SUSE 8.0
>on a 586 computer
>I installed MYSQL 3.23.48 from the Suse-CD (By the while four times)
>
>At first I was running (as described in
>
Errno 13 on starting mysqld
I am using SUSE 8.0
on a 586 computer
I installed MYSQL 3.23.48 from the Suse-CD (By the while four times)
At first I was running (as described in
/usr/share/doc/packages/mysql/README.Suse )
"rcmysql start" as root from /var/lib/mysql/ (and later fro
as reported in
mll> the log file (/proj/webamt/rel/mysqldb/amthq2.err):
mll> 020415 11:33:39 mysqld started
mll> 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find
file: './mysql/host.frm' (errno: 13)
mll> 020415 11:33:39 mysqld
15 11:33:39 mysqld started
020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020415 11:33:39 mysqld ended
>How-To-Repeat:
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Magnus Larsson
&g
Gwen,
Wednesday, January 30, 2002, 7:57:55 AM, you wrote:
GT> Hi All,
GT> Forgive me if this question has been asked before. I'm new to the list
GT> and MySQL!
GT> I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13)
GT> when signe
Hi All,
Forgive me if this question has been asked before. I'm new to the list
and MySQL!
I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13)
when signed on as root and as user.
I've also tried this command but my terminal had no
Hi All,
Forgive me if this question has been asked before. I'm new to the list
and MySQL!
I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13)
when signed on as root and as user.
I've also tried this command but my terminal had no
36
>
> Type 'help;' or '\h' for help. Type '\c' to clear the
> buffer
>
> mysql> use sadms
> Database changed
> mysql>
> mysql>
> mysql> select * from ecg_datafile;
> ERROR 1017: Can't find file:
> './sadms/e
esday, November 28, 2001 4:10 PM
Subject: What is errno: 13
> Hello All:
> I am working on a particular database, which I created
> some days ago in mysql ver. 3.23.36. I am quite sure
> that I have not made any changes to the system (Dell
> WS with
; 3.23.36
>
> Type 'help;' or '\h' for help. Type '\c' to clear the
> buffer
>
> mysql> use sadms
> Database changed
> mysql>
> mysql>
> mysql> select * from ecg_datafile;
> ERROR 1017: Can't find file:
> './sadms/ecg
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 7 to server version:
3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer
mysql> use sadms
Database changed
mysql>
mysql
ED]
> Asunto: Re: ERROR :Can't find file: './mysql/host.frm' (errno: 13)
>
> No, that is permission denied.
>
> chown -R mysql /var/mysql ( or whatever data path is )
>
> Werner Stuerenburg wrote:
>
> > The error indicated means that the table ho
No, that is permission denied.
chown -R mysql /var/mysql ( or whatever data path is )
Werner Stuerenburg wrote:
> The error indicated means that the table host is missing.
>
> I would reinstall the package. If it doesn't work, I would
> download the latest package from mysql.com and install t
The error indicated means that the table host is missing.
I would reinstall the package. If it doesn't work, I would
download the latest package from mysql.com and install that
(it is the recommended path, anyway) - it works fine.
--
Herzlich
Werner Stuerenburg
___
I have installed mysql with rpm method (from cd ditribuition).
But when i start the demon with the 'safe_mysql &' command,
the demon stop immediatelly and i found the message in
Subject in the /var/log/mysql.log file.
The demon starts normally with the command
ld ended
root@qsv-cmxdb1:...pkg/mysql> tail var/qsv-cmxdb1.err
010604 08:44:28 mysqld started
010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown
010604 08:44:28
Mike Broxterman wrote:
>
> Neglected to mention the host.frm file _does_ exist.
>
> @> ls -al /usr/local/pkg/mysql/var/mysql/
> total 134
> drwx-- 2 root other512 Jun 1 07:53 .
> drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 ..
> -rw-rw 1 root other
qsv-cmxdb1:...pkg/mysql> tail var/qsv-cmxdb1.err
> 010604 08:44:28 mysqld started
> 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Can't find file:
>'./mysql/host.frm' (errno: 13)
> 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown
> 0106
50 matches
Mail list logo