Fix oracle mysql support #164

New Issue

oysteikt · 2025-12-13T16:35:22+01:00

oysteikt commented

2025-12-13 16:35:22 +01:00

So far, we've only tested against mariadb. Use with oracle mysql is broken

$ muscl show-user
Error: Failed to list all users

Caused by:
    MySQL error: error returned from database: 1146 (42S02): Table 'mysql.global_priv' doesn't exist

note that tab autocompletion is also broken, there might be more as well

So far, we've only tested against mariadb. Use with oracle mysql is broken ``` $ muscl show-user Error: Failed to list all users Caused by: MySQL error: error returned from database: 1146 (42S02): Table 'mysql.global_priv' doesn't exist ``` note that tab autocompletion is also broken, there might be more as well

oysteikt added this to the Initial release milestone 2025-12-13 16:35:22 +01:00

oysteikt added the bug label 2025-12-13 16:35:22 +01:00

oysteikt commented

2025-12-13 19:32:07 +01:00

fixed lock-user, unlock-user, but there still is something up with selecting both users and databases.

Try to fix unsafe_database_exists and unsafe_user_exists next

fixed lock-user, unlock-user, but there still is something up with selecting both users and databases. Try to fix `unsafe_database_exists` and `unsafe_user_exists` next

oysteikt closed this issue

2025-12-14 07:22:59 +01:00

oysteikt commented

2025-12-14 07:29:10 +01:00

Some of the errors were seemingly collation errors for information_schema. Turns out that despite `SCHEMATA`.`SCHEMA_NAME` being VARCHAR(64), the data gets served as binary either because the table collation is not set or because of some internal stuff. Casting the selection to CHAR(64) works

Some of the errors were seemingly collation errors for `information_schema`. Turns out that despite ``` `SCHEMATA`.`SCHEMA_NAME` ``` being `VARCHAR(64)`, the data gets served as binary either because the table collation is not set or because of some internal stuff. Casting the selection to `CHAR(64)` works

Sign in to join this conversation.

No Assignees

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Projects/muscl#164