问题:使用mysql -uroot -p连接mysql时报ERROR 1226 (42000): User 'root' has exceeded the 'max_connections_per_hour' resource (current value: 2)错误
分析:root账号设置了max_connections.
解决办法:update mysql.user set max_connections=0 where host='%' and user='root';
问题:使用mysql -uroot -p连接mysql时报ERROR 1226 (42000): User 'root' has exceeded the 'max_connections_per_hour' resource (current value: 2)错误
分析:root账号设置了max_connections.
解决办法:update mysql.user set max_connections=0 where host='%' and user='root';