Every time I try and add a permission I get the following error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
This happens using mysql
in the terminal and through PhpMyAdmin
The user doing the change is root with all permissions and GRANT option. Does not matter what I set the permissions to either, all, with grant, without grant, just select. they all just have this error.
Any ideas why?
Extra info:
recently upgraded from 5.0.1 -> 5.6
I have restarted mysql
I have tried flushing privileges
# mysql --version
mysql Ver 14.14 Distrib 5.6.19, for Linux (x86_64) using EditLine wrapper
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
+---------------------------+------------------+-------------------------------------------+------------+------------+
| host | user | password | Grant_priv | Super_priv |
+---------------------------+------------------+-------------------------------------------+------------+------------+
| localhost | root | *hash | Y | Y |
| localhost | debian-sys-maint | *hash | Y | Y |
...trim...
+---------------------------+------------------+-------------------------------------------+------------+------------+
15 rows in set (0.00 sec)