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