Mysql driver is incompatible with DigitalOcean managed database

[kenarsuleyman]

Laravel Version

11

PHP Version

8.3

Database Driver & Version

MySql 8

Description

Hello,
According to DigitalOcean docs here

Users on DigitalOcean Managed MySQL Databases cannot insert, edit, or select from the information_schema database.

Internal usage of information_scheme makes projects incompatible with DigitalOcean Managed MySql databases. I'm not sure on which end this should be resolved, either by you or DigitalOcean, to me this should be resolved on DO end but if you can reach as a company rather than us as individual users things might be faster.

framework/src/Illuminate/Database/Schema/Grammars/MySqlGrammar.php

Line 87 in 53091c2

public function compileTableExists($database, $table)

Steps To Reproduce

No steps needed

[Charlesnorris509]

Hey @kenarsuleyman. Im not too familiar with Laravel in general however I have managed a similar issue in the past. The error is occuring because Laravel's database schema management, particularly in the MySqlGrammar class, relies on querying the information_schema to perform certain operations. I personally decided to migrate to another database supported by the MySqlGrammar class include AWS RDS, PostgreSQL , MariaDB and Google Cloud SQL. other possible solution comprise customizing the configuration file at config/database.php, requesting Feature changes to digitalOcean. Another possibility is that there are some syntatic issues with the Database connection so I will urge you to review these files as well.
I hope this reply has been useful to debugging this issue

[kenarsuleyman]

Hey! Thanks. I was thinking that if somehow I can manage to replace MysqlConnection class that laravel uses when driver is selected as "mysql" to my custom class that extends the original class I can replace problemmatic methods with my own ones. Catch is Laravel 11 changed things a lot and I couldn't figure out how can i do that.

[Charlesnorris509]

@kenarsuleyman its always a pleasure to be helpful to the community. Could please mark this issue as answered im trying to get the galaxy brain badge.
Thanks