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 <username> -p flush-tables By the way: All directories in /var/lib/mysql should have 700 permissions (owned my the mysql user) and everything within those directories should be 660 (owned by the mysql user and mysql group). (This was on a FreeBSD 4.8 server running MySQL Server 3.23.58) Hope this helps, Seth On Wed, 22 Sep 2004 08:36:21 +0800, æé <[EMAIL PROTECTED]> wrote: > 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 > > *************************************************************************************** > while I have granted the data dir(/var/lib/mysql) 777 permission > how to resolve it ? > > help me please ,how to resolve > > thanks a lot > Yours > LiRui > [EMAIL PROTECTED] > 2004-09-20 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]