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. EXPLAIN Partitions isn't working (but it used to in older versions)

    Version: 8.0.80 (Professional)
    Tried with MySQL 5.6 and 5.7

    Explain Partitions returns an error, but it works fine on the MySQL CLI.

    In dbForge I ran:
    EXPLAIN partitions SELECT * FROM log.log;

    And the error I got was:
    Table 'log.partitions' doesn't exist

    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 →

      Hello,

      This issue is going to be fixed in the next product build. Currently, as a workaround, you can run statement using F5 button.

    • Solution based database explorer

      When working within a solution/project it would be nice to have only the databases listed in the database explorer that are actually needed by the solution.

      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 →
      • A right-click WHERE option on tables from the Query Builder

        By right clicking on a column of a table, the WHERE option would be available and allow the selection and completion of the WHERE statement on the selected column. Same could be done with Order By, Group By and Having.

        Many thanks !

        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 →
        • Make a feature where it doesn't crash every hour

          Software crashes very frequently when it's just idle.

          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 →

            >Software crashes very frequently when it’s just idle.

            Could you provide us with more details on this one? What is the edition and a version of the very Studio? In addition, it would be nice and helpful to have a short video of the issue.

          • Script generation auto_increment bug

            When backing up a database or creating CREATE script from a table, the auto_increment attribute is not set on a column which is not defined as a primary key.

            eg.

            CREATE TABLE wp_questions_form_element (
            elementid int(11) NOT NULL AUTO_INCREMENT,
            formid int(11) NOT NULL,
            element_order int(11) NOT NULL,
            element_type_code varchar(50) NOT NULL,
            element_params varchar(3000) DEFAULT NULL,
            questionid int(11) DEFAULT NULL,
            attachmentid int(11) DEFAULT NULL,
            mandatory bit(1) NOT NULL DEFAULT b'0',
            deleted_flag tinyint(1) NOT NULL DEFAULT 0,
            PRIMARY KEY (formid, element_order),
            INDEX idx_wp_questions_form_element_elementid (elementid)
            )
            ENGINE = INNODB,
            AUTO_INCREMENT = 262150,
            AVG_ROW_LENGTH = 76,
            CHARACTER SET latin1,
            COLLATE latin1_swedish_ci;

            When creating the…

            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 →

              We were able to reproduce this issue and will fix it in the next product build. We will notify you once it’s available for downloading.

            • Master password

              Application now allows user to save connection information. It also allows saving password for saved connection which is very bad idea without encrypting the saved password. This means the database password is available for anyone having physical or virtual access to the hard-drive. Usual way to solve this problem is using master password (like password managers etc. do). Master password is easy to implement but very useful feature so you don't need to copy-paste the database passwords from separate password manager. This might not be suitable for all but I suppose nice feature for many.

              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 →
              • 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 .

                                          ← Previous 1 3 4 5 19 20
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base