Install MySQL 8.0.32 on MacOS 12 Monterey [Step-by-Step Tutorial]

[@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 KZbin. Thanks for the subscription 🙏

[@jerusalemt2343]

Organized and easy to follow. Thank you!!

[@PnTutorialsbyPradnyankurNikam]

You are so welcome Jerusalem. Glad to know you liked the tutorial.

[@swethasomanchi4315]

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]

Thanks you Swetha for the feedback, Glad to know the tutorial was helpful to you.

[@pradyutdasgupta1350]

The best video on MYSQL installation. I literally mean, the best.!! Thank you.!!

[@PnTutorialsbyPradnyankurNikam]

Thank you Pradyut for the positive feedback, Glad to know the tutorial was helpful to you 😊🙏

[@aniekanudofia-p3q]

Straight forward and easy to understand. Highly recommended

[@PnTutorialsbyPradnyankurNikam]

Thank you Aniekan for the positive feedback, I appreciate it. 😊🙏

[@aneesharaj789]

Thankyou so much sir . easy to understand , it took 2 hrs to find but by watching this video it makes so simple

[@PnTutorialsbyPradnyankurNikam]

You are welcome Aneesha. Glad to know the video tutorial was helpful to you. 😊🙏

[@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 👍

[@ashita-3280]

Thaks fro sharing right knowledge❤. I have tried 3day.Now i finally get it thanks.🎉 Supporting with you.

[@PnTutorialsbyPradnyankurNikam]

Thanks Ashita for the positive feedback, I appreciate it 😊🙏

[@kalpeshbhoir207]

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]

Thank you Kalpesh for the positive feedback. Glad to know the video tutorial was helpful to you. 😊🙏

[@armandogutierrez2880]

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]

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

[@PawanKumar-di2uk]

Extremely helpful video and so easy to follow. Thank you

[@PnTutorialsbyPradnyankurNikam]

You are welcome Pawan Kumar 😊🙏

[@yt-1161]

great explanation mate

[@PnTutorialsbyPradnyankurNikam]

Thank you brother 😊🙏

[@masonmartin1464]

can you do workbench as well

[@PnTutorialsbyPradnyankurNikam]

Hi Mason, Sure I'll add MySQL workbench too. Thanks for the suggestion.

[@belninzo]

Thank you so much! So easy to follow !

[@PnTutorialsbyPradnyankurNikam]

You are so welcome belninzo, Glad to know the video tutorial was helpful to you. 😊🙏

[@mayk8024]

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]

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]

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]

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.

[@YonelaLavisa-z5z]

Perfect! It worked well

[@PnTutorialsbyPradnyankurNikam]

Glad it helped!

[@riz4583]

Thank you brother, i love you

[@PnTutorialsbyPradnyankurNikam]

You're welcome Brother 😊🙏

[@nawwintphyu1873]

Thank you so much for sharing!

[@PnTutorialsbyPradnyankurNikam]

You are so welcome! 😊🙏

[@johnflanagan6367]

Very helpful video! Thank you for posting!

[@PnTutorialsbyPradnyankurNikam]

You're very welcome John 😊🙏

[@sushmitaSwain-g6y]

how can i access the mysql workbench?? I did everything you showed here

[@PnTutorialsbyPradnyankurNikam]

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

[@mantashasheikhh]

terminal ko wapus open krne pr ..mysql-u root -p karne par command not found bat ra h...plzzz btaiye

[@PnTutorialsbyPradnyankurNikam]

Hi Mmantasha, Enter full path like, /usr/local/mysql/bin/mysql -u root -p Let me know if it works.

[@Sarah_Bee21]

Super helpful!! Thanks!!!

[@PnTutorialsbyPradnyankurNikam]

You are welcome Sarah

[@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.

[@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

[@pahoolk]

clearly as water, thanks a lot sir!

[@PnTutorialsbyPradnyankurNikam]

Thank you Paco for the positive feedback, I appreciate it 😊🙏

[@SireeshaYarlagadda-qy8li]

Thank you so much sir, I will learn your udemy course

[@PnTutorialsbyPradnyankurNikam]

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

[@vinaf4494]

Thank you, it's really helpful!!

[@PnTutorialsbyPradnyankurNikam]

You're welcome Vina! 😊🙏

[@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.

[@WEAAM123451]

Thank you very much, It's very helpful

[@PnTutorialsbyPradnyankurNikam]

You are welcome, Weam 😊🙏

[@wanderatimothy5595]

Thank you So much sir

[@PnTutorialsbyPradnyankurNikam]

You're welcome Wandera 😊🙏

[@YonelaLavisa-z5z]

Thanks, when I doing sudo nano/etc/paths... after typing password it says ''Sorry, try again"

[@PnTutorialsbyPradnyankurNikam]

The first time you enter sudo, make sure you enter your computer admin user password. Then on the next password prompt, enter MySQL root user password.

[@soumyaranjansamalkiit]

LEGEND! 👑

[@PnTutorialsbyPradnyankurNikam]

Thank you soumyaranjan for the positive feedback, I appreciate it.

[@fero___3005]

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]

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]

@@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??

[@taggincrewz8855]

Thank You, editing bashfile was not working for me, this trick worked.

[@PnTutorialsbyPradnyankurNikam]

Hi Taggin Crewz, Great! Glad to know the step in this video worked for you. 😊🙏

[@murzagaliyev]

what about mysql workbench?

[@PnTutorialsbyPradnyankurNikam]

Hi Alikhan, You can download MySQL workbench separately from following link dev.mysql.com/downloads/workbench/

[@cynthiaangula3745]

Hi, Im trying to connect SQL workbench however it won't load I keep receiving a pop message the says "You can’t use this version of the application “MySQLWorkbench” with this version of macOS." , "You have macOS 12.7.6. The application requires macOS 13.0 or later." I am using macOS Monterey Version 12.7.6 Can anyone assist please as I am currently on a data tech course and will need the software.

[@PnTutorialsbyPradnyankurNikam]

Hi Cynthia, 1) First of all uninstall currently installed MySQL workbench from you computer. 2) Go to following link, downloads.mysql.com/archives/workbench/ Select, Product Version: 8.0.30 and Operating System: macOS And download the DMG archive file. 3) Install MySQL workbench 8.0.30 on your macOS computer. And connect with your MySQL server. Let me know if it works. Regards, Pradnyankur

[@niha1158]

only macos 14 is there when i select the version

[@PnTutorialsbyPradnyankurNikam]

Hi Niharika, Go for the previous release. If you can't figure out, let me know your operating system version. And I'll provide you the link to download MySQL version that will support your macOS version.

[@davidmungai3910]

Hello Nikam, Not sure how I'm getting the versions from Mac OS 13 and not Monterey,kindly assist.

[@PnTutorialsbyPradnyankurNikam]

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

[@chinedusolomonnsude4394]

thank you man

[@PnTutorialsbyPradnyankurNikam]

You're welcome!

[@김준현-h4g]

the god the king .. thx

[@PnTutorialsbyPradnyankurNikam]

Thank you 김준현 😊🙏

[@adronhomesofficial]

thanks for the video

[@PnTutorialsbyPradnyankurNikam]

You're welcome 😊🙏

[@Navneetkumar-jq3tz]

Thank you great help

[@PnTutorialsbyPradnyankurNikam]

You are welcome Navneet 😊🙏

[@CENIVIVRIMedellín]

thank you.... i can do it

[@PnTutorialsbyPradnyankurNikam]

All the best 😊🙏

[@boddanaramana6641]

Sir in this workbench also installed or not

[@PnTutorialsbyPradnyankurNikam]

Hi Boddana, You can download MySQL workbench separately from this link: dev.mysql.com/downloads/workbench/

[@boddanaramana6641]

@@PnTutorialsbyPradnyankurNikam can you send the video link how download and how to use

[@PnTutorialsbyPradnyankurNikam]

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.

[@為位キ]

How can i put world database, i had but now not

[@PnTutorialsbyPradnyankurNikam]

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.

[@為位キ]

@@PnTutorialsbyPradnyankurNikam sir there is a database name world and sakila that come pre installed in windows but not in mac,

[@PnTutorialsbyPradnyankurNikam]

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.

[@為位キ]

@@PnTutorialsbyPradnyankurNikam Alright

[@ADITYACHAUDHARY-fp4ys]

thank you so much

[@PnTutorialsbyPradnyankurNikam]

You're welcome! 😊🙏

[@ViryQueen28]

Thank u so much for the video. New Suscribe!

[@PnTutorialsbyPradnyankurNikam]

Thank you Viry for the feedback and subscribing to my channel 😊🙏

[@FrancesAjaero]

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]

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. kzbin.info/www/bejne/j2SWppudnZqYhcU 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

[@FrancesAjaero]

@@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]

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]

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]

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]

@@PnTutorialsbyPradnyankurNikam Thank you. That worked!

[@devefrom]

THANKS

[@PnTutorialsbyPradnyankurNikam]

You are welcome Deve 😊🙏

[@andrewcortez1588]

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]

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.

[@HamidehKhajehezadeh]

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, kzbin.info/www/bejne/j2SWppudnZqYhcU 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.

[@HamidehKhajehezadeh]

@@PnTutorialsbyPradnyankurNikam Thank you for your answer. yes I removed it and reinstalled. now it works :)

[@PnTutorialsbyPradnyankurNikam]

Great. Glad to know it worked 😊👍

[@VanVinhNguyen-el8vh]

Thanks bro very handsome . from Vietnam :D

[@PnTutorialsbyPradnyankurNikam]

You are welcome bro. Glad to know the video tutorials was helpful to you. Thanks for the feedback, I appreciate it.

[@SashaBelovw]

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]

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, kzbin.info/www/bejne/j2SWppudnZqYhcU Regards, Pradnyankur

[@CharanSaiAnnam]

You are the best 🫡

[@PnTutorialsbyPradnyankurNikam]

Thanks CharanSai 😊🙏

[@ammiesobola9931]

Super helpful. thank you

[@PnTutorialsbyPradnyankurNikam]

You're welcome Ammie 😊🙏

[@mayankchauhan6197]

thank you very much.

[@PnTutorialsbyPradnyankurNikam]

You are welcome Mayank 😊🙏