have installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
Hi
I have installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
installed mysql some software on aix5.2 .
the edition is MySQL-3.23.58-2.aix5.1.ppc
but when I used phpmyadmin to manage the mysql
it told me
**
#1036 - Table 'gbook' is read only
On Monday 15 March 2004 01:02, Chuck Gadd wrote:
Smartyone wrote:
The database used to work, but then something must have broke, because
now it is suddenly Read-Only (reports Read Only when I try to add a
record using MySQLCC).
Make sure the owner and group of the database files is set
I've seen this similar issue in other postings, but haven't found a way to
correct it. I haven't found any help in the manuals, either, so please
someone explain what this is about.
MySQL v. 4.0.15
SuSE Linux 9.0
Database is very small: 6 tables, largest table around 5k.
Ownership is
Smartyone wrote:
The database used to work, but then something must have broke, because now it
is suddenly Read-Only (reports Read Only when I try to add a record using
MySQLCC).
Make sure the owner and group of the database files is set
to mysql.
--
MySQL General Mailing List
For list
try
doing INSERT statements on one of the tables that was copied over, I get:
mysql INSERT INTO test VALUES(3);
ERROR 1036: Table 'test' is read only
However, if I create a new table called test2, I can perform INSERT
statements on it with no error:
mysql insert into test2 values(3
:
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1) Table
, they usually work without any flush
priveleges or a restarting of the server. But I always do these two
steps, just to be on the safe side.
You know, I wouldn't like some user be welcomed with an ugly message
that goes Table is read-only. I will be the loser.
But anyways.. as you've got your problem
as expected, and I can perform
SELECT statements on them and get the correct results. But when I try
doing INSERT statements on one of the tables that was copied over, I get:
mysql INSERT INTO test VALUES(3);
ERROR 1036: Table 'test' is read only
However, if I create a new table called test2, I can
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called tracerlock
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a .MYD, .MYI and
.frm file for every table in the database. So after creating a
database called
At 05:54 PM 8/16/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called tracerlock
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a .MYD, .MYI and
.frm file for every table in the
that, and then did flush privileges, then logged out and logged
back in to mysql as bhaselto, but I still got the error table 'test' is
read only when trying to insert rows into it.
Any idea on how to do something differently with GRANT to make it work?
-Bennett
At 04:16 PM 8/16/2003 -0700, Bennett
dear all,
i has a problem to installing phpbb using mysql database. An error has occured
during installation (An error occured trying to update the database
Table 'phpbb_config' is read only).
what is the problem ? please help me
this is a phpbb specific question notice its a custom error message
-Original Message-
From: HA. Mooduto [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 8:13 PM
To: [EMAIL PROTECTED]
Subject: database table is read only
dear all,
i has a problem to installing phpbb using mysql
I'm trying to update a table and I get this error
message.
ERROR 1036: Table 'list' is read only
J.
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing
On Saturday 29 March 2003 10:32, Joseph Bannon wrote:
I'm trying to update a table and I get this error
message.
ERROR 1036: Table 'list' is read only
Is your table compressed with myisampack?
Check also permissions on the table files.
--
For technical support contracts, goto https
434 7582
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Tonu Samuel
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 12:14 AM
Subject: Re: table is read only when DB copied from
Win to UNIX
Thanks for the tip but I have added
yards? Nope! I cannot
insert any values in that database. I get the
following error: Table xxx is read only. I have
checked the OS permission for that directory and I
have given full persmission (write, read and execute).
Also I have checked MySQL permissions, adding full
permission for all users
On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
Fine, I can see the database, show tables works,
selects works. The whole nine yards? Nope! I cannot
insert any values in that database. I get the
following error: Table xxx is read only. I have
checked the OS permission for that directory
yards? Nope! I cannot
insert any values in that database. I get the
following error: Table xxx is read only. I have
checked the OS permission for that directory and I
have given full persmission (write, read and execute).
Also I have checked MySQL permissions, adding full
permission for all users
cannot
insert any values in that database. I get the
following error: Table xxx is read only. I have
checked the OS permission for that directory and I
have given full persmission (write, read and
execute).
Also I have checked MySQL permissions, adding full
permission for all users
[EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 12:14 AM
Subject: Re: table is read only when DB copied from Win to UNIX
Thanks for the tip but I have added to the table db in
mysql database full permission for everybody to that
database. I don't think that is a permission thing
because when
Let me try again. I recently installed mysql. I need to change the root
password. However, whatever method I try mysql tell me that the user table
is read only.
mysqladmin -u root password 'mynewpassword'
mysqladmin: unable to change password; error: 'Table 'user' is read only'
Or
mysql
From: Ari Kahn [EMAIL PROTECTED]
However, whatever method I try mysql tell me that the user table
is read only.
It sounds to me like root doesn't have sufficient permissions granted to write to
that table, but I could be wrong. There's something in the docs about accessing after
you've
Hi.
On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote:
From: Ari Kahn [EMAIL PROTECTED]
However, whatever method I try mysql tell me that the user table
is read only.
It sounds to me like root doesn't have sufficient permissions
granted to write to that table, but I
mysql lock table White write;
ERROR 1036: Table 'White' is read only
How do we make it read-write?
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
James Montebello wrote:
File permissions?
Nope, tried that.
mysql lock table White write;
ERROR 1036: Table 'White' is read only
How do we make it read-write?
--
Steve Rapaport
still at large
-
Before posting
, 2002 4:14 PM
To: James Montebello
Cc: [EMAIL PROTECTED]; MySQL List
Subject: Re: Table is read only
James Montebello wrote:
File permissions?
Nope, tried that.
mysql lock table White write;
ERROR 1036: Table 'White' is read only
How do we make it read-write?
--
Steve Rapaport
still
This works with ONE MORE STEP:
shut down and restart the mysqld server.
Otherwise nothing happens!
Thanks all.
steve
Michael Migal wrote:
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
in my Test and Backup
Environment... but for some reason, my Live environment reports back that
the table is read only.
mysqlUSE mysql;
mysqlINSERT INTO user (Host, User, Password)
-VALUES (localhost, cfuser, PASSWORD());
ERROR 1036: Table
Unfortunately I have tried that. Attempted to GRANT all privelages to the
root user it failed with the same error message stating that the Table
user is read only.
UGH Too frustrating
that the Table
user is read only.
UGH Too frustrating!!
Nessi
: Nessi [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: URGENT MySQL
user table is read only...
06/20/01 01:53 PM
that
the table is read only.
mysqlUSE mysql;
mysqlINSERT INTO user (Host, User, Password)
-VALUES (localhost, cfuser, PASSWORD());
ERROR 1036: Table 'user' is read only
36 matches
Mail list logo