That didn't work but it led to something that did. It turned out that
the owning group didn't have full authorization in the data folder. So,
I did a brute force approach. I made mysql the owner of everything,
instead of root, made mysql the group of everything (which it already
was), then made
At 8:29 -0600 4/8/04, Kevin Jaques wrote:
Thanks for the reply. I feel it is getting me somewhere, but I'm not
there yet.
The log said, regarding the most recent attempt:
040407 09:55:24 mysqld started
040407 9:55:25 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See h
I think the biggest issue I see come up here is that somewhere people get
the idea to add a mysql user to OS X, this causes a lot of trouble for
everyone, as there already is such a user, and you don't need to do anything
in regards to that. On OS X 10.3, simply run the installer, set the root
pas
If apple continues to bundle MySQL with panther and does not give any
kind of support for it's users, they should at least donate a few
machines to us, so we can play with it and give some kind of
support! YEAP I'll keep dreaming! =) jeje
--
|..
I'm not sure if this is part of your problem or not Kevin,
seems you have a few issues, so I'll cover them one at at time...
getting the permissions and ownership correct, this is cut/paste from the
INSTALL docs, pretty much cut/pasteable to your sytem (errr):
groupadd mysql
useradd -g mysql mysq
Many thanks Alec. I need to wait a couple of hours before I can block access
to the DB by messing with the indexes, but I will try out what you suggest.
What you say makes sense as probably over 99% of the values in that first
col will be 'y'. I will post my progress. I am also looking into recodin
"Jim Page - EMF Systems Ltd" <[EMAIL PROTECTED]> wrote on 07/04/2004
17:14:57:
> PS I am answering loads of questions in the hope that the power of my
Karma
> will force someone to answer mine ... (join problem:indexed columns being
> ignored)
My first reaction would be to turn your index
At 9:58 -0600 4/7/04, Kevin Jaques wrote:
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for the
root user, it broke.
Since then, I discovered that Mac OS X refuses to let me create a
user account called 'mysql'.
I know nothing about Macs specifically. However under linux ...
My first question would be 'what's in the error log'? Often in
/var/lib/mysql/.err
Next, have you run the mysql_install_db script to create default databases
and permissions?
Next, have you checked that use mysql has permission to acce
i wouldn't say there is no pity, but there is probably a very low
concentration of mysql people running on macos.
Just my two cents...
dan
Kevin Jaques wrote:
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for t
Are you using InnoDB type tables? The default table type is MyIsam which
does not support foreign keys.
Regards,
Bhavin.
- Original Message -
From: "muad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 03, 2002 5:52 AM
Subject: hey
> hope its okey for me too ask you
On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote:
> I'm a newbie in DB administration. Could somebody tell me what do I need to
> start a web-based project for book listing, mail lists etc, all retrieved
> from a database updated by LAN users and listed on a web page?
Go for www.freshmeat
> -Original Message-
> From: Viorel C [mailto:[EMAIL PROTECTED]]
> Sent: 07 January 2002 23:52
> To: [EMAIL PROTECTED]
> Subject: hey folks!
>
>
> I'm a newbie in DB administration. Could somebody tell me what do I need
> to start a web-based project for book listing, mail lists etc, all
Me...
I would use MySQL (as it if very fast, and never brakes)
I also like PHP as it just fits in with MySQL so well!
Simon
-Original Message-
From: Viorel C [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 23:52
To: [EMAIL PROTECTED]
Subject: hey folks!
I'm a newbie in DB administrati
14 matches
Mail list logo
