close[x]


MySQL

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection



learncodehere.com




MySQL - Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases.

MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries.

MySQL Workbench provides a visual console to easily administer MySQL environments

MySQL Workbench provides a suite of tools to improve the performance of MySQL applications


Connect to MySQL Using MySQL Workbench

To start MySQL Workbench on Windows, select Start, Programs, MySQL, then select MySQL Workbench. This executes the MySQLWorkbench.exe file on your system.

Step 1 - Launch the MySQL Workbench.

mysql workbench

Step 2 - Enter the connection name e.g., Localhost. You can name it whatever makes sense to you. By default, the username is root. If you use a different user account, you can change it in the Username textbox.

mysql workbench


Step 3 - Click the Store in Vault ... button to enter the password for the provided user account. A window will display. You enter the password and click the OK button.

mysql workbench

Step 4 - Click the Test Connection button to test if the connection to the MySQL Server is successful or not. Then click the OK button if the connection is established successfully.

Step 5 - Click the OK button to save the connection.

mysql workbench

Step 6 - Click the newly created connection under MySQL Connections to connect to the MySQL Server:

mysql workbench

Step 7 - MySQL Workbench display with the current schemas and a pane for entering queries:

mysql workbench