Install MySQL 8.0.32 on MacOS 12 Monterey [Step-by-Step Tutorial]
Рет қаралды 17,317
Күн бұрынLearn how to install MySQL 8 on MacOS 12 Monterey operating system. Once you successfully install MySQL 8.0.32 database server on macOS Monterey checkout my SQL course. The 11 hours Udemy SQL course link is here: bit.ly/3rIF1Ww
If you want to learn SQL or work on projects related to MySQL database, you'll require MySQL 8 database installed on your MAC PC. This video tutorial is a step by step guide to install MySQL 8 on macOS 12 operating system. The MySQL database has GPL license. And it’s free to download & use. The official website of MySQL is www.mysql.com/
Even though, in this tutorial I've used macOS 12, the installation steps in this video will work on, MacOS 10 OR codenamed versions like, Yosemite, El Capitan, Sierra, High Sierra, Mojave, OR Catalina etc. And also on macOS 13 Ventura. You can ask me questions in the comments section of this video, if you encounter installation errors or didn't understand something.
Chapters #
0:00 Introduction
0:55 Download MySQL community server 8.0.32
3:15 Check if macOS is ARM or x86
4:20 Install MySQL 8.0.32 on macOS 12
06:43 MySQL configuration on macOS 12
08:54 Manage MySQL server instance on macOS Monterey
10:25 Login to MySQL server on macOS 12 Monterey
11:30 Add MySQL path in macOS paths file
12:52 Confirm MySQL DB working fine
13:15 Checkout my SQL video course on Udemy
13:26 End message, try yourself, ask question
#MacOS12 #MySQL #Install #Monterey #database
@jerusalemt2343 9 ай бұрын
Organized and easy to follow. Thank you!!
@PnTutorialsbyPradnyankurNikam 9 ай бұрын
You are so welcome Jerusalem. Glad to know you liked the tutorial.
@pradyutdasgupta1350 11 ай бұрын
The best video on MYSQL installation. I literally mean, the best.!! Thank you.!!
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Thank you Pradyut for the positive feedback, Glad to know the tutorial was helpful to you 😊🙏
@tianbowen721 Жыл бұрын
Woah this is so amazing ! I spent the whole morning try to install MySQL and wasn't succesful, until the very moment that I found your video ^ -^ Thank you so much !!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Thank you Tian for the feedback. Glad to know the tutorial was helpful to you 😊🙏
@tianbowen721 Жыл бұрын
@@PnTutorialsbyPradnyankurNikam Yes definitely saved my life :Ddd just subscribed and feel free to create more
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Yes, I’ll keep uploading more content regularly on KZfaq. Thanks for the subscription 🙏
@kalpeshbhoir207 5 ай бұрын
thank you so much for this helpful video. I have been troubling sense last 1 week ,Finally I found your video and downloaded & installed the mysql very easily in my mac. 👍👍👍☺☺
@PnTutorialsbyPradnyankurNikam 5 ай бұрын
Thank you Kalpesh for the positive feedback. Glad to know the video tutorial was helpful to you. 😊🙏
@user-zw9vn3ii8h 5 ай бұрын
Straight forward and easy to understand. Highly recommended
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
Thank you Aniekan for the positive feedback, I appreciate it. 😊🙏
@ashita-3280 4 ай бұрын
Thaks fro sharing right knowledge❤. I have tried 3day.Now i finally get it thanks.🎉 Supporting with you.
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
Thanks Ashita for the positive feedback, I appreciate it 😊🙏
@PawanKumar-di2uk 8 ай бұрын
Extremely helpful video and so easy to follow. Thank you
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
You are welcome Pawan Kumar 😊🙏
@johnflanagan6367 2 ай бұрын
Very helpful video! Thank you for posting!
@PnTutorialsbyPradnyankurNikam 2 ай бұрын
You're very welcome John 😊🙏
@aneesharaj789 3 ай бұрын
Thankyou so much sir . easy to understand , it took 2 hrs to find but by watching this video it makes so simple
@PnTutorialsbyPradnyankurNikam 3 ай бұрын
You are welcome Aneesha. Glad to know the video tutorial was helpful to you. 😊🙏
@nawwintphyu1873 3 ай бұрын
Thank you so much for sharing!
@PnTutorialsbyPradnyankurNikam 3 ай бұрын
You are so welcome! 😊🙏
@swethasomanchi4315 8 ай бұрын
Thank you so much I have been trying to install MySQL connection for the past 1 year and faced errors finally today I have successfully installed MySQL server.
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
Thanks you Swetha for the feedback, Glad to know the tutorial was helpful to you.
@geraldinesalleskobilanski8357 Ай бұрын
Excellent!! Thank you so much!
@PnTutorialsbyPradnyankurNikam Ай бұрын
You are welcome, Geraldine Salles Kobilanski 😊🙏 I see you also sent me LinkedIn connect request and I accepted. Thanks for the connect request.
@belninzo 4 ай бұрын
Thank you so much! So easy to follow !
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
You are so welcome belninzo, Glad to know the video tutorial was helpful to you. 😊🙏
@vinaf4494 Жыл бұрын
Thank you, it's really helpful!!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
You're welcome Vina! 😊🙏
@yt-1161 19 күн бұрын
great explanation mate
@PnTutorialsbyPradnyankurNikam 18 күн бұрын
Thank you brother 😊🙏
@jesuscarrazanaloyola6847 5 ай бұрын
Thank you! Works perfect!
@PnTutorialsbyPradnyankurNikam 5 ай бұрын
You're welcome! Jesús 😊🙏
@WEAAM123451 7 ай бұрын
Thank you very much, It's very helpful
@PnTutorialsbyPradnyankurNikam 7 ай бұрын
You are welcome, Weam 😊🙏
@SireeshaYarlagadda-qy8li 3 ай бұрын
Thank you so much sir, I will learn your udemy course
@PnTutorialsbyPradnyankurNikam 3 ай бұрын
Thank you Sireesha for the positive feedback and interest in my Udemy Course. Check out following link to get my Udemy course (includes active coupon code with discount) www.udemy.com/course/sql-tutorial-learn-sql-with-mysql-database-beginner2expert/?couponCode=970755425144C9EF6BB5
@armandogutierrez2880 3 ай бұрын
Very Helpful video, thanks a lot. I was decided to resign but... I saw your video is really great tool and thanks for sharing. I will look for you in Udemy thanks
@PnTutorialsbyPradnyankurNikam 3 ай бұрын
Thank you Armando for the positive feedback, I appreciate it. Glad to know the video tutorial was helpful to you. Check out following link to get my Udemy course (includes active coupon code with discount) www.udemy.com/course/sql-tutorial-learn-sql-with-mysql-database-beginner2expert/?couponCode=970755425144C9EF6BB5
@ViryQueen28 Жыл бұрын
Thank u so much for the video. New Suscribe!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Thank you Viry for the feedback and subscribing to my channel 😊🙏
@Sarah_Bee21 8 ай бұрын
Super helpful!! Thanks!!!
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
You are welcome Sarah
@pahoolk Жыл бұрын
clearly as water, thanks a lot sir!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Thank you Paco for the positive feedback, I appreciate it 😊🙏
@ammiesobola9931 5 ай бұрын
Super helpful. thank you
@PnTutorialsbyPradnyankurNikam 5 ай бұрын
You're welcome Ammie 😊🙏
@soumyaranjansamalkiit 6 ай бұрын
LEGEND! 👑
@PnTutorialsbyPradnyankurNikam 6 ай бұрын
Thank you soumyaranjan for the positive feedback, I appreciate it.
@Navneetkumar-jq3tz 8 ай бұрын
Thank you great help
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
You are welcome Navneet 😊🙏
@adronhomesofficial 7 ай бұрын
thanks for the video
@PnTutorialsbyPradnyankurNikam 7 ай бұрын
You're welcome 😊🙏
@ADITYACHAUDHARY-fp4ys 11 ай бұрын
thank you so much
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
You're welcome! 😊🙏
@CodeLink1000 Жыл бұрын
Thanks. The he video was very helpful. You have a new subscriber. Can you do a video on downloading mysql workbench for same version?
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Hi Code5, Glad to know the tutorial was helpful to you. Sure, I'll create a video tutorial for downloading & installing MySQL workbench soon. Meanwhile, you can download MySQL workbench from the following link. dev.mysql.com/downloads/workbench/ On downloads page, For "Select Operating System" option, select "macOS" And for "Select OS Version", select ARM or X86 (depending on your processor). Then It will show .dmg installar. Download the .dmg installer file to your computer. And, the installation is straightforward. Let me know if it helps. Regards, Pradnyankur Nikam
@taggincrewz8855 11 ай бұрын
Thank You, editing bashfile was not working for me, this trick worked.
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi Taggin Crewz, Great! Glad to know the step in this video worked for you. 😊🙏
@mayk8024 11 ай бұрын
You are amazing its very helpful just when I try to save it and exist it’s not working by using o x as you mentioned so I could not complete
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi Mayk, Thanks for the feedback, I appreciate. To save on your macOS terminal, you should press command key ⌘ and o key then press enter. And then command key and x to exit. Let me know if it works.
@armandogutierrez2880 11 ай бұрын
Hi and thank you for your great and helpful video. I would also ask you why after installing and try to start the server the lights come back to red after initialized the server?. thank you!!!
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi Armando, Are you able to login to your MySQL server? If not, most probably, the installation wasn't successful at your end. So, instead of 8.0.32, may be try old version. Let me know your macOS version so that I can assist you with choosing MySQL version.
@VanVinhNguyen-el8vh 9 ай бұрын
Thanks bro very handsome . from Vietnam :D
@PnTutorialsbyPradnyankurNikam 9 ай бұрын
You are welcome bro. Glad to know the video tutorials was helpful to you. Thanks for the feedback, I appreciate it.
@JK-up3pi Жыл бұрын
Hi, thank you very much for this video. Very helpful! I tried to download and install mysql workbench (version: 8.0.33) but kept having this error message "You can’t use this version of the application “MySQLWorkbench” with this version of macOS. You have macOS 12.6.5. The application requires macOS 13.0 or later." Do you have any suggestions to resolve this error? Thank you!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Hi JK, 1) Go to following URL, downloads.mysql.com/archives/community/ 2) On product archives page, from Product Version drop-down, select 8.0.30, 3) Then for Operating System drop-down select macOS 3) And for OS Version select either ARM (If your computer has arm processor) or X86 (for intel processor) 4) You will get a list of files. Download the DMG Archive file with large file size. Once download is complete, start the installation, and follow instructions given in this video tutorial. Let me know if it works. Regards, Pradnyankur
@JK-up3pi Жыл бұрын
It worked! Thank you very much!
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Great, glad to know the solution worked for you 👍
@anuragshakya8397 Жыл бұрын
Hi! Thanks for the video. They have been really helpful. Just wanted to know that is there a way to use MySQL Workbench with the MariaDB server of Xampp on Mac? In windows its very easy by just stopping the MySQL80 server in services and turning on Xampp server but in Mac I am unable to fetch tables with Maria DB on.
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Hi Anurag, Thanks for the positive feedback, I appreciate it. Can you provide more information like which macOS version yo are using, also MySQL workbench and Xampp version. So that I can test it at my end. Regards, Pradnyankur
@anuragshakya8397 Жыл бұрын
@@PnTutorialsbyPradnyankurNikam Thanks for replying. MacOS:- Big Sur 11.7.4 MySQL:- 8.0.31 XAMPP:- 8.2.0-0 Using MariaDB with MySQL WB actually helps in executing many queries which are showing syntax errors in MySQL server.
@anuragshakya8397 Жыл бұрын
@@PnTutorialsbyPradnyankurNikam To use MariaDB I stop MySQL server from System Preferences and it gets stopped. Then from XAMPP manager I start the XAMPP server and it gets started but with this MySQL server also gets started again automatically and it is impossible to stop it unless I stop XAMPP SERVER. Just try on your system you will get what I am saying.
@davidmungai3910 8 ай бұрын
Hello Nikam, Not sure how I'm getting the versions from Mac OS 13 and not Monterey,kindly assist.
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
Hi David, Sorry for the late response. I've been this week. If you are using macOS 12 Monterey, go to following MySQL Product Archives link, downloads.mysql.com/archives/community/ For Product version select 8.0.30 and for Operating System select macOS. And in the list you'll get MySQL installer DMG file for macOS 12. Let me know if that helps. Regards, Pradnyankur
@masonmartin1464 9 ай бұрын
can you do workbench as well
@PnTutorialsbyPradnyankurNikam 9 ай бұрын
Hi Mason, Sure I'll add MySQL workbench too. Thanks for the suggestion.
@user-gi6en4gf7s 8 ай бұрын
how can i access the mysql workbench?? I did everything you showed here
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
Hi Sushmita, You'll have to download MySQL workbench separately. Go to following link, downloads.mysql.com/archives/workbench/ For Product Version, select 8.0.32 And for Operating System, select macOS. And you'll get DMG installer. Run the installer and it's pretty straightforward. Once you install MySQL workbench, you'll have to use root or other user credentials to access your MySQL database. Let me know if it helps. Regards, Pradnyankur
@fero___3005 11 ай бұрын
hi sir in windows people get an individual application of named mysql they work in that but here you showed in terminal ...?? how to install an application for mysql in Mac sir
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi Fero, I think you are talking about MySQL gui (graphical user interface) application named "MySQL Workbench". You can download it from the following link, dev.mysql.com/downloads/workbench/ Select the OS version you are using and download the .dmg installer for you macOS. The installation steps are pretty straightforward. Let me know if it helps. Regards, Pradnyankur
@fero___3005 11 ай бұрын
@@PnTutorialsbyPradnyankurNikam i have installed it but it shows a round no signal for installing in my Mac what to do sir ?...In this video atlast you did some settings in terminal but it didn't is that the reason why I can't install workbench??
@user-nl4id5ce5y 11 ай бұрын
Thank you for this detailed video. I have a quick question. I was able to install MySQl however the server will not start. The active instance remains red regardless of my attempts to start the program. I have verified that I should be using x86. I have tried uninstalling and reinstalling, tried different versions including the 8.0 and the 8.1, and have also tried restarting my macbook Do you have any suggestions on how i can fix this problem?
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi Frances, If you are using macOS 12 then I would recommend you to try MySQL 8.0.30 Here are the steps you should follow. 1) First of all completely uninstall & remove MySQL from you computer. Follow the uninstall steps given in my another tutorial. kzfaq.info/get/bejne/j5ljqMuYzZvJf5c.html 2) Go to following URL, downloads.mysql.com/archives/community/ 3) On product archives page, from Product Version drop-down, select 8.0.30, 4) Then for Operating System drop-down select macOS 5) And for OS Version select either ARM (If your computer has arm processor) or X86 (for intel processor) 6) You will get a list of files. Download the DMG Archive file with large file size. Once download is complete, start the installation, and follow instructions given in this video tutorial. Let me know if it works. Regards, Pradnyankur
@user-nl4id5ce5y 11 ай бұрын
@@PnTutorialsbyPradnyankurNikam Hi, Thank you! I followed all the steps except the terminal because I have never used a terminal and not familiar with how to get one. However, it was still not successful with my attempt. Is there another way it can be done?
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
All the steps are pretty straightforward. For terminal, I already have given the commands and executed while recording, so it won't cause any issue. The thing is you must completely uninstall & delete all previous failed/unsuccessful installation files. If you don't do that, you might keep getting the same issue. Another way is, you'll have to install MAMP (Mac Apache MySQL PHP) stack. It's a local development server. You can search for Bitnani MAMP and give it a try. It includes MySQL. You can explore Bitnami docs how to access & use MySQL after installing their software stack.
@rodrigoguerradelacruz3330 4 ай бұрын
Hi, How can I install a Workbench all version supported by MacOS 12. Workbench 8.0 is supported just by MacOS 13 or onwards. Thank you
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
Hi Rodrigo, Go to following link, downloads.mysql.com/archives/workbench/ for product version select: 8.0.25 Operating System: macOS And download the MySQL workbench. The installation is pretty straightforward.
@rodrigoguerradelacruz3330 4 ай бұрын
@@PnTutorialsbyPradnyankurNikam Thank you. That worked!
@andrewcortez1588 6 ай бұрын
When I try to enter the password in the terminal after download mySQL would you know why it would say "ERROR 1045 (28000): Access denied for user 'root@localhost' (using password: YES)"?
@PnTutorialsbyPradnyankurNikam 6 ай бұрын
Hi Andrew, The ERROR 1045 is due to incorrect password. 1) Make sure you are using correct password. 2) Let me know the command you are using so that I can help you fix the issue.
@murzagaliyev 2 ай бұрын
what about mysql workbench?
@PnTutorialsbyPradnyankurNikam 2 ай бұрын
Hi Alikhan, You can download MySQL workbench separately from following link dev.mysql.com/downloads/workbench/
@user-lx9nx9wj8g Жыл бұрын
I tried according to your guidance, but in installation wizard configuration step skip, even I press Go Back button :( So in terminal there is no password that I can enter.
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Sorry for the late response, I was busy this weekend. First of all completely remove/uninstall unsuccessful installation. Checkout my another video tutorial where I've given step by step instructions to uninstall MySQL and delete database files from macOS. Here is the link, kzfaq.info/get/bejne/j5ljqMuYzZvJf5c.html Once it's done, you can start a fest installation and follow the step given in this installation video. Let me know if it works.
@user-lx9nx9wj8g Жыл бұрын
@@PnTutorialsbyPradnyankurNikam Thank you for your answer. yes I removed it and reinstalled. now it works :)
@PnTutorialsbyPradnyankurNikam Жыл бұрын
Great. Glad to know it worked 😊👍
@user-dy9gk5kt8e 11 ай бұрын
How can i put world database, i had but now not
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
Hi, I didn't get your question. Do you mean you had backup file for your "world" database and you want to import it in your new database? Let me know more detail so that I can understand your question better and help you resolve your issue.
@user-dy9gk5kt8e 11 ай бұрын
@@PnTutorialsbyPradnyankurNikam sir there is a database name world and sakila that come pre installed in windows but not in mac,
@PnTutorialsbyPradnyankurNikam 11 ай бұрын
1) You can download sample world and sakila databases from the following link, dev.mysql.com/doc/index-other.html 2) Once you download, extract the zip file, and you'll get .sql files. 3) Now, in your terminal window, enter following command, mysql -u root -p dbName < fullPathToDB.sql Note: Replace "dbName" and "fullPathToDB.sql" with actual database name and actual path to database .sql files. Let me know if it helps.
@user-dy9gk5kt8e 11 ай бұрын
@@PnTutorialsbyPradnyankurNikam Alright
@boddanaramana6641 4 ай бұрын
Sir in this workbench also installed or not
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
Hi Boddana, You can download MySQL workbench separately from this link: dev.mysql.com/downloads/workbench/
@boddanaramana6641 4 ай бұрын
@@PnTutorialsbyPradnyankurNikam can you send the video link how download and how to use
@PnTutorialsbyPradnyankurNikam 4 ай бұрын
Boddana, Currently I don't have MySQL workbench installation video tutorial. But the installation is pretty straightforward. Give it a try and let me know if you encounter any issue.
@Khdavidz 8 ай бұрын
hello when i try to check server is completely installed just like you did it is giving me this error can you tell me what is it (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) )
@PnTutorialsbyPradnyankurNikam 8 ай бұрын
Hi David, Most probably, The installed MySQL version isn't supporting your system. I would recommend you to install a different MySQL version. May be go with MySQL 8.0.30 version. If you are using macOS 12 Monterey, go to following MySQL Product Archives link, downloads.mysql.com/archives/community/ For Product version select 8.0.30 and for Operating System select macOS. And in the list you'll get MySQL installer DMG file for macOS 12. If you are not sure, let me know your macOS version and I'll suggest you the correct MySQL version. Before you install the new version, make sure you uninstall the previous installation following the steps given in the uninstall tutorial here, kzfaq.info/get/bejne/j5ljqMuYzZvJf5c.html Regards, Pradnyankur
@CharanSaiAnnam 7 ай бұрын
You are the best 🫡
@PnTutorialsbyPradnyankurNikam 7 ай бұрын
Thanks CharanSai 😊🙏
PnTutorials by Pradnyankur Nikam
Рет қаралды 46 М.
Nikita Zdradovskiy
Рет қаралды 6 МЛН
EmbarkX | Learn Programming
Рет қаралды 29 М.
Alisha Maini
Рет қаралды 23 М.
WION
Рет қаралды 12 М.
Kindson The Tech Pro
Рет қаралды 236 М.