CramX Logo
RegisterLog in

Managing MySQL Users: Command Line vs. MySQL Workbench

A solved assignment comparing MySQL user management techniques via CLI and MySQL Workbench.

Christopher Lee
Contributor
4.1
39
10 months ago
Preview (4 of 11 Pages)
100%
Log in to unlock

Page 1

Managing MySQL Users: Command Line vs. MySQL Workbench - Page 1 preview image

Loading page ...

1Part 1:Using commandlineon TerminalHow can you create and manage MySQL users using both command line (Terminal) and MySQL Workbench?Explain the steps involved in creating new users, assigning privileges, and modifying userspecifications, aswell as how to verify user information and privileges in both interfaces. Include specific commands and stepsfor each method, and discuss any differences between the two approaches. (Word count: 300-350 words)STEP 1:Creating a new user using command line on TerminalTo start,launchStart,chooseMySQL 5.6 Command Line Client–UnicodeEnter password: Enter your password,which you’ve created during installation;Press Enter;We’llcheck the existing users by:Mysql> select Host, User from mysql.user;Your response will look like this:HOSTUSER-----------------------------------------127.0.0.1rootLocalhoststudent1Now, to add new user:Mysql> CREATEUSER ‘username’@’localhost’ IDENTIFIED BY ‘password’;Press Enter.Please note:Username and password are in a single quotes.Statement is ended with semicolon.

Page 2

Managing MySQL Users: Command Line vs. MySQL Workbench - Page 2 preview image

Loading page ...

Page 3

Managing MySQL Users: Command Line vs. MySQL Workbench - Page 3 preview image

Loading page ...

2STEP2:Finding information on usersTo verifycurrently definedusers,write and execute the query to display the following information:Mysql>select Host, User from mysql.user;And the result set will include anewlycreated user.HOSTUSER---------------------------------127.0.0.1rootLocalhoststudent1Localhoststudent2

Page 4

Managing MySQL Users: Command Line vs. MySQL Workbench - Page 4 preview image

Loading page ...

3Please addBefore andAfter screenshots to the Report.
Preview Mode

This document has 11 pages. Sign in to access the full document!

Study Now!

X-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Subject
Information Technology

Related Documents

View all
Class Notes

DevOps and Its Importance Study Notes

Past Exams

Veeam Certified Engineer VMCE-V12

Past Exams

Modules 1 - 3 Basic Network Connectivity and Commu

Class Notes

Notes CCNA

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 20

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 22

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 36

Class Notes

Foundations of Novell Networking Section 26

Class Presentation

Modulo 7 DHCPv4

Class Notes

Build and troubleshooting Integration Challenge