You have to set-up the "user" table in "mysql" db to allow connection from
localhost. Example dump:
mysql> select * from user;
++-+--+-+-+-
+-+-+---+-+-
--+
Make sure that the files for that table not only have correct permissions,
but also have correct owner and group. (mysql:mysql)
I had the same write only problem and fixed it by doing it.
mike
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 20
You can lock the table when you insert.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 9:25 AM
To: [EMAIL PROTECTED]
Subject: SV: sequence and nextval
Thanks, but how secure is this. Is it possible for two computers to do
th
Opening and closing connections on any database is very expensive operation
in terms of time. It is better to keep a connection open, if possible,
until you have completed displaying the page.
mike
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November
It depends what you need to do. For unique keys, I usually use
AUTO_INCREMENT feature.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 7:41 AM
To: [EMAIL PROTECTED]
Subject: sequence and nextval
Does the above functions exis
Hi,
I have a little problem, and hope that someone can help me with it.
I am trying to copy MySQL data files for a certain database from one Linux
box to the other. Copying works just fine, but then some of the tables
become unusable. Any suggestions?
mike
---
