Hi,
I just encountered a similar problem on one of my production servers
this morning. (I'm still investigating the cause.) After doing a
quick bit of Google-searching, this solved my problem:
mysqladmin -u -p flush-tables
By the way: All directories in /var/lib/mysql should have 700
permiss
Hi,
Giving a permission of '777' to mysql dir is not advisable.
More over that may not be the problem. It should be the privilege the
phpmyadmin user is having on your Db or the specified table.
Reg,
Eldo Skaria
On Wed, 22 Sep 2004 08:36:21 +0800, æé <[EMAIL PROTECTED]> wrote:
> Hi
> I have
What are the MySQL permissions for the phpmyadmin
user?
If you believe that you set the phpmyadmin user up
correctly in MySQL, Did you try a 'flush privileges'
in MySQL?
HTH,
James
--- ÀîÈñ <[EMAIL PROTECTED]> wrote:
> Hi
> I have installed mysql some software on aix5.2 .
> the edition is M
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
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 i
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 archiv
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 mysql:root
ou running?
When I execute grant statements, 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.&quo
Thanks. Actually, my ISP helped me out and got this fixed. Here's what
they wrote in the support log:
>>>
Due to the method that the databases were copied over, I went into mysql
used the grant option on all the databases to allow root access and ability
to alter all the databases. Once this w
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
I searched on Google and I found this post from 2 years ago:
http://www.phpbuilder.com/mail/php-db/2001082/0212.php
suggesting that the way to do it would be to connect to MySQL as root and
run the command:
grant all on tracerlock.test to bhaselto identified by ""
I tried that, and then did "flus
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
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 cal
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 "tracerlock" on the n
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
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...
--
Th
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://o
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 List
CTED]]
> Sent: Thursday, June 13, 2002 9:48 AM
> To: Chris Knipe
> Cc: MySQL
> Subject: Re: table is read only when DB copied from
> Win to UNIX
>
>
> Thanks a lot Chris for the tip, but that precisely
> what I am trying to avoid so my users don't
rporate Networking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Tonu Samuel"
> <[EMAIL PROTECTED]>
> Cc: "MySQL" <[EMAIL P
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 to the table db in
> mysql database full permission for everybody t
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 I add a new table, I can insert data into
that new table. Besides it does not happen when I copy
the database from UNIX to Win
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
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 direct
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
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 s
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 i
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
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
, 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
>>
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
-
Befor
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://
on, my Live environment reports back that
> the table is read only.
>
>
> mysql>USE mysql;
> mysql>INSERT INTO user (Host, User, Password)
> ->VALUES ("localhost",
ED]>,
[EMAIL PROTECTED]
Subject: Re: URGENT MySQL
user table is read only...
> Nessi
>
>
> .de> cc: [EMAIL PROTECTED]
>
>
Subject: Re: URGENT MySQL user table
is read only...
06/20/01
on, my Live environment reports back that
>the table is read only.
>
>
>mysql>USE mysql;
>mysql>INSERT INTO user (Host, User, Password)
>->VALUES ("localh
works find in my Test and Backup
Environment... but for some reason, my Live environment reports back that
the table is read only.
mysql>USE mysql;
mysql>INSERT INTO user (Host, User, Password)
->VALUES ("localhost", "
38 matches
Mail list logo