Learn free mysql tutorials

Fix for ERROR 1006 (HY000) Cant create database (errno: 2123132) in MySQL

February 28, 2022 ·  2 min read

Once MySQL is installed on macOS or Linux machines, You tried to create a database using the below command in the terminal or MySQL client for the first time For example, create a database using the below command. create database employeedb It throws a below error ERROR 1006 (HY000) Can’t create database ‘db_name’ (errno: 2123132) Let’s see the fix and solution for this error. Probable causes for this issue is...

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

February 28, 2022 ·  2 min read

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

Illegal mix of collations error in MySQL query

February 28, 2022 ·  3 min read

This is a short tutorial on 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, the encoding and collation table and columns as UTF8, and data is inserted with greek encoding values. The solution is to maintain the same encoding and collation across the database all tables and all columns in the MySQL system....

Multiple ways to Reset Auto Increment column to 1 in MySQL

February 28, 2022 ·  2 min read

Sometimes, We want to reset the auto-increment column value to 1 for the Mysql table. In this tutorial, We are going to learn multiple ways to MySQL provides AUTO_INCREMENT to the column of the table to primary keys. It increments its value by 1 whenever a row is inserted into the table. Sometimes, We want to reset the auto_increment column value to 1. How to set my auto-increment value to start from 1 in MySQL?...