Skip to content

show procedure error #2632

Open
Open

Description

@huangzuduan

Description

The stored procedure shows the definition under my current logged-in username (in grey), but it actually belongs to another user (after I changed the database name using phpMyAdmin). It shows fine in phpMyAdmin, but in HeidiSQL it appears as the current user and can't be changed. It should show the correct username.

HeidiSQL version and OS

Windows

Database server version

Mysql 8.4

Reproduction recipe

The stored procedure shows the definition under my current logged-in username (in grey), but it actually belongs to another user (after I changed the database name using phpMyAdmin). It shows fine in phpMyAdmin, but in HeidiSQL it appears as the current user and can't be changed. It should show the correct username.

Error/Backtrace

Activity

  1. added
    needs-infoReport needs and waits for additional feedback
    nettype-mysqlMySQL and/or MariaDB specific issue
    on Oct 13, 2026
  2. ansgarbecker commented on Oct 13, 2026

    @ansgarbecker
    Collaborator

    Please add the exact HeidiSQL version. Or even better, be sure to use the latest build.

    Also, add a screenshot of the relevant parts and the CREATE code of that procedure, so there's a chance to reproduce what you encounter here.

    I suspect what you see in gray is just the placeholder hint, right? When you see that, the box has no text, and the definer could not be determined. The current user is what you would set it to when you press Save.

    Image
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLneeds-infoReport needs and waits for additional feedbacknettype-mysqlMySQL and/or MariaDB specific issue

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions