Select Tools->flush(or press Ctrl+Alt+F) to clear (or) reload  various  internal caches of MySQL.

Log Option

• Select Use_no_write_to_binlog  when no need to write queries in binlog.

Flush Options

• Select flush Deskey_file to
• Select flush USERRESOURCES to resets all per-hour user resources to zero. This enables clients that have reached their hourly connection, query, or update limits to resume activity immediately. It does not apply to the limit on maximum simultaneous connections.
• Select flush HOSTS to empties the host cache. Use this option when some of your hosts change the IP address.
• Select flush LOGS to close and reopen any log file to which server is writing.
• Select flush PRIVILEGES to reload user privileges from mysql. user table.
• Select flush QUERY CACHE to
• Select flush STATUS to  add the session status from all active sessions to the global status variables, resets the status of all active sessions
• Select flush  TABLES to close the all open tables in  a  server.
• Select flush TABLES WITH READ LOCK to close all open tables and lock all tables in  a server with read lock

Use Tools -> Table Diagnostics (Ctrl+Alt+T) to perform various Table Diagnostics operations.

Analyze

The Analyze Tables Wizard allows you to analyze and store the key distribution for the table. During the analysis the table is locked with a read lock. Currently MySQL supports analyzing only for MyISAM tables and transaction-safe type tables. MySQL uses the stored key distribution to decide in which order tables should be joined when one does a join on something other than a constant.

Check

The Check Tables Wizard allows you to check the database tables on errors. Options that you can use with CHECK operation.

Quick: Don’t scan the rows to check for wrong links.

Fast: Only check tables which haven’t been closed properly.

Changed: Only check tables which have been changed since last check or haven’t been closed properly.

Medium: Scan rows to verify that deleted links are ok. This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys.

Extended: Do a full key lookup for all keys for each row. This ensures that the table is 100 % consistent, but will take a long time!

REPAIR

The Repair Option allows you to repair the database tables that may be corrupted. Options that you can use with REPAIR option.

Quick: Do a repair of only the index tree.

Extended: Create the index row by row instead of creating one index at a time with sorting. This may be better than sorting on fixed-length keys if you have long char() keys that compress very good.

Optimize

The Optimize option should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use optimization to reclaim the unused space and to defragment the data file.

Select Tools->User Manager(or press Ctrl+U)  to see a list of all users and privileges that relate to an active MySQL server instance. From this tab, you can add and manage user accounts, adjust privileges, and expire passwords.

• User accounts showing a list of all user details. Use ‘add account’  to add a new user, ‘delete’ to delete an existing user.

Login Tab

The Login tab provides the following information related to the selected user account:

• Login Name: You may create multiple accounts with the same name to connect from different hosts.
• Authentication Type: For standard password or host-based authentication, select Standard. The caching_sha2_password andSHA256_Password authentication types provide more secure password encryption than the Standard authentication type.
• Limit to Hosts Matching: The % and _ characters may be used as wildcards. The percent sign (%) matches zero or more characters and the underscore (_) matches a single character.
• Password and Confirm Password: To reset a password, type in the new password and then confirm it. Consider using a password of eight or more characters with mixed-case letters, numbers, and punctuation marks.

Use expire password to require a change of password to use the account.

Account Limits tab

The Account Limits tab defines the following limits on the selected user account:

• Max. Queries: The number of queries the account can execute within one hour.
• Max. Updates: The number of updates the account can execute within one hour.
• Max. Connections: The number of times the account can connect to the server within an hour.
• Concurrent Connections: The number of simultaneous connections to the server the account can have.

Administrative Roles Tab

Roles are a quick way of granting a set of privileges to a user, based on the work the user must carry out on the server. It is also possible to assign multiple roles to a user account or to assign privileges directly to an account without first assigning roles.

After you select a role for a user account, you will see the accumulated privileges in the Global Privileges panel. For example, if you select the role BackupAdmin, the privileges granted include EVENT, LOCK TABLES, SELECT, SHOW DATABASES. For a complete list of privileges.

The Administrative Roles tab includes the following roles:

• DBA: Grants the rights to perform all tasks.
• MaintenanceAdmin: Grants rights to maintain the server.
• ProcessAdmin: Grants rights to assess, monitor, and kill user processes.
• UserAdmin: Grants rights to create user logins and reset passwords.
• SecurityAdmin: Grants rights to manage logins and grant and revoke server privileges.
• MonitorAdmin: Grants the minimum rights to monitor the server.
• DBManager: Grants full rights on all databases.
• DBDesigner: Grants rights to create and reverse-engineer any database schema.
• ReplicationAdmin: Grants rights needed to set up and manage replication.
• BackupAdmin: Grants minimum rights required to back up any database.
• Custom: Lists other (custom) privileges that are assigned to the user account. This role is not available for all default accounts, such as root. If you select a user account and then select one or more privileges directly that are outside of any selected roles, the Custom role is added (and selected) to the list of roles.

Use Revoke all privileges te remove all granted privileges to a user.

Schema Privileges Tab

The Schema Privileges tab refines the way you assign access rights to one or more schemas by user account. To assign privileges to the selected account by schema, do the following:

1.Add a schema entry (or rule) that specifies which schema or schemas apply the selected user account. Click Add Entry to open the New Schema Privilege Definition dialog. The dialog provides the following independent options to select:

• All Schema (%) – This rule applies to any schema name.
• Schemas matching pattern: pattern – Apply this rule to schemas that match the given name or pattern. You may use _and % as wildcards in the pattern; however, to use the literal value you must escape each wildcard character with a backslash (\) .
• Selected schema: schema name – Apply the rule to the specific schema name selected from the list. Use Delete Entry to remove an entry and the privileges associated with it from the list. When you click Revoke All Privileges, you are prompted remove all privileges assigned to the selected user account.

2.With an entry selected, mark the individual access rights that apply only to the schema or schemas defined in the entry. The access rights are categorized as Object Rights, DDL Rights, and Other Rights. Each right that you select appears in the Privileges column of the schema entry.

Select Tools->Show->Variables to get all MySQL global variables with their vales.

Select  Tools->Show->Process to show the running queries in server.

To kill  any running process in middles t select that process and click on ‘kill process’.

Select Tools->Show->Status to see the server status information.

 

select tools ->settings/preferences to set user defined preferences. In this option having a  total of  8  tabs.

General tab: 

Here you can specify a number of settings to customize displaying, editing and SQL statement processing features in SMARTMySQL.

Power tools tab:

Here you can enable/disable autocomplete help, query profiling in Query editor.

Fonts & Editor Settings tab:

Here you can specify the font, font size, font style of SMARTMySQL editor.

 

SQL Formatter tab:

Here you can specify the query in Expanded style or block style.

Others:

 Here you can specify the number of settings to customize displaying and editing data in SMARTMySQL .

Query Browser tab:

Here you can activate autocomplete query, animation settings

Query Optimizer:

Here you can specify the maximum number of showing columns in an index,  substring  length.

Debugger:

Here you can enable/disable debugger alerts