MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Re: the table is read only          MySQLTalk.org Forum Index -> MySQL General Discussion View previous topic :: View next topic   Author Message James Weisensee Guest Posted: Wed Sep 22, 2004 12:42 am    Post subject: Re: the table is read only 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 --- ÀîÈñ <lrf (AT) bjfu (DOT) edu.cn> wrote: Quote: 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 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡lrf (AT) bjfu (DOT) edu.cn ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2004-09-20 Back to top Eldo Skaria Guest Posted: Wed Sep 22, 2004 4:41 am    Post subject: Re: the table is read only 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, æ�Žé”� <lrf (AT) bjfu (DOT) edu.cn> wrote: Quote: 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]lrf (AT) bjfu (DOT) edu.cn[/email] 2004-09-20 -- Thanks & Regards, Eldo Skaria Back to top Seth Seeger Guest Posted: Fri Oct 01, 2004 1:13 pm    Post subject: Re: the table is read only 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, æ�Žé”� <lrf (AT) bjfu (DOT) edu.cn> wrote: Quote: 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]lrf (AT) bjfu (DOT) edu.cn[/email] 2004-09-20 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL General Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.