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. Search text in trigger statement

    The text search in trigger statements doesn't work using the "Find box" with "Look in -> Current Document".

    Can you please solve this problem?

    Thank you very much for your great work!

    Francesco

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    • JSON import to handle relational json data objects

      JSON can store complex and dynamic relational data structures. It self describes the data structure, but when you want to import that into a relational database, you need to create the tables and capture the relationships using primary and foreign keys. A smart import which could create the tables and keys on the fly would be invaluable

      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 →
      • 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • New function

          it is necessary to add a great feature: if there is a connection to several databases that would click on any of the objects, this database became active and the request addressed to the active database, with active database would be highlighted, and the passive was less bright. this function is for heidisql.

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Can't follow Caret when input Chinese characters

            When using Chinese PinYin input(such as QQ pinyin input), the input box will keep at the left-top screen, don't follow my cursor position.

            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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • Handle newline and carriage return in result data

              When results from SQL query contain a newline/carriage return, only the first part of the result (until the first CR) is displayed.

              For instance, if my DB field contains CR as follows :
              My Business
              1 park avenue
              New-York
              USA

              When getting this field content through select, only the first line ("My Business") is displayed in the result panel.

              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  ·  Bugs  ·  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…)
                      2 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 →
                      • 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 →
                                          ← Previous 1 3 4 5 17 18
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base