{"id":7624,"date":"2019-11-06T09:43:26","date_gmt":"2019-11-06T09:43:26","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=7624"},"modified":"2019-11-19T06:14:53","modified_gmt":"2019-11-19T06:14:53","slug":"how-to-download-and-install-mysql-in-macos-10","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-download-and-install-mysql-in-macos-10\/","title":{"rendered":"How to Download and Install Mysql in Macos 10"},"content":{"rendered":"\n

Step 1 –<\/strong> Download a DMG package from here
https:\/\/dev.mysql.com\/downloads\/mysql\/<\/p>\n\n\n\n

Step 2 –<\/strong> Download a DMG package from here
Click on DMG file and again you get .pkg file.<\/p>\n\n\n\n

Step 3 – <\/strong>Start installation by clicking on .pkg and follow the installer.<\/p>\n\n\n\n

Step 4 – <\/strong>During installation, make sure that you have captured and stored a A temporary password is generated for root.<\/p>\n\n\n\n

A temporary password is generated for root@localhost: rqJoR.vdr16P
\nIf you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.<\/p>\n\n\n\n

Step 5 – <\/strong>
Insert MacOS admin password for during prompt.
Start MySQL
sudo \/usr\/local\/mysql\/support-files\/mysql.server start<\/p>\n\n\n\n

Stop MySQL<\/strong>
sudo \/usr\/local\/mysql\/support-files\/mysql.server stop<\/p>\n\n\n\n

Restart MySQL<\/strong>
sudo \/usr\/local\/mysql\/support-files\/mysql.server restart<\/p>\n\n\n\n

Step 6 – <\/strong>How to verify mysql server is running or not
\/usr\/local\/mysql\/bin\/mysql -u root -p<\/p>\n\n\n\n

Step 7 – <\/strong>You must set new password first time you login to mysql else it would through following erros.<\/p>\n\n\n

\nRajeshs-MacBook-Pro:bin rajeshkumar$ \/usr\/local\/mysql\/bin\/mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with<\/span> ; or \\g.\nYour MySQL connection id is 6<\/span>\nServer version: 5.7<\/span>.28<\/span>\n\nCopyright (c) 2000<\/span>, 2019<\/span>, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of<\/span> Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of<\/span> their respective\nowners.\nType 'help;'<\/span> or '\\h'<\/span> for<\/span> help. Type '\\c'<\/span> to clear the current input statement.\nmysql> show databases;\nERROR 1820<\/span> (HY000): You must reset your password using ALTER USER statement before executing this<\/span> statement.<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
How to set up your password for the first time<\/strong>?<\/p>\n\n\n
\n$ \/usr\/local\/mysql\/bin\/mysql -u root -p\n\nSET PASSWORD = PASSWORD('your_new_password'<\/span>);\nor\nALTER USER 'root'<\/span>@'localhost'<\/span> IDENTIFIED BY 'MyNewPass'<\/span>;<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
More Reading<\/strong>
 https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/osx-installation-pkg.html
 https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/osx-installation.html<\/p>\n","protected":false},"excerpt":{"rendered":"
Step 1 – Download a DMG package from here https:\/\/dev.mysql.com\/downloads\/mysql\/ Step 2 – Download a DMG package from here Click on DMG file and again you get .pkg file. Step 3 – Start installation by clicking on .pkg and follow the installer. Step 4 – During installation, make sure that you have captured and stored…<\/p>\n","protected":false},"author":1,"featured_media":7728,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[49],"tags":[3120,237,469,5551,5550,493],"class_list":["post-7624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","tag-download","tag-install","tag-mac","tag-macos","tag-macos-10","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=7624"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7624\/revisions"}],"predecessor-version":[{"id":7626,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7624\/revisions\/7626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/7728"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=7624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=7624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=7624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}