Hi Gerald.
Actually, mysql should have access, as it owns the entire directory.
drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4-
i686
and nested inside that is
drwxr-x--- 27 mysql wheel 918 Jul 18 12:53 data
Thanks!
--
Chris Africa
Web Project Manager
Department of Mechanical Engineering
University of Michigan
734-764-8482
Fridays: 734-355-6577
AIM/iChat/Skype ID: baiewola
On Jul 18, 2007, at 1:32 PM, Gerald L. Clark wrote:
Chris Africa wrote:
-------------
070717 22:44:12 mysqld started
070717 22:44:12 [Warning] Setting lower_case_table_names=2
because file system for /usr/local/mysql/data/ is case insensitive
070717 22:44:12 [Warning] No argument was provided to --log-bin,
and --log-bin-index was not used; so replication may break when
this MySQL server acts as a master and has his hostname changed!!
Please use '--log-bin=/usr/local/mysql/data/me-web2-bin' to avoid
this problem.
070717 22:44:12 InnoDB: Started; log sequence number 0 335107
/usr/local/mysql/bin/mysqld: File '/usr/local/mysql-5.0.41-
osx10.4- i686/data/me-web2-bin.000027' not found (Errcode: 13)
070717 22:44:12 [ERROR] Failed to open log (file '/usr/local/
mysql-5.0.41-osx10.4-i686/data/me-web2-bin.000027', errno 13)
070717 22:44:12 [ERROR] Could not open log file
070717 22:44:12 [ERROR] Can't init tc log
070717 22:44:12 [ERROR] Aborting
070717 22:44:12 InnoDB: Starting shutdown...
070717 22:44:14 InnoDB: Shutdown completed; log sequence number
0 335107
070717 22:44:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
070717 22:44:15 mysqld ended
-------------
I'm not using replication, but I am using mirrored drives, and
this is the first time I've ever done that. Still, it didn't seem
to be a problem until I screwed up the passwords.
I'm just setting up a new server, so the tables and data are not
dear to me. Right now, I just want MySQL to work -- with logging!!
--
Chris Africa
Web Project Manager
Department of Mechanical Engineering
University of Michigan
734-764-8482
Fridays: 734-355-6577
AIM/iChat/Skype ID: baiewola
mysql does not have write privilege in /usr/local/mysql-5.0.41-
osx10.4-i686/data.
Is this owned by root too?
--
Gerald L. Clark
Supplier Systems Corporation
!DSPAM:469e4ec246291493215846!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
