I get 'User xxx already has more than max user connections' message

Modified on:
max_user_connections max connections connections database connections user already has more active connections

If you get 'User XXX already has more than max_user_connections active connections' or similar error message, it means your script is not optimized and makes too many connections to the database (or your website is very active, has many users online at the same time).

You may want to run mysql_reconnect command before each query in this case. Also, you can try adding command mysql_close() at the end of your script to close all open connections.

Put a smile on someone's face today!