Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
Testimonials
Renaud Lepage: "I was searching for a powerful server management as well as data management application, that could also have the ability to use stored procedures (MySQL5). I was using many separate apps. And then I stumbled upon this application. It just got better. With ease-of-use, powerful management, a very good level of customization, great MySQL server management and the very lushed graphical interface, MySQL Maestro is a product to consider seriously. I chose MySQL and this, to SQL Server 2000 and the MMC-integrated server management, for use in a programming course. I'm telling you, MySQL Maestro is a very powerful tool. Try it, you won't regret it".
Adam Allen: "I just have to say WOW!!! I'm so glad that you guys have developed something that is so useful for MySql. I am able to graphically view my tables, and I don't even have to think about my queries because I can visually design them. I just stumbled upon this, and I'm already very excited about it".

More

Add your opinion

Customers
Download Buy

SQL Maestro for MySQL online help

Prev  Return to chapter overview Next 

Setting profile options

Use the next wizard step to set the database alias and other profile options (the detailed description is given below). You can select several databases to set options for all the selected databases at once (except the alias which should be unique for each individual database). Click the Ready button when done to start working with the selected databases in SQL Maestro for MySQL.

 

 

Login prompt before connection

Use the option to enable SQL Maestro for MySQL to prompt for user name and password every time you connect to the database.

 

Keep connection alive

Check the box for pinging server before each query execution.

 

Show system objects

Check the box to make system objects visible.

 

Connect automatically at startup

With this option on connection to the profile database is automatically established at the application startup.

 

New object's names (Don't change case, Convert to upper case, Convert to lower case)

The option allows you to specify the newly created objects case.

 

Default table engine (MyISAM, InnoDB)

Use the drop-down list to specify the storage engine to be the default engine for the database tables.

MyISAM manages non-transactional tables. It provides high-speed storage and retrieval, as well as fulltext searching capabilities.

The InnoDB storage engine provides transaction-safe tables.



Prev  Return to chapter overview Next