johnska7 Posted July 17, 2007 Share Posted July 17, 2007 This is going to drive me nuts. I'm trying to set up a dev environment in which the root user will be able to access every table in every database I have. Currently, I can edit the mysql and information_scheme tables, and any tables that I have restored from a backup. But every time I add a new table to any database, I can't edit any of the rows. I'm currently using the MySQL Query Browser on OS X and the "edit" button stays grayed out on any of these new tables that are created. Can anyone help me walk though some troubleshooting steps so I can move forward on this? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/60374-mysql-permission-can-create-tables-but-not-edit-rows/ Share on other sites More sharing options...
Wildbug Posted July 17, 2007 Share Posted July 17, 2007 Are you clicking on the table or on a column under the table where "edit" is grayed out? If you want to edit the column, I think you have to do that through the table-edit. Otherwise, you might try entering the ALTER TABLE command manually. Quote Link to comment https://forums.phpfreaks.com/topic/60374-mysql-permission-can-create-tables-but-not-edit-rows/#findComment-300371 Share on other sites More sharing options...
johnska7 Posted July 17, 2007 Author Share Posted July 17, 2007 I'm clicking on the cell below the column header, where I should be able to enter a value. I should probably also say that I have a working setup on a Mac server at work, so I'm not really sure why I can't get this to work. It's MySQL 5.0 on an Ubuntu box. Quote Link to comment https://forums.phpfreaks.com/topic/60374-mysql-permission-can-create-tables-but-not-edit-rows/#findComment-300387 Share on other sites More sharing options...
johnska7 Posted July 17, 2007 Author Share Posted July 17, 2007 Just to make sure, I also just created a new user and did "GRANT ALL on database_name.* TO user_name". Same error happens. I can create tables, but I can't enter data into the rows once they're created. Quote Link to comment https://forums.phpfreaks.com/topic/60374-mysql-permission-can-create-tables-but-not-edit-rows/#findComment-300454 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.