We have a MySQL installation that has mysql.user table a VIEW. So, MySQL is not starting properly.
We are now running it with skip grant tables. Is there any option to convert the view to BASE TABLE or create user table with the data?
All other tables are showing type BASE TABLE
SHOW FULL TABLES IN mysql WHERE TABLE_TYPE LIKE ‘VIEW’;
| Tables_in_mysql | Table_type |
| user | VIEW |
1 row in set (0.001 sec)
Not sure how this happened. Any help would be appreciated.