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?
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.
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.
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