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. Ability to define timezone for datedime fields

    Currently dbforge shows datetime fields in its deafult formats. My system timezone is MSK (Moscow) and mysql global.time_zone and session.time_zone are set to SYSTEM. dbfogre shows it this way: 2018-11-29 08:13:45Z. I need to get something like this: 2018-11-29 11:13:45MSK

    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 →
    • 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 →
      • hide comments

        It would be nice when debugging large queries that have been pasted into the editor and everything but relevant parts are commented out to be able to hide those commented lines (a bit like code folding in other editors)

        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 →
        • turn off data types in column headings

          I dont need data types in column headings, it disturbs me.

          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 →
          • Get format from server

            For datetime and decimal types dbForge Studio has its own definitions. You should add a setting that will get the format from server and preferably it should synchronize changes for example if I execute `SET lc_time_names = 'tr_TR';` it should change UI format accordingly.

            But as a former developer and DBA admin (both mssql) I expected to see result of my query formatted in server and session parameters. For example if I set language to US English in Sql Server for my session all the datetimes in my results shown in US format both in Management Studio and my .Net…

            4 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 'column select' like notepad++ and SSMS

              Adding column select/typing like in notepad++ and SSMS.

              ALT + left mouse button, and drag

              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 →
              • 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…)
                                2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                                You have to select ‘utf8 → Unicode (UTF-8)’ on the ‘Advanced’ tab of the ‘Database Connection Properties’ dialog box that can be opened by right-clicking the connection in Database Explorer and selecting ‘Modify Connection’ from the popup menu.

                              • 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…)
                                  1 comment  ·  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 →
                                          ← Previous 1 3 4 5 19 20
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base