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. Support large (4k) resolution screen

    Today 4K resolution are widely adopted and mixed with 1080p
    In windows, we can use font scaling according to the screen
    that feature isn't used in dbforge studio, when we move the software from one screen to another, the layout should be adapted according to the settings

    moreover, the size of the font isn't used everywhere (the database explorer, the properties, or even the modify table feature doesn't use it) and the icons size should be increased if seen on a 4K display

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      started  ·  2 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
    • alter table sql needed when i edit table in GUI

      when i alter any column for renaming or chaning data type or any other action in table using GUI, I want it also as SQL code like in xampp

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
      • Allow to set object privileges with % and ?

        It is fine to have the ability to define object privileges to multiple objects using % or ??. Example: if backups are made to DB and users need to access them, it is fine to set privilege over DB% or DB?????? rather than add to each user privileges over DB1, DB2, DB170916 etc. each time a backup is created.
        Such functionality exists in MySQL Workbench: Schema Privileges - Add Entry - "Schemas matching pattern"

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
        • dbForge for MySql should default to utf8mb4 instead of utf8 to improve unicode support

          utf8 in mysql is a proprietary 3-byte format and doesn't support real utf8 encodings with 4-byte chars. As result, when dealing with real unicode, many scripts generated by dbforge fail with "Incorrect string value: \xF..." because mysql cannot understand 4 byte strings.

          The correct utf8 encoding in mysql is 'utf8mb4' and everywhere dbforge puts utf8 by default (generated scripts, default connection encodings, etc), it should put utf8mb4 to improve support.

          Currently I have to save all scripts and change utf8 to utf8mb4 manually.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • dbForge for MySql should default to utf8mb4 instead of utf8 to improve unicode support

            utf8 in mysql is a proprietary 3-byte format and doesn't support real utf8 encodings with 4-byte chars. As result, when dealing with real unicode, many scripts generated by dbforge fail with "Incorrect string value: \xF..." because mysql cannot understand 4 byte strings.

            The correct utf8 encoding in mysql is 'utf8mb4' and everywhere dbforge puts utf8 by default (generated scripts, default connection encodings, etc), it should put utf8mb4 to improve support.

            Currently I have to save all scripts and change utf8 to utf8mb4 manually.

            0 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Ability to freeze a column for tables which have a lot of columns

              Very helpful function for me, but DBForge doesn't have it.

              From Navicat manual:
              "If there are many columns in the table and you want to freeze one or more columns to id
              entify the record, just simply right-click the column you want to freeze and select Display -> Freeze Selected Column or select from the View menu.
              The frozen columns will move to the leftmost position in the table grid. This action will locks the frozen columns, preventing them from being edited."

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

                I have two mysql server. MariaDB 10.2 and Mysql 5.5.23
                When i make structure comparation i have such differences with default null fields:
                In MariaDB 10.2:
                gui_name VARCHAR(200) DEFAULT 'NULL',
                description VARCHAR(2000) DEFAULT 'NULL',
                In Mysql:
                gui_name VARCHAR(200) DEFAULT NULL,
                description VARCHAR(2000) DEFAULT NULL,

                And after sync these differences are remained

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  under review  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • HTML-View like in dbForge Studio for MSSQL

                  I'm usinge the free version for mySql and MSSql. In the MSSql I found the button to view the Data as HTML. It would be nice to have it in MySql-Version free also

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                  • I would like the ability to copy the values from the Parameters grid in dbMonitor.

                    I would like the ability to copy the values from the Parameters grid in dbMonitor. We use a lot of GUIDs for values, and it would be so much easier to be able to copy the values from dbMonitor that were used as parameters, or that were returned from stored procedures.

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                    • we need ability to print datareport from command line

                      Print datareport directly from command line

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

                        I am missing one feature from MySQL Workbench quite much - the "filter rows" feature that sit´s right abow the result grid. It let´s youe filter t he results quickly for a string, which I need maybe 100 times a day. This is much more efficient thant editing the query all the time (this can be quite long).

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                        • Customize Excel Export Template

                          It would be fantastic if we could create Excel templates that don't include a data source, file name, etc. All I really want is for my exported data to use all the default Excel fonts, formatting, etc., not the values from dbForge.

                          3 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Timezone for Session in Connection String

                            I want to define the timezone for my current session within the connection parameters (Advanced).

                            Today I fire the following SQL Script at first to the Server
                            set session time_zone = "MET";

                            For the character set you're already have such a feature!

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              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
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →

                                Could you please describe this in more detail and specify in what cases exactly this should be applicable?

                              • Make dbForge not to remove comments for procedure parameters

                                dbForge removes comments for the procedure parameters when I edit anything inside Parameter panel.

                                Let’s say I have

                                ...

                                Code: Select all
                                PROCEDURE host1355175_te.sp_fc_again(
                                IN p_user_id int /*comment for the procedure parameter is here*/, IN p_pair_id int, IN p_deb int, OUT o_res int)
                                COMMENT 'Comment for the procedure is here'
                                BEGIN

                                ...

                                “/*comment for the procedure parameter is here*/” will be removed if I, for instance, edit Comment via UI in Options panel or change parameter’s order.

                                0 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                • Local Query Log of metadata changes: tables, procedures, views, UDFs, etc.

                                  Add a setting by default, that once enabled - stores queries that affect metadata changes in a kind of transaction log locally on hard disk.

                                  Recenlty I've got a problem with hosting provider, who got DB dumps with only data in it, but it's lack of saving tables, procedures, views and UDFs. Its a fail.

                                  3 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                  • All open documents

                                    Hi,

                                    when opening a procedure and then Find the following should not happen:
                                    1. Look in: All open documents. Better: Current document
                                    2. If you search with 'All open documents' dbForge starts looking in the other open documents and not in the current document. It should first look in the current document.

                                    Ronald

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                    • return "Generate Schema Script" Feature

                                      Please, return "Generate Schema Script" Feature

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 6 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Allow for multiple Security Manager Tabs

                                          In order to compare user lists, particularly for environment migration (DEV->QA->PROD), it would be helpful to allow multiple tabs of the Security Manager so that users lists can be quickly compared.

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base