Scribd
Upload
6 views5 pages

Connect and Manage MySQL Databases

The document outlines different methods for connecting to MySQL, specifically using the MySQL Command Line Client and MySQL Workbench. It provides instructions for creating, viewing, and deleting databases through command line commands and the Workbench interface. Key commands include 'show databases;', 'create database mydb;', and 'drop database mydb;'.

Uploaded by

pandekrishna723
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views5 pages

Connect and Manage MySQL Databases

The document outlines different methods for connecting to MySQL, specifically using the MySQL Command Line Client and MySQL Workbench. It provides instructions for creating, viewing, and deleting databases through command line commands and the Workbench interface. Key commands include 'show databases;', 'create database mydb;', and 'drop database mydb;'.

Uploaded by

pandekrishna723
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Contents

 Different ways to connect with MySQL


 Create, View and Delete Database

Different ways to connect with MySQL

1. Using MySQL Command Line Client


2. Using MySQL Workbench

Using MySQL Command Line Client

 Search MySQL 8.0 Command Line Client in Windows Search Field

 Enter Password

 MySQL Welcome Screen


View/ Create /Delete Database

 Display all existing database


show databases;

 Display Currently Active Database


select database();

 Choose Database
use database_name;
 Create New Database
create database mydb;
 Delete Existing database
drop database mydb;

Connecting with MySQL Using MySQL Workbench


 Open MySQL Workbench

 Click on Local Instance

 Enter Password, Click on OK


 Click on Schema

 Right click on blank space and Click on create schema


 Enter Name and click on Apply button

You might also like