SmartMySQL is a next-generation GUI tool for the RDBMS MySQL. It has unique advanced features help to Speed up SQL and PL/SQL development time, Optimize slow query and recommends optimal indexes and Debugs Production MySQL problems and provides fixes.
SmartMySQL works on the Windows platform starting from Windows XP to Windows 10 . It has also been made to work under MAC, Linux and various Unix’s OS. Further a subset of MySQL Workbench or SQLyog Enterprise/Ultimate functionalities are available with the free version. SmartMySQL makes MySQL smarter.
Connect to DB server:
Once you start SmartMySQL, you will get a figure as shown below. You need to enter your SmartMySQL email and password. It is a one-time program.
After your authentication, you will get a figure as shown below to connect to the MySQL server.
You need to connect to MySQL server in SmartMySQL connection window before you will perform any activities. You can connect to the MySQL server in the following ways.
SmartMySQL gives you a choice between two different connectivity options allow you to smartly manage your MySQL Server(s).
SmartMySQL is next generation MySQL tool if you need to monitor your MySQL's OS and then you can enter DB server OS details. Also, it can directly pull slow queries log and Error logs details if you provide details and analyze and summarize them. It supports Linux OS and local windows servers.
In advance, tab can allow users to change connection settings
After you have established a connection with SmartMySQL you will get a window like
It shows the connection name and the database host name of the current connection.
All SmartMySQL features are listed in the menu bar e.g query execution, Query Optimization, PL/SQL code generator.
DB Object Browser
SmartMySQL builds tree Structure with all DB objects. If you open database you can see all tables, Views, Stored Procs, Triggers and Events. It also constructs an ER diagram for each database and it will be visible in the diagram.
In these Windows allow you to write SQL queries and it can identify syntax errors, slow queries.
Result Window display query result set. Also, it can display query profile, Visual Explain, inline table edit options and many more.
SmartMySQL has the ability to save database sessions savepint and It can able open connections from the savepoint to the same state as when the savepoint was generated.
With the term "database session" we understand the sum of all open connections as well as all Query tables opened in every connection as well the History tab and Frequently Execute Queries(FEQ) for every connection.
1) The automatic way
SmartMySQL will restore your previous session along with all the query tabs , history tab and FEQ. The way you left it. This option can be found in Tools > Preferences > Others > Restore session on startup.
2) The user-managed way
Open Session Savepoint: used to open a saved session.
Save Session: Save the current session.
Save Session As: Save in a different file name.
End session: Session will be ended