Learn free mysql tutorials


Fix for User already has more than max_user_connections active connections in mysql database

May 20, 2021 ·  2 min read

This is an short tutorial how to fix (42000/1203): User already has more than ‘max_user_connections’ active connections in mysql database server. You will see an error failed to connect to database. This errors thrown from client machine connecting to database server. In MySQL, There is a limit on the maximum number of simultaneous connections to database server. If maximum connecttions from the same user to database is more than defined database max_user_connections....


Illegal mix of collations error in mysql query

May 20, 2021 ·  2 min read

This is an short tutorial an how to fix an error Illegal mix of collations in mysql This error is thrown when you are using select,insert,update and store procedure queries with encoding and collation defined for database/table/columns and data sent with different encoding/collation. For example, encoding and collation table and columns as UTF8 and data inserted with greek encoding values. The solution is to maintain same encoding and collation across database all tables and all columns in mysql system....


Subscribe
You'll get a notification every time a post gets published here.