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!!
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 😊🙏
Thank you. Learnt a very important thing. Can you make a tutorial on how to move mysql data to an external hdd and load sql from there? Need this as my mac does not have enough space to hold mysql tables. Will appreciate it.
Hi Sandeep, Checkout my MySQL export tutorial. It will be useful in your case. Here is the link, th-cam.com/video/Jvul-wr-_Bg/w-d-xo.html Regards, Pradnyankur
What if you can't access your mysql from your terminal it says no such file or directory. How to fix it and access the file. I am using XAMPP to connect to phpmyadmin.
Hi Adiel, the "no such file or directory" error is when you don't use the correct path to MySQL bin folder. On your XAMPP, make sure you change the directory to MySQL bin folder, then you can connect to MySQL database server.
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
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.
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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
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
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.
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?
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
@@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 🙏🏽
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).
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
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
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. 😊🙏
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
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
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?
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.
@@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.
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
@@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.
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.
@@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.
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
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!
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. th-cam.com/video/PBAnWXKIps8/w-d-xo.html
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
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.
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
@@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
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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
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
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
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
I'm at 11:04 in the video entering mysql -u root and getting this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)...any idea what's happening?
Hi Ian, 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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
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
@@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)
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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
Hi Lucas, I've given the solution to fix the error in my another video tutorial at given timeline. Check it out here th-cam.com/video/CBtBZgmP22M/w-d-xo.html
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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
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. th-cam.com/video/Ddx13KlW8yQ/w-d-xo.html Let me know if it helps. Regards, Pradnyankur
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)
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. th-cam.com/video/Y33uhgh5eOc/w-d-xo.html 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. th-cam.com/video/11B8Ori9ArA/w-d-xo.html Let me know if it works. Regards, Pradnynkur
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`
Hi Jeremy, Are you sure you stopped MySQL instance from system preferences? Also, did you execute, "sudo pkill mysqld" before running "sudo mysqld_safe......"
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.
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!
Glad to know the tutorial was helpful to you. Thank you for the positive feedback I appreciate it 😊🙏
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!!
Thank you Shiva for the positive feedback. Glad to know the video tutorial was helpful to you. 😊🙏
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.
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 😊🙏
Thank you. Learnt a very important thing.
Can you make a tutorial on how to move mysql data to an external hdd and load sql from there? Need this as my mac does not have enough space to hold mysql tables. Will appreciate it.
Hi Sandeep,
Checkout my MySQL export tutorial. It will be useful in your case. Here is the link,
th-cam.com/video/Jvul-wr-_Bg/w-d-xo.html
Regards,
Pradnyankur
Thank you this was very helpful!
People ensure to check if conda is deactivate in both terminals if you are facing issues.
Thank you brother for the positive feedback and your inputs.
Easy to follow just what I was looking for. Thank you
You're welcome! 😊🙏
You just best! I couldn't solve this problem for a long time, but you really help me. Thank you so much!
You are welcome Артём 😊🙏
thanks so much, such a simple and easy to follow video
You are welcome. Glad to know the tutorial was helpful! 😊🙏
Well explained! Thank you!
Thank you Raushan, for the positive feedback 😊🙏
Amazing tutorial sir. It worked.
Thanks Adyasa for the positive feedback. Glad to know the tutorial worked for you.
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
You can reset the password. I already have given the steps in this video.
Thank you so much, that was super helpful.
Thank you Sumaya, Glad it was helpful! 😊🙏
Thanks a lot! It really helped me recovering the root password
Glad to hear that Miguel 😊🙏
What if you can't access your mysql from your terminal it says no such file or directory. How to fix it and access the file. I am using XAMPP to connect to phpmyadmin.
Hi Adiel, the "no such file or directory" error is when you don't use the correct path to MySQL bin folder. On your XAMPP, make sure you change the directory to MySQL bin folder, then you can connect to MySQL database server.
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?
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
Yes Thanks a lot brother
Currently I am working on Mac 14 sonoma
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.
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
I just wanted to ask you so what’s the actual reason why lastest version is not working in Mac right now?
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
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.
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?
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
I have the same problem
@@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 🙏🏽
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).
Thank you for your contribution, I appreciate it.
Hi sir for me its showing access denied to the bin folder. Can you help ?
Hi Ali, Make sure you are logged in to your computer using root user account.
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?
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
Can you explain me that it says command not found @@PnTutorialsbyPradnyankurNikam
You saved my time! thank you brother
You are welcome AnakMit bro 😊🙏
Thank you very much for this bro, it really helped me to connect to the server.
You are welcome Uday, Glad to know the tutorial was helpful to you. Thanks for the feedback 😊🙏
Thanks a lot for your efforts.
It's my pleasure Kalyan 😊🙏
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
Hi Abdulraqib, Can you provide your MacOS Big Sur version number so that I can help you choose the correct installer.
@@PnTutorialsbyPradnyankurNikam It happens to me too :(
Thanks Sir!, It helped me a lot.
Glad to hear that the tutorial was helpful to you. 🙏😊
Thank you sir. I hope never to do this but at least I now know it can be done.
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. 😊🙏
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
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
Can you please guide us on how we can install SSMS on MAC? Thank you.
Hi Amin, Currently I don't have SSMS tutorials. I'll consider it adding in future.
@@PnTutorialsbyPradnyankurNikam Thank you so much for this consideration.
Thank you so much 👍
You are welcome
Thank you for making this video 🙏🏾🙏🏾🙏🏾🙏🏾
You're welcome Bernice 😊🙏
Thank so much for this video...
You are most welcome 😊🙏
ekdam mast bataya h
Thank you very much for the feedback, glad to know the video was helpful to you 😊🙏
it worked for me thankyou
Glad to know, the video tutorial was helpful to you.
For changing root user password- it says ‘mysqld_safe’ command not found
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
@@PnTutorialsbyPradnyankurNikam worked … thank you so much
Thank you so much!
You are welcome Hussain 😊🙏
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?
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.
@@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.
Glad to know you were able to fix the issue.
my sql server getting close immediately when i started the server from setting, what to do ?
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
@@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.
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.
THANK YOU SO MUCH
You are welcome Jank 😊🙏
Sir please make a tutorial on the postgresql
Thank you Vikas for your valuable suggestion. Sure I’ll add postgreSQL tutorials soon.
@@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.
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
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!
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.
th-cam.com/video/PBAnWXKIps8/w-d-xo.html
@@PnTutorialsbyPradnyankurNikam thank you, this worked!
thanks so much. savior
You are welcome Daniel 😊🙏
HI I AM gettingn error that mysqld_safe command not found
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
Sir after identified by ( new password )’; enter it doesn’t apper the Query OK plss help me
‘> that is the only thing that appears when i press enter
Hi Can you enter you full SQL statement here, so that I can review and help you fix the issue.
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.
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
@@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
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
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
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
legend, thank you
Thank you very much for the positive feedback Jon 😊🙏
My sql server gets active for just 2-3 seconds and then it gets stopped…What should I do now sir?
same to me 🥲
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
thanks saved my life
You are welcome Tasnuva 😊🙏
Thankful.
You are welcome Keyur 😊🙏
i forget root user password in mac - can I restore or reset it ?
Hi Anish, yes you can reset MySQL root user password by following the steps given in the videos.
THANKS MAN!
You are welcome Ricky 😊🙏
I'm at 11:04 in the video entering mysql -u root and getting this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)...any idea what's happening?
Hi Ian,
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
@@PnTutorialsbyPradnyankurNikam thank you
amazing. Thank you
You are welcome 😊🙏
Thank You!!
You're welcome! Usha 😊🙏
Thank you
You are welcome Kyle 😊🙏
Thanks!
Thank you Ashmit for the "Super Thanks". Glad to know the video tutorials was helpful to you. 😊🙏
My system "Active Instances" shows red. Please suggest
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
@@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)
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
@@PnTutorialsbyPradnyankurNikam thanks now installation done successfully but getting “Local instance 3306 - Warning - not supported”
Which macOS version you are using?
Thank you, handsome bro
Thank you Bobby ☺️ This was first one. I mean, nobody called me handsome before 😆
tnx q lot
You are welcome Shanto 😊🙏
sangat membantu bangettttt😘😘
You are welcome 😊🙏
Thank you soooo soooo much
You're welcome Tinu 😊🙏
zsh: command not found: mysql
Hi Lucas, I've given the solution to fix the error in my another video tutorial at given timeline. Check it out here th-cam.com/video/CBtBZgmP22M/w-d-xo.html
super awesome!!!!!
Thank you Karan 😊🙏
very good
Thanks Shailja 😊🙏
love youuuuu!!!!
Love you too Jean 😊🙏
I use mysql -u root but error 2002(HY000)
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
Great 🎉
Thank you Rutvik 😊🙏
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?
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.
th-cam.com/video/Ddx13KlW8yQ/w-d-xo.html
Let me know if it helps.
Regards,
Pradnyankur
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)
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.
th-cam.com/video/Y33uhgh5eOc/w-d-xo.html
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.
th-cam.com/video/11B8Ori9ArA/w-d-xo.html
Let me know if it works.
Regards,
Pradnynkur
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`
Hi Jeremy, Are you sure you stopped MySQL instance from system preferences?
Also, did you execute, "sudo pkill mysqld" before running "sudo mysqld_safe......"
i got this error
no such file or directory: cd/usr/local/mysql/bin
Hi Firas,
There should be space between cd and /usr/... like,
cd /usr/local/mysql/bin
Let me know if it works.
Regards,
Pradnyankur
I tried but not worked
Hi SHYAMJEET, Are you getting any error message? Let me know more details so that I can help you fix the issue.
@@PnTutorialsbyPradnyankurNikam how can we connect
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.
THANK YOU!!!
You are welcome Jenny 😊🙏
thank you!
You're welcome Mario 😊🙏
Thank you
You're welcome Jeet 😊🙏