Results 1 to 9 of 9

Thread: MySQL db tools

  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: MySQL db tools

    Hey I am new to MySQL. I am used to using Oracle with SQL Plus to run my scripts. My question: is there a good user program I can install on my windows machine to connect to my MySQL db to run my scripts to create new tables and test other scripts. It is a pain having to walk over to the other machine or try to telnet and I can't believe that there is no easy to use programs like SQL Plus for MySQL. Can anyone suggest any programs?

  2. #2
    Join Date
    Mar 2004
    Posts
    10
    PHPMYADMIN, it's available for windows.

    You can download it directly from their homepage:

    http://www.phpmyadmin.net/home_page/

    You can execute anything you want by selecting the "SQL" tab and pasting your scripts into the available text box.

  3. #3
    Join Date
    Jun 2004
    Posts
    12
    Hi,

    I think you should take a look at the latest version of MySQL Maestro, which is available at http://www.mysqlmaestro.com/products/download.html.

    MySQL Maestro supports all the latest versions of MySQL, including MySQL 4.1/5.0, and all of the most important MySQL features, including stored procedures and functions, InnoDB foreign keys, transaction-safe tables, etc.

    On top of everything, MySQL Maestro provides exceptional client-side features, such as multi-functional database explorer, visual query builder, data export and import and many more. For more information, you can visit MySQL Maestro website.

  4. #4
    Join Date
    Jun 2004
    Posts
    6
    I've used several different tools, but the two I use most:

    Web based: TableEditoR is handy if you have a Win server with ASP running. The price is right, too (free!)

    Client / server side: MySQLFront from http://www.mysqlfront.de is nice; it does everything I need for $25.00

    Hope that helps!
    TK

  5. #5
    Join Date
    May 2004
    Posts
    9
    I really, really like a program called EMS MySQL Manager. It's not free, but it's pretty cheap, and it works incredibly well. It is now a crucial tool I use whenever I make a site.

  6. #6
    Join Date
    Mar 2004
    Posts
    10
    I prefer SQLyog and I simply adore its Data Sync Tool. Its pretty reasonable for $49 also.

  7. #7
    Join Date
    Jul 2004
    Posts
    4
    I would suggest using QLR Manager at www.qlrmanager.com. It allows you to write and save queries (batch queries as well, separated by a semi-colon) to execute against your database. It's a server based tool (PHP) that you can run from a browser anywhere once set up.

    It's primarily a reporting tool (does a great job), but the fact that you can run batch queries, should do the trick for you.

    Jake

  8. #8
    Join Date
    Mar 2004
    Posts
    33

    Thumbs up

    I would suggest to try MySQL Turbo Manager is very easy to use and included many features for MySQL and PHP .

    More information about the latest version :http://www.mentattech.com

  9. #9
    Join Date
    Jul 2004
    Posts
    2
    Hello. I'm also new to MySQL. Although I've been using EMS MySQL Manager so far, today I got DBDesigner 4 (http://www.fabforce.net/dbdesigner4/).
    This an Open Source tool and it looks great.
    If anyone else knows it, I'll appreciate their comments/reviews on this one

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •