Customers
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 |
