..ooo Sprint 2:58 PM savstate.view.usg.edu l. Install mysql on your computer a.
ID: 3795628 • Letter: #
Question
..ooo Sprint 2:58 PM savstate.view.usg.edu l. Install mysql on your computer a. Windows User i. Download mysql from psaldew.mysglcom/downloads mysgll (chose correct version) ii. You can follow the instruction: https: Icorlewsolutions.com/articleslarticle- 21-how-to-install mysql-server-5-6-on- b. Mac User i. Follow the instruction to install mysql: https://dev.mysql.com/doc/refman/5.7/en/oss x-installation-pkg.html ii. Download Link: https: //dev. mysgl.com/downloads/mysgl/ c. Then start mysgl on terminal (set correct path) https: ildev mysglcom/doc/retman 57len osx- installation-prefpane html 2. Reset password: a. Remember the default password for the user 'root' provided by mysql app. b. Login to mysql use the default password by typing myrsal -u root-p (the second line paste the default password) c. After login you can reset password using: SET PASSWORD FOR root a localhost PASSWORD My NewPass'); MyNewPass is your new password and remember it! d. type quit to exist mysql. Next time login remember to use the new psw. 3. Execute following SQL commands to create a database and then you can create tables. You can follow this link. http: Iwww.wikihow.com/Create-a-Database-in-MySQL If you create table student can use the following command (my mysql terminal output)Explanation / Answer
The first query output will be
001 John Smith 3.6 20 CSCI 001
the second query output will be
Empty set
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.