Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL GUI

    If MySQL is open source why can't I find any free tools out there. Anyone using freeware to edit your db. All I'm looking for is to be able to edit the db nothing else.

  • #2
    MySQL

    have you tried using SQLyog. i use it to access the db to make changes. do a search online and you should find a link to tha free version

    Comment


    • #3
      SQLyog is what I have been using. I believe thats in the Shoretel documentation as well.

      Comment


      • #4
        The only downside to SQLyog is that the free version is on a limited lifespan. It works great for the install and shortly thereafter, but in the long run I believe that you begin to violate the intent of the license.

        Comment


        • #5
          Yes, that is my issue with SQLyog. You get a 14 day trial and thats it, you then have to buy it. I found others like 'toad' but it doesn't have the GUI like SQLyog.

          Comment


          • #6
            Free MySQL tool

            The folks at dev.mysql.com have a free tool called MySQL Workbench, the current GA version being 5.1.18a.

            MySQL :: Download MySQL Workbench

            It combines what used to be three separate programs (Administrator, Query Browser, Migration Toolkit) into one. I have not used it as I have the older MySQL GUI Tools Bundle, which can still be downloaded from here:

            MySQL :: MySQL GUI Tools Bundle: Archived Downloads

            JB

            Comment


            • #7
              It's not free, but I've found Navicat MySQL to be very easy to use -- and much more feature rich than any of the freebies out there. It's around $100 bucks but after trying many of the free tools I considered it money very well spent...

              Navicat - MySQL Overview - Best alternative to phpMyAdmin tool for Oracle management, MySQL administration & PostgreSQL development for Windows, Linux & Mac OS X - Download Now!

              Comment


              • #8
                Other choices

                I found the MySQL Workbench application too complex for my needs, and after doing some digging around I found Toad for MySQL, which has a free version that can be downloaded from here:
                Toad for MySQL Freeware

                JB

                Comment


                • #9
                  I use microsoft access with the mysql odbc driver. I wouldn't suggest editing, reporting only.

                  In order to create an ODBC connection to the mySQL database, the 5.1 driver is required.
                  Download 5.1 from here: MySQL :: Download Connector/ODBC

                  The MySQL database is ODBC compliant. Parameter settings required to access CDR records in the MySQL database include:
                  - DRIVER={MySQL ODBC Driver}
                  - SERVER = localhost (or the server where you have MySQL installed)
                  - DATABASE = shorewarecdr
                  - USER =st_cdrreport
                  - password =passwordcdrreport

                  Comment


                  • #10
                    Yeah, I did the ODBC to MS Access route when I wanted to run custom CDR reports, such as the top ten longest calls, most frequently outbound called number, etc. Works very slick once it is set up.

                    JB

                    Comment


                    • #11
                      I installed workbench, it seems work just fine.

                      Comment


                      • #12
                        MySQL instal

                        Originally posted by southeasternMI View Post
                        If MySQL is open source why can't I find any free tools out there. Anyone using freeware to edit your db. All I'm looking for is to be able to edit the db nothing else.
                        Ok so when you find it and install it ...WHERE is everyone installing the SQLyog GUI?
                        Directly on the ECC server?

                        Comment


                        • #13
                          That really depends on what you want to do with the database. If all you want to do is poke around at all the tables or run reports, then you would install SQLyog on your computer and create a TCP/IP connection to your headquarters server, and leave the default port at 3306.

                          If you plan to modify any database entries, which I highly recommend you do not do if you are unfamiliar with MySQL, then you have two options. The only user that has sufficient rights to make changes is root, which is prohibited remote access for security reasons. You can either install SQLyog on the headquarters server, remote into the server and run SQLyog, or you can create a new MySQL user with sufficient rights so you can run SQLyog on your computer.

                          Comment

                          Working...
                          X