To check user privileges in MySQL Workbench, click Users and Privileges on the Management tab of the left navigation pane:
This opens the Users and Privileges screen on the Login tab.
How to Check User Privileges in MySQL Workbench using the GUI
DBMS
Database Management Systems
How to View Current Connections in MySQL Workbench using the GUI
You can use MySQL Workbench to view current connections in MySQL either by query or by GUI.
- By Query: Run SHOW PROCESSLIST; in a query tab.
- By GUI: Click on Client Connections in the Management tab of the left navigation pane.
Screenshots below.
How to Check the Server Status in MySQL Workbench using the GUI
To check the status of a MySQL server using the MySQL Workbench GUI:
- Click the MySQL connection (as you would normally do when connecting via MySQL Workbench)
- Click Server Status from the Management tab in the left navigation pane
The Server Status window will appear, displaying the server’s status and related information:
What is MySQL Workbench?
MySQL Workbench is a graphical tool for working with MySQL.
MySQL Workbench provides an easy to use interface for performing the many tasks involved when working with databases. It integrates SQL development, administration, database design, creation and maintenance into one visual integrated development environment.
MySQL Workbench is similar to SQL Server’s SSMS, which is used for administering SQL Server.
How to Create a Table in SQL Server using a Query
To create a table in SQL Server using a query:
- In the SQL Server Management Studio, click the New Query button on the toolbar
- Type or paste a
CREATE TABLEscript (example below) - Click the ! Execute button on the toolbar
Here’s an example:
How to Use the Query Designer in SQL Server
To use the Query Designer in SQL Server:
- Open a new query by clicking New Query on the toolbar
- Open the Query Designer by selecting Query > Design Query in Editor... from the top menu
- Add the tables you want to run the query against
- Build the criteria for your query then click OK
The query will appear in the query window. To run the query, click ! Execute or press F5
Below are screenshots for the above steps.
How to Create a View in SQL Server
To create a view in SQL Server:
- Open a new query by clicking the New Query button in the SSMS toolbar
- Type or paste a CREATE VIEW statement (example below)
- Run the script
The view will now be created in the database. You will be able to see it under the Views node in the Object Explorer.
You can now use SELECT statements against the view in future queries.
Below are screenshots of the above steps.
How to Create a Stored Procedure in SQL Server
To create a stored procedure in SQL Server:
- Click New Query on the SSMS toolbar
- Type (or paste) a CREATE PROCEDURE statement (example below)
- Click the Execute button on the toolbar
This will add the stored procedure to the database. You can see it under the Stored Procedures node in the Object Explorer.
Below are screenshots and more detail for the above steps.
How to Create a Query in Access
To create a query in Access 2013 or 2016:
- Click the CREATE > Query Design button on the Ribbon.
- Choose the tables to include in the query
- Choose the fields to include, and adjust the criteria
- Click the Run button (or just switch to Datasheet view)
The results of the query will be displayed.
You also have the option of saving your query. To save the query, right-click on the query tab. click Save, and name it at the prompt.
How to Create a Form in Access
To create a form in Access 2013 or 2016:
- On the left navigation pane, click the table or query that contains the data for your form
- From the Create tab on the Ribbon, click Form
This creates a form based on the table or query that you selected from the navigation pane. You can modify the form as required.
You can also create a blank form (using the Blank Form button) or you can use the Form Wizard to create a form.