Managing MySQL Users: Command Line vs. MySQL Workbench

Preview 4 of 11 pages

See the first 4 pages exactly as they appear in the document.

Page 1
Read page 1 as text
1 Part 1 : Using command line on Terminal How 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 user specifications, as well as how to verify user information and privileges in both interfaces. Include specific commands and steps for 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 Terminal To start, launch Start, choose MySQL 5.6 Command Line Client – Unicode Enter password: E nter your password , which you’ve created during installation; Press Enter ; W e’ll check the existing users by: Mysql > select Host, User from mysql.user; Your response will look like this: HOST USER ------------------ ----------------------- 127.0.0.1 roo t Localhost student1 Now, to add new user: Mysql> CREATE USER ‘username’@’localhost’ IDEN TIFIED BY ‘password’; Press Enter. Please note : U sername and password are in a single quotes. Statement is ended with semicolon.
Page 2
Page 3
Read page 3 as text
2 S TEP 2 : Finding information on users To verify currently defined users , write and execute the query to display the following information : Mysql> select Host, User from mysql.user; And the result set will include a newly created user. HOST USER ------------------ --------------- 127.0.0.1 roo t Localhost student1 Localhost student2
Page 4
Read page 4 as text
3 Please add B efore and A fter screenshots to the Report.

7 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.