List:General Discussion« Previous MessageNext Message »
From:Administrator Date:March 25 1999 10:29pm
Subject:CANT FIND FILE AND MYSTERY ERROR
View as plain text  
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:

# 
# 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 
Thread
CANT FIND FILE AND MYSTERY ERRORAdministrator26 Mar
  • Re: CANT FIND FILE AND MYSTERY ERRORThimble Smith26 Mar
RE: CANT FIND FILE AND MYSTERY ERRORAdministrator26 Mar
  • Re: CANT FIND FILE AND MYSTERY ERRORThimble Smith26 Mar