Of course, is no complete and any suggestions are vary welcome.
Server - Privileges: Solution is the same as it is written in points for Server - DB – Privilges. But I add icon to delete user to place where is “Check All/Uncheck All”. Nearby this icon, will be hidden option to delete database ,with same name who has user.
Server - Synchronize: There needs only hide the “Port” and “Socket”, because they are seldom used.
Server - DB - Structure: This phpMyAdmin tool is for common user a little bit complicated. Probably the best would be to hide “Structure”, “Search” and “Insert”. Moreover, as “Browse”, “Empty” and “Drop” will remain. If the user wants other functions, he only clicks to icon. Other stuff like “Rows”, “Type”, “Collation”, “Size”, ”Overhead” will remain too.
Server - DB - Search: The main goal of this selection is to simplify searching. There will be one search window like in google. It will be searching with LIKE %value% command in all tables with columns. If the user wants to set up search criteria, he only clicks to custom search.
Server - DB - Operations - Copy database to: Display just only simple window where user can write database name. Other options will by hidden.
Server - DB - Privileges - Edit Privileges: Make only simple list of privileges tools.
Server - DB - Privileges - Edit Privileges - Global Privileges: In this section is also best to do list of options too. User chooses only this options what he needs to change. Items of the list will be: “Data”, “Structure”, “Administration”, “Resource Limits”.
Server - DB - Privileges - Edit Privileges - Change Password: There needs only hide the “Password hashing” and “Generate password”, because common user doesn`t need it. Other options are OK.
Server - DB - Privileges - Edit Privileges - Change Login informations: Make list with “Login informations”, “Create a new user with...”. The user opens only this, what he really needs to edit.
Server - DB - Table - Browse: In this section is quite a lot of work.
At first would by to simplify “Show” options. There is so many useless functions, which looks disorganized and common user doesn`t need to set it up. Other stuff like “query range”, “horizontal or vertical mod”, “repeating headers”, “sorting” will be hidden. Only “page arrows” and “page list” will be shown.
I`d like to hide “Edit” and “Copy” in query displaying, because is not used commonly by user.
Server - DB - Table - Structure: Table structure GUI is pretty good. I would hide only “Add column to table”. Then make “Print view” and “Propose table structure” more visible.
Server - DB - Table - Insert: I would hide “Ignore” part, because there is not needed for common user. And I want to make more simpler part Insert as new row.
Server - DB - Table - Operations: The best way is to create a list of options provided and user chooses what he really wants.