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! 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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.