From: Administrator
Date: March 25 1999 10:29pm
Subject: CANT FIND FILE AND MYSTERY ERROR
List-Archive: http://lists.mysql.com/mysql/979
Message-Id: <01BE76D4.47FF2380@DRONE>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Gents,
I have a small problem that Im sure you have probably seen before....
Could you please help with it or point me in the direction that I need =
to find out what is wrong.
Ive read the FAQ and the web based search tool but it still hasn't fixed =
the problem.
Here is the gist...I am running mysql ver. 3.21.33b
1.	The first issue is that whenever I create a database using mysqladmin =
it gives the database permissions of 700 ie:

drwx------  2 root  wheel    512 Mar 11 06:50 badone  <-- This one
drwxr-xr-x  2 root  wheel    512 Mar 25 10:06 mysql
drwxr-xr-x  2 root  wheel    512 Mar 25 10:13 test

Is this normal?
2.	The second I have created a second database "badone" and want that to =
be accessible to a user called baddude.
Only everytime that I try to connect via DBI call with a perl script =
from the web it gives me the error that the file doesn't exist:
Error:Can't find file: 'email_info.frm' (errno: 2)
bash-2.02$ perror 2
No such file or directory

Running a perror from the command line I found that error meant that the =
file doesn't exist but that's not true at all:
drwxr-xr-x  2 root  wheel   512 Mar 25 10:08 .
drwxr-xr-x  6 root  wheel   512 Mar 25 10:14 ..
* rw-rw----  1 root  wheel     0 Mar 25 10:08 email_info.ISD
* rw-rw----  1 root  wheel  1024 Mar 25 10:08 email_info.ISM
* rw-rw----  1 root  wheel  8692 Mar 25 10:08 email_info.frm

>From the command line I can connect without a problem:

bash-2.02$ mysql -h test.hanzo.net -u baddude  badone
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 3.21.33b-log

Type 'help' for help.
mysql>
Here is a copy of my mysql_install_db:

#=20
# Dumping data for table 'db'
#
INSERT INTO db VALUES ('%','badone','baddude','Y','Y','Y','Y','Y','Y');
INSERT INTO db VALUES ('%','test',",'Y','Y','Y','Y','Y','Y');
INSERT INTO db VALUES ('%','test\_%',",'Y','Y','Y','Y','Y','Y');

#
# Dumping data for table 'host'
#

INSERT INTO host VALUES =