On MySQL 5.1 for Windows, why can't I assign DBA role to the "root" user?
- by djangofan
On MySQL 5.1 for Windows, why can't I assign DBA role to "root" user? The MySQL Workbench allows me to add all the other roles except for DBA. Also, when I "alter schema" on any table, while logged in as root, I dont see all the tabs that show me all the database properties... I only see the first tab that allows me to change collation only.
What is wrong with this picture? How do i give root all priveleges? I've tried a few variations of GRANT ALL PRIVILEGES etc. from the command line but nothing works.
My root account is unable to alter column names, indexes, or options of any given table that I create. I can create tables and delete them but I can't alter them.