MOTOSHARE 🚗🏍️
Turning Idle Vehicles into Shared Rides & Earnings

From Idle to Income. From Parked to Purpose.
Earn by Sharing, Ride by Renting.
Where Owners Earn, Riders Move.
Owners Earn. Riders Move. Motoshare Connects.

With Motoshare, every parked vehicle finds a purpose. Owners earn. Renters ride.
🚀 Everyone wins.

Start Your Journey with Motoshare

Fixing Laravel Migration Error: “Unknown Collation: utf8mb4_0900_ai_ci”

While working with Laravel and MySQL, you might run into an error during migrations like this one:

Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_0900_ai_ci'

Why This Happens

The collation utf8mb4_0900_ai_ci is introduced in MySQL 8.0. If you’re using an older version of MySQL (like 5.7 or earlier), it doesn’t recognize this collation, and Laravel throws this error during migrations or queries.

Laravel 10+ and Laravel 11 use this collation by default in their database config, assuming the database supports it.


How to Fix It

There are two common ways to fix this issue:

🛠 Option 1: Downgrade the Collation in config/database.php

Open the config/database.php file in your Laravel project.

Locate the mysql connection settings and change the collation and charset like this:

'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'your_db_name'),
    'username' => env('DB_USERNAME', 'root'),
    'password' => env('DB_PASSWORD', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci', // Change this line
    ...
],

Then, clear the config cache:

php artisan config:clear

Now try running the migration again:

php artisan migrate

Option 2: Upgrade Your MySQL Server

If possible, upgrade your MySQL server to version 8.0 or higher, which fully supports utf8mb4_0900_ai_ci.

This is ideal for production servers or when you need access to newer MySQL features.

This is a common issue when developing Laravel apps locally on XAMPP, WAMP, or older MySQL versions. Fortunately, a simple config change is usually all you need to get back on track.

Pro Tip: Always make sure your development and production environments use compatible database versions and configurations to avoid such surprises.

Related Posts

Engineering Operations Assessment: Identifying Gaps and Building a Roadmap for Improvement

Consider a mid-sized software company that has invested heavily in its technical stack. Its applications run on managed Kubernetes clusters, infrastructure is defined in Terraform, pipelines deploy…

Read More

GitLab CI/CD Getting Started Guide: Build Your First Automated Pipeline

1. Introduction: Your First Step Into GitLab CI/CD Software development becomes significantly slower and more error-prone when teams rely on manual steps to build, test, and release…

Read More

How NoOps Is Changing the Way Modern IT Teams Manage Infrastructure

Modern information technology moves at a pace that often leaves traditional operational structures struggling to keep up. For a growing technology company, success brings rapid user adoption,…

Read More

How to Use GitHub Actions for DevOps Automation & Pipelines

In modern software engineering, moving code from a local branch to production traditionally requires a series of manual builds, tests, security checks, and deployments that slow delivery…

Read More

How to Use Jenkins for CI/CD: A Step-by-Step Guide

In modern software development, writing code is only half the journey. Getting that code safely, quickly, and reliably into the hands of users is where the real…

Read More

Navigating the Pulse: A Comprehensive Guide to Mumbai Local Train Commuting and Urban Transit

Few urban experiences match the sheer momentum of Mumbai during peak hours. The city moves to a relentless, rhythmic heartbeat dictated by its suburban railway network, a…

Read More
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x