OH MY GOD!!! YOU ARE A SAVIOUR!!! Out of severalllll like honestly several videos that lead me nowhere, this was the most useful video that helped me reset my MySQL root password!! IT WORKED!!! I'm super excited because the struggle is REAL!!
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thank you Shiva for the positive feedback. Glad to know the video tutorial was helpful to you. 😊🙏
@mtbmtbmtbcycle8797
Ай бұрын
one more thing ** if you have installed mysql via terminal like conda or brew.... and forget about it , first doo remove that before resetting pass for server gui version (dmg installed one).
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thank you for your contribution, I appreciate it.
@edrod8807
2 ай бұрын
Thank you man! You're the boss! I had a few school projects I wanted to get back to and could not remember my password for the life of me.
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Thank you Ed Rod for the feedback. Glad to know the video tutorial was helpful to you. If you haven't subscribe the channel, I would add more content soon. Also, check out my SQL course on Udemy If you are interested in learning SQL with MySQL database. Thanks again 😊🙏
@atombarako
Жыл бұрын
Thank you very much for the step-by-step instructions. I spent quite some time searching online and could not make it work until I found your video!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Glad to know the tutorial was helpful to you. Thank you for the positive feedback I appreciate it 😊🙏
@monkey.d.gojira
7 ай бұрын
Thank you this was very helpful! People ensure to check if conda is deactivate in both terminals if you are facing issues.
@PnTutorialsbyPradnyankurNikam
7 ай бұрын
Thank you brother for the positive feedback and your inputs.
@adyasamishra3392
Ай бұрын
Amazing tutorial sir. It worked.
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thanks Adyasa for the positive feedback. Glad to know the tutorial worked for you.
@munirh44
Жыл бұрын
Easy to follow just what I was looking for. Thank you
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You're welcome! 😊🙏
@udaykiranblogging
Ай бұрын
Thank you very much for this bro, it really helped me to connect to the server.
@PnTutorialsbyPradnyankurNikam
Ай бұрын
You are welcome Uday, Glad to know the tutorial was helpful to you. Thanks for the feedback 😊🙏
@oxide_digno0657
10 ай бұрын
After mysql -u root -p ask for my root password and that’s what I don’t remember and i tried one says error 1045 ( 28000) pla sir help me
@PnTutorialsbyPradnyankurNikam
10 ай бұрын
You can reset the password. I already have given the steps in this video.
@pruebaerror6977
8 ай бұрын
thanks so much, such a simple and easy to follow video
@PnTutorialsbyPradnyankurNikam
8 ай бұрын
You are welcome. Glad to know the tutorial was helpful! 😊🙏
@miguelaquilesplazarosillon7731
5 ай бұрын
Thanks a lot! It really helped me recovering the root password
@PnTutorialsbyPradnyankurNikam
5 ай бұрын
Glad to hear that Miguel 😊🙏
@bearinny3961
Жыл бұрын
Whenever Im in the step of " sudo mysqld_safe ... --skip-networking ", I always get " sudo: mysqld: command not found " . What should I do in this case? I was keep trying to find a way for sudo command to work, but it didn't work
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Bear, Confirm if you have MySQL installed on your macOS, and the installation folder path. 1) Go to, System Preferences -> MySQL window If MySQL isn't installed, you'll not find MySQL configuration window under system preferences. 2) If you find, MySQL configuration window, Open the window and go to "configuration" tab. 3) You will find a base directory path (MySQL installation path). like, /usr/local/mysql/bin OR /usr/bin/mysql 4) In your terminal window change the directory to your MySQL installation "bin" folder path and the execute above statements. Let me know if it works.
@onepercentdaily
Ай бұрын
thanks so much. savior
@PnTutorialsbyPradnyankurNikam
Ай бұрын
You are welcome Daniel 😊🙏
@442trash
Ай бұрын
THANK YOU SO MUCH
@PnTutorialsbyPradnyankurNikam
Ай бұрын
You are welcome Jank 😊🙏
@arpitasarang2870
Ай бұрын
ekdam mast bataya h
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thank you very much for the feedback, glad to know the video was helpful to you 😊🙏
@AliHasan-q9o
Ай бұрын
Hi sir for me its showing access denied to the bin folder. Can you help ?
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Hi Ali, Make sure you are logged in to your computer using root user account.
@abdulraqibabdulmajeed462
Жыл бұрын
Hello , my sql server keeps blinking red and green on my Mac , I uninstalled it and reinstalled.. but nothing . I also tried installing it using brew on my terminal but got too many errors , please I need help
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Abdulraqib, Can you provide your MacOS Big Sur version number so that I can help you choose the correct installer.
@gabrielasandoval9133
2 ай бұрын
@@PnTutorialsbyPradnyankurNikam It happens to me too :(
@jonluis2647
Ай бұрын
legend, thank you
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thank you very much for the positive feedback Jon 😊🙏
@sumihassan6
6 ай бұрын
Thank you so much, that was super helpful.
@PnTutorialsbyPradnyankurNikam
6 ай бұрын
Thank you Sumaya, Glad it was helpful! 😊🙏
@sweealamak628
2 жыл бұрын
Thank you sir. I hope never to do this but at least I now know it can be done.
@PnTutorialsbyPradnyankurNikam
2 жыл бұрын
Yes! You can reset MySQL root user password. If in future you forget your root user account password. This video would be helpful. Thanks for the comment. 😊🙏
@raushansingh5358
Жыл бұрын
Well explained! Thank you!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Thank you Raushan, for the positive feedback 😊🙏
@anakmit5494
4 ай бұрын
You saved my time! thank you brother
@PnTutorialsbyPradnyankurNikam
4 ай бұрын
You are welcome AnakMit bro 😊🙏
@Miki-fr8bu
3 ай бұрын
i have a problem that when i start mysql server from the settings, its just remain 2-3 seconds and stoped alone, it keep starting and stoping, how can i solve this sir?
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Hi Mik, I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnynkur
@bhuvanbopanna4564
3 ай бұрын
I have the same problem
@Miki-fr8bu
3 ай бұрын
@@PnTutorialsbyPradnyankurNikam latest version, mysql latest version as well for mac, don’t have a previous installation. However, i found a solution that worked out, simply run this command in terminal: sudo /usr/local/mysql/support-files/mysql.server start I think turn it on it from settings does not really start it. Thanks 🙏🏽
@ahmedhashmi3258
Жыл бұрын
for me, it says that mysql not found under the directory you've mentioned "/usr/local/mysql/bin" How do I reset the password then?
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Ahmed, Open MySQL server instances window as shown in video. Go to "Configuration" tab. There you'll find MySQL installation directory. Once you find your MySQL installation location, you can change the directory to "bin" folder. And remaining steps would be same as given in the tutorial. Let me know if it works. Regards, Pradnyankur
@oxide_digno0657
10 ай бұрын
Can you explain me that it says command not found @@PnTutorialsbyPradnyankurNikam
@kishanpatel7334
3 ай бұрын
Hi Pradnyankur. Whenever I am trying to run the mysql server it's automatically stop's running server will you please help me out for this?
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Hi Kishan, Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur
@kishanpatel7334
3 ай бұрын
Yes Thanks a lot brother Currently I am working on Mac 14 sonoma
@kishanpatel7334
3 ай бұрын
MySQL version - 8.4.0 LTS Mac M1 MacBook Pro 2021 version - Mac 14 sonoma I already installed before at that same problem happened. MySQL server not running at all. Thanks a lot and appreciate.
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Alright, if it's a fresh installation and you don't have any data. You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8 Follow my previous video tutorial to completely remove MySQL from your computer. kzitem.info/news/bejne/umlp25ydoWeWgpg Step 2: Install MySQL 8 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. kzitem.info/news/bejne/kmd4noOoomtypXY Let me know if it works. Regards, Pradnynkur
@kishanpatel7334
3 ай бұрын
I just wanted to ask you so what’s the actual reason why lastest version is not working in Mac right now?
@TasnuvaNusratTahsin
Ай бұрын
thanks saved my life
@PnTutorialsbyPradnyankurNikam
Ай бұрын
You are welcome Tasnuva 😊🙏
@kylekim2847
Ай бұрын
Thank you
@PnTutorialsbyPradnyankurNikam
Ай бұрын
You are welcome Kyle 😊🙏
@ashmitgupta5303
Ай бұрын
Thanks!
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Thank you Ashmit for the "Super Thanks". Glad to know the video tutorials was helpful to you. 😊🙏
@abhijith4842
6 ай бұрын
for me is it showing sudo: mysqld_safe: command not found when i type sudo mysqld_safe --skip-grand-tables --skip-networking so pls help me out
@PnTutorialsbyPradnyankurNikam
6 ай бұрын
Hi Abhijith, First of all you'll have to change the directory to MySQL bin folder using, cd /usr/local/mysql/bin Then execute mysqld_safe command. Let me know if it works. Regards, Pradnyankur
@t6652
Жыл бұрын
Thanks Sir!, It helped me a lot.
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Glad to hear that the tutorial was helpful to you. 🙏😊
@snehasgowda8726
4 ай бұрын
HI I AM gettingn error that mysqld_safe command not found
@PnTutorialsbyPradnyankurNikam
4 ай бұрын
Hi Sneha, First of all you'll have to change the directory to MySQL bin folder using, cd /usr/local/mysql/bin Then execute mysqld_safe command. Let me know if it works. Regards, Pradnyankur
@shaailjaa
28 күн бұрын
very good
@PnTutorialsbyPradnyankurNikam
28 күн бұрын
Thanks Shailja 😊🙏
@kalyan-k
9 ай бұрын
Thanks a lot for your efforts.
@PnTutorialsbyPradnyankurNikam
9 ай бұрын
It's my pleasure Kalyan 😊🙏
@BernicePezuzu
Жыл бұрын
Thank you for making this video 🙏🏾🙏🏾🙏🏾🙏🏾
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You're welcome Bernice 😊🙏
@howtostepbystep3756
4 ай бұрын
Thank so much for this video...
@PnTutorialsbyPradnyankurNikam
4 ай бұрын
You are most welcome 😊🙏
@zhenbinchong6186
Ай бұрын
hi, I follow your step to turn on skip networking, and now my root veriables skip-networking value is ON, and my port value become 0. incase now i need to use port 3306, how do I fix it?
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Hi zhenbin, I didn't get your question. Can you provide commands that you used to reset the password? Were you able to reset the root user password? Provide more details so that I can understand your question and help you fix the issue.
@zhenbinchong6186
Ай бұрын
@@PnTutorialsbyPradnyankurNikam HI, I already fix out the problem by download the older version MYSQL. I guess is because the new version MYSQL still unstable for now.
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Glad to know you were able to fix the issue.
@yogeshishere
7 ай бұрын
For changing root user password- it says ‘mysqld_safe’ command not found
@PnTutorialsbyPradnyankurNikam
7 ай бұрын
Hi Yogesh, First of all you need to change the directory to MySQL bin folder using, cd /usr/local/mysql/bin then execute mysqld_safe command. Let me know if it works. Regards, Pradnyankur
@yogeshishere
7 ай бұрын
@@PnTutorialsbyPradnyankurNikam worked … thank you so much
@VLPN_world
5 ай бұрын
Thank you so much 👍
@PnTutorialsbyPradnyankurNikam
5 ай бұрын
You are welcome
@ItzHussuni
Жыл бұрын
Thank you so much!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You are welcome Hussain 😊🙏
@B4BUNNYop
3 ай бұрын
my sql server getting close immediately when i started the server from setting, what to do ?
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Hi b4bunny, Sorry for the late response. Due to weekend I was busy offline. Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur
@B4BUNNYop
3 ай бұрын
@@PnTutorialsbyPradnyankurNikam I'm using the M3 14.5 version at the moment. When I first installed 8.4 MySQL, I was receiving this problem (ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)) But for now, I've only installed the previous version, so everything is OK. I appreciate your response.
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Good to know that you were able to fix the issue on your own. Please note: sometimes the latest MySQL installer doesn't support all system configuration. In that case, it's best practice to go with previous stable release. If you need any other help feel free to ask me. I would be my best to help you ASAP.
@oxide_digno0657
10 ай бұрын
Sir after identified by ( new password )’; enter it doesn’t apper the Query OK plss help me
@oxide_digno0657
10 ай бұрын
‘> that is the only thing that appears when i press enter
@PnTutorialsbyPradnyankurNikam
10 ай бұрын
Hi Can you enter you full SQL statement here, so that I can review and help you fix the issue.
@ayushsharma9158
3 ай бұрын
My sql server gets active for just 2-3 seconds and then it gets stopped…What should I do now sir?
@B4BUNNYop
3 ай бұрын
same to me 🥲
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
Hi Ayush and b4bunny, Sorry for the late response. Due to weekend I was busy offline. Definitely I can help you fix your issue. Can you provide more information like, 1) Which macOS version you are using? 2) Which MySQL version you installed? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur
@stephaniehunter7691
Жыл бұрын
I seemed to have messed everything up with this! My server on mysql server is just off and I can't even open the mysql system preferences, it says: 'You can’t open MySQL preferences pane because it doesn’t work on an Intel-based Mac'. Help!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Stephanie, If you do not have any data in your current MySQL installation. Then try to uninstall existing MySQL database server completely. And try a different version on your MacOS. Checkout my following video tutorials where I've explained how to completely remove MySQL server from MacOS. kzitem.info/news/bejne/sXh31IuOhHuhpm0
@stephaniehunter7691
Жыл бұрын
@@PnTutorialsbyPradnyankurNikam thank you, this worked!
@rutvikprajapati3281
15 күн бұрын
Great 🎉
@PnTutorialsbyPradnyankurNikam
14 күн бұрын
Thank you Rutvik 😊🙏
@anishkulshreshtha4780
2 ай бұрын
i forget root user password in mac - can I restore or reset it ?
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi Anish, yes you can reset MySQL root user password by following the steps given in the videos.
@ackmadelfanpurnama6580
3 ай бұрын
sangat membantu bangettttt😘😘
@PnTutorialsbyPradnyankurNikam
3 ай бұрын
You are welcome 😊🙏
@itsvikas-ei8hn
Жыл бұрын
Sir please make a tutorial on the postgresql
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Thank you Vikas for your valuable suggestion. Sure I’ll add postgreSQL tutorials soon.
@itsvikas-ei8hn
Жыл бұрын
@@PnTutorialsbyPradnyankurNikam sir please make a special video on database errors which is face special in the macOS operating system of the PostgreSQL database type of error is that of Postgresql which isn't available on the internet pg_restore: [tar archiver] could not find header for file "toc.dat" in tar archive :- [PostgreSQL-11] pg admin 4.
@itsvikas-ei8hn
Жыл бұрын
sir if possible make a tutorial special database error may lot of help for The students please make this when we have a limit of time this type of error makes a scene to much wst time
@keyur-vamja-it
Жыл бұрын
Thankful.
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You are welcome Keyur 😊🙏
@KishoreKumar-fp6hn
2 ай бұрын
Thanks very much for the video. However, after successful resetting root password, I am still getting error message while loggin with new password. "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" Kindly help me resolving this issue. Thank you.
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi Kishore, 1) Which macOS version are you using? 2) Which MySQL version did you install? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur
@KishoreKumar-fp6hn
2 ай бұрын
@@PnTutorialsbyPradnyankurNikam Hi Pradnyankur, Thanks for your reply I have added my replies to your questions .. 1) Which macOS version are you using? MACOS Sonoma Version 14.5 2) Which MySQL version did you install? MySQL Community Server 8.4.0 LTS [ macOS 14 (ARM, 64 bit) ] 3) Do you have any previous data in your MySQL database or it's a fresh installation? Yes, but not important Let me know if anything needed. Regards, Kishore
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi Kishore, In order to fix the issue, you'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. kzitem.info/news/bejne/umlp25ydoWeWgpg Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. kzitem.info/news/bejne/kmd4noOoomtypXY Let me know if it works. Regards, Pradnynkur
@KishoreKumar-fp6hn
2 ай бұрын
Hi Pradnyankur, Thanks for sharing details. In the first step which you have mentioned to uninstall MySQL part .. I could successfully uninstall MySQL from system preferences. And in the terminal, when I enter this code (sudo rm -rf /usr/local/mysql) it is asking for root password. On loging in with root password it says "Sorry, try again". This is where I am unable to login (though I am using my correct root password). Kindly help. Regards, Kishore
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Kishore, on the password prompt you are supposed to enter your computer root user password (not MySQL root user password). You can also use the remove command without sudo, like rm -rf /usr/local/mysql
@aminnizami3661
2 жыл бұрын
Can you please guide us on how we can install SSMS on MAC? Thank you.
@PnTutorialsbyPradnyankurNikam
2 жыл бұрын
Hi Amin, Currently I don't have SSMS tutorials. I'll consider it adding in future.
@aminnizami3661
2 жыл бұрын
@@PnTutorialsbyPradnyankurNikam Thank you so much for this consideration.
@RickyLloren
Жыл бұрын
THANKS MAN!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You are welcome Ricky 😊🙏
@ushaprudhvi6121
Жыл бұрын
Thank You!!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You're welcome! Usha 😊🙏
@lucastrava1747
Жыл бұрын
zsh: command not found: mysql
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Lucas, I've given the solution to fix the error in my another video tutorial at given timeline. Check it out here kzitem.info/news/bejne/pHiqqI6dpoJjZYI
@kongpopkeattireangwattana6113
Ай бұрын
I use mysql -u root but error 2002(HY000)
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Hi, If you recently installed MySQL 8 on your computer and getting ERROR 2002 (HY000) error while logging in, then you should uninstall MySQL 8 (If you don't have any important data). You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. kzitem.info/news/bejne/umlp25ydoWeWgpg Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. kzitem.info/news/bejne/kmd4noOoomtypXY Let me know if it works. Regards, Pradnynkur
@jennyzhang7332
Жыл бұрын
THANK YOU!!!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You are welcome Jenny 😊🙏
@Ibrahimmairo
Жыл бұрын
thank you!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You're welcome Mario 😊🙏
@ghy518
Жыл бұрын
Thank you, handsome bro
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Thank you Bobby ☺️ This was first one. I mean, nobody called me handsome before 😆
@Finding-NEMO-14
4 ай бұрын
amazing. Thank you
@PnTutorialsbyPradnyankurNikam
4 ай бұрын
You are welcome 😊🙏
@karanmehndiratta6614
Жыл бұрын
super awesome!!!!!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Thank you Karan 😊🙏
@AppuAbhi
2 ай бұрын
My system "Active Instances" shows red. Please suggest
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi ABHILASH, 1) Which macOS version are you using? 2) Which MySQL version did you install? 3) Do you have any previous data in your MySQL database or it's a fresh installation? Let me know the details and I would help you fix your problem. Regards, Pradnyankur
@AppuAbhi
2 ай бұрын
@@PnTutorialsbyPradnyankurNikam It is not a fresh installation, i have tried multiple times but ended up with the error below: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi Abhilash, In order to fix the issue, you'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version or older version. Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. kzitem.info/news/bejne/umlp25ydoWeWgpg Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. kzitem.info/news/bejne/kmd4noOoomtypXY Let me know if it works. Regards, Pradnynkur
@AppuAbhi
Ай бұрын
@@PnTutorialsbyPradnyankurNikam thanks now installation done successfully but getting “Local instance 3306 - Warning - not supported”
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Which macOS version you are using?
@shantohossain1372
Жыл бұрын
tnx q lot
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
You are welcome Shanto 😊🙏
@tinu1503
8 ай бұрын
Thank you soooo soooo much
@PnTutorialsbyPradnyankurNikam
8 ай бұрын
You're welcome Tinu 😊🙏
@jeanlaguna6949
Жыл бұрын
love youuuuu!!!!
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Love you too Jean 😊🙏
@jolo8830
Ай бұрын
Hello i aml following the steps for Reset MySQL database root user account password. I opened a new terminal, enetered this: mysql -u root and got this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
@PnTutorialsbyPradnyankurNikam
Ай бұрын
Hi Jolo, If you recently installed MySQL 8 on your computer and getting ERROR 2002 (HY000) error while logging in, then you should uninstall MySQL 8 In order to fix the issue. You'll have to first uninstall your previous failed/unsuccessful installation and go with MySQL 8.3.0 version Step 1: Uninstall MySQL 8.4 Follow my previous video tutorial to completely remove MySQL from your computer. kzitem.info/news/bejne/umlp25ydoWeWgpg Step 2: Install MySQL 8.3 Go to following link, downloads.mysql.com/archives/community/ On MySQL download page select, Product Version: 8.3.0 Operating System: macOS OS Version: macOS 14 (ARM or x86 depending on your processor) Then download the MySQL 8.3.0 dmg installation file Now follow MySQL 8 installation steps given in the following video tutorial. kzitem.info/news/bejne/kmd4noOoomtypXY Let me know if it works. Regards, Pradnynkur
@l2ob1222
Жыл бұрын
after im in my /usr/local/mysql/bin when i try to type in mysql -u root -p it says command not found:MySQL any ideas?
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Rob, Confirm if your macOS have MySQL installed on it. 1) Go to, System Preferences -> MySQL window If MySQL isn't installed, you'll not find MySQL configuration window under system preferences. 2) If you find, MySQL configuration window, Open the window and go to "configuration" tab. 3) You will find a base directory path (MySQL installation path). like, /usr/local/mysql/bin OR /usr/bin/mysql Note down the path in your case, and change the directory to MySQL installation folder. Now, you can proceed resetting the MySQL password. 4) If you've installed MySQL using a package manager like MAMP, Then checkout their documentation for MySQL path. 5) If MySQL doesn't exists on your computer, then check out following link, where I've covered, MySQL installation on macOS. kzitem.info/news/bejne/pZqul2eBpYlprIY Let me know if it helps. Regards, Pradnyankur
@JeremyMoritz1
Жыл бұрын
when i run `sudo mysqld_safe --skip-grant-tables --skip-networking`... i get this error `mysqld_safe Logging to '/usr/local/var/mysql/my-computer-name.local.err'.` `mysqld_safe A mysqld process already exists`
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Jeremy, Are you sure you stopped MySQL instance from system preferences? Also, did you execute, "sudo pkill mysqld" before running "sudo mysqld_safe......"
@firasmohamed6250
Жыл бұрын
i got this error no such file or directory: cd/usr/local/mysql/bin
@PnTutorialsbyPradnyankurNikam
Жыл бұрын
Hi Firas, There should be space between cd and /usr/... like, cd /usr/local/mysql/bin Let me know if it works. Regards, Pradnyankur
@shyamjeetksharma
2 ай бұрын
I tried but not worked
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Hi SHYAMJEET, Are you getting any error message? Let me know more details so that I can help you fix the issue.
@shyamjeetksharma
2 ай бұрын
@@PnTutorialsbyPradnyankurNikam how can we connect
@PnTutorialsbyPradnyankurNikam
2 ай бұрын
Try the steps given in the video, and let me know if you get any error message. I'll check your error message and provide you the solution here, as I get time.
Пікірлер: 177