dbForge Studio for MySQL

dbForge Studio for MySQL is a universal set of MySQL GUI tools for database management, administration and development. It enables to create and execute queries, develop and debug MySQL routines, and automate MySQL database object management in the convenient environment.

http://www.devart.com/dbforge/mysql/studio/

I suggest you...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. SSL connection

    Although dbForge is capable of switching to clear-text authentication during login, it cannot use SSL which makes no sense to use it with any external authentication implementations (like auth_pam_compat)

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
    • utf8mb4 support

      The databse charset set to "utf8mb4" and the collation set to "utf8mb4_general_ci". The table set as same as database, this field same as database. But when run query statement, all the chinese character was unreadable, the comment of field does too. For the comment of field, the correct string should be "地区Id", when I edit the table, he character look such as "鍦板尯Id". The other mysql studio works fine, such as MySql Workbench, Navicat.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • Syntax highlight in function body and anonymous blocks

        Please support for syntax highlight in function body and anonymous blocks defintion (i.e. between $$).
        Even obsolescent pgAdmin3 has this feature.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
        • "unterminated dollar-quoted string" error when creating plpgsql function with an empty string as default parameter value

          dbForge Studio Express for PostgreSQL 1.0.410.
          PostgreSQL 10.3 on x86_64-alt-linux-gnu, compiled by x86_64-alt-linux-gcc (GCC) 5.3.1 20151207 (ALT Linux 5.3.1-alt3), 64-bit

          "Unterminated dollar-quoted string" error raises when creating plpgsql function with an empty string as default parameter value.

          Repro:

          execute this script in dbForge Studio:

          create or replace function dbo.test123
          (
          p text = ''
          )
          returns void
          as
          $$
          declare
          begin
          null;
          end;
          $$
          language plpgsql;

          output:
          --------
          ------ Execution started: Connection: SQL.sql ------

          Error (1,1): unterminated dollar-quoted string at or near "$$
          declare
          begin
          null"
          DML succeeded [0,005s]
          Error (12,1): unterminated dollar-quoted string at or near "$$
          language plpgsql"

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
          • high dpi font zoom

            in high resolution/dpi, like 2k or 4k under 30" screen, the control and tree font is too small and could not found setting to adjust.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →

              Could you please provide us the following information:
              1. The exact value of DPI you are using.
              2. Version of dbForge.
              3. Screenshot displaying the issue.

            • Do not display Object Does Not Exist error when object exists

              Scenario
              -----------
              DB user has SELECT privileges on mysql.proc.
              DB user has ALL PRIVILEGES on schema_A, and NO PRIVILEGES on schema_B.
              DB user is running dbForge for MySQL 8.0.40
              A Stored Procedure (sp_A) in schema_A calls a Stored Function in schema A (fn_A).
              A Stored Procedure (sp_B) in schema_B calls the Stored Function in schema A (fn_A).

              Therefore, in the Database Explorer tree view, schema_A is listed, schema_B is not.

              Action
              -----------
              The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.

              Result
              -----------
              dbForge pops up an error message…

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                Could you please provide us the result of the following query:
                SHOW GRANTS FOR ’DB_user_name’@’host_name’

                You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

              • Data Editor - Option to show UPDATE/INSERT/DELETE statements before commit

                MySQL Workbench allows users to review the update/delete/insert SQL before committing a change in the data editor. This can be useful if you would like to run the same edits on multiple connections or you would like to perform similar edits.

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Group SQL Tabs by Connection

                  MySQL Workbench allows shows a tab per connection under which it displays the SQL tabs. This makes it more difficult to accidentally run a query on the wrong connection.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                  • Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy

                    As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

                    Here is a simple procedure that will trigger the error:

                    DELIMITER $$

                    DROP PROCEDURE IF EXISTS sp_test$$

                    CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`()
                    MODIFIES SQL DATA
                    BEGIN

                    ALTER TABLE foo RENAME TO bar;

                    END
                    $$

                    DELIMITER ;

                    Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error message "Unable to parse…

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                      Could you please provide us the following information:
                      1. Server version.
                      2. Result of the following query:
                      SHOW CREATE PROCEDURE sp_test;

                      You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

                    • Ability to stop checking for updates

                      Add a button or checkbox to the Update Now, Ask Later screen to have it stop asking you to update. We do not update a product unless there is a benefit to us. I am sure some others will feel the same.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                        This can be setup as follows:
                        1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
                        2. Navigate to the ‘Environment → General’ section.
                        3. Unselect the ‘Check updates on startup once a week’ option.

                      • Update Devexpress

                        Update to the latest version of Devexpress. There has been alot of improvement since version 13. Version 18.1 is out currently

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Support Mariadb 10.3 or at least allow connecting to unknown future versions with just a warning.

                          I would much rather take the risk that something won't work quite right than be relegated to not even being able to try. Most things should work no matter what.

                          3 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                          • Ability to track temporary tables in debugging mode

                            I would like to be able to track the values in temporary tables via the watch window or have an ability to query them directly within that session. This is for complex reporting procedures that use temporary tables extensively.

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                            • Provide a new option to perform page breaks in output documentation

                              Provide a new option to perform page breaks in documentation when generating documentaion (e.g. at database table level). This would allow the documentation to be more readable for users. (SQL Documentor)

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →

                                Could you please provide us screenshots of the actual and expected results?

                                You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

                              • memsql support

                                Предполагается ли поддержка memsql? https://www.memsql.com/product/

                                База реализует протокол MySQL. к ней можно подключиться любым MySQL клиентом, но не DbForge. Выдает ошибку https://i.imgur.com/vDP8fI0.png

                                Вероятно связано с особенностями DbForge при подключении к MySQL.
                                Поддержка memsql практически ничего не стоит, так как используется MySQL протокол, зато можете написать, что DbForge очень крутой и поддерживает еще и эту memsql

                                С уважением, Сергей

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Questions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Be able to close connection from the stored procedure editor

                                  Not sure if it needs to be classified as a bug or a new features BUT!!!!
                                  I noticed today after our Aurora AWS Cluster failed over that I was not able to recompile a stored procedure I was altering.
                                  From a query window you can close the connection and an execute will open it again.
                                  But you can't close the connection from the editor!!
                                  And it's the same with Table Editor.
                                  I know you can close it from the DB Explore but it's inconsistent with the SQL Editor UI. You should have the same buttons.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Issue with Data Editor not respecting Edit mode set in settings after first edit.

                                    1. Options > Data Editor > General > Open Data Editor in read only mode
                                    2. Execute a SELECT statement. Data Editor shows up in Read Only Mode. Good.
                                    3. Flip Data Editor to Edit current table. Do one edit. Apply.
                                    4. (Optional: Flip Data Editor back to Read Only Mode)
                                    5. Execute a SELECT statement on ANY table. Data Editor shows up in Edit Mode on the current table. Disregarding both its last set state or System Setting

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                                      We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

                                    • Data comparsion bug

                                      In Data comparsion I see in "Only in Source" 29 rows. Problem is all rows are exists in the target Database! I have last (7.4.201) version of dbForge. Column "Different Records" ist will make data wrong too.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Find and replace 'Look in' value setting

                                        It would be nice to be able to set the find and replace 'look in' value to a default. I personally don't like having it search all documents by default since all the other editors I use don't do this.

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 19 20
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base