Reset MySQL 8 Database root user password on MacOS Big Sur

Подписаться 4,5 тыс.

Просмотров 26 тыс.

50% 1

Reset MySQL 8 Database root user password on MacOS Big Sur. If you forgot MySQL root user password on your macOS operating system. No problem! This video will help you reset root user password on MySQL database. In this video tutorials we will two types of error message.
Error 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Solution: This error is caused when your MySQL server instance is not running. We will learn how to start MySQL database server instance.
Error 2: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Solution: This error is caused when you enter invalid database user password. We will learn how to reset MySQL non root user account password, as well as root user account password.
Follow the password reset steps given in this video tutorial and let me know if it works for you. If you encounter errors or didn't understand something, feel free to ask me questions in comments section of this video.
Chapters #
0:00 Introduction
01:23 Fix Error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
02:56 Fix Error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
03:58 Reset MySQL database non root user account password
07:45 Reset MySQL database root user account password
13:36 End message, try yourself, ask question
#ResetMySQLPassword #MacOS #MySQL #MySQL8 #Password #Reset

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 173

@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 😊🙏

@munirh44 Год назад

Easy to follow just what I was looking for. Thank you

@PnTutorialsbyPradnyankurNikam Год назад

You're welcome! 😊🙏

@edrod8807 Месяц назад

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 Месяц назад

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 😊🙏

@shivashankarirajaram8628 16 дней назад

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 15 дней назад

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

@monkey.d.gojira 6 месяцев назад

Thank you this was very helpful! People ensure to check if conda is deactivate in both terminals if you are facing issues.

@PnTutorialsbyPradnyankurNikam 6 месяцев назад

Thank you brother for the positive feedback and your inputs.

@raushansingh5358 Год назад

Well explained! Thank you!

@PnTutorialsbyPradnyankurNikam Год назад

Thank you Raushan, for the positive feedback 😊🙏

@sumihassan6 5 месяцев назад

Thank you so much, that was super helpful.

@PnTutorialsbyPradnyankurNikam 5 месяцев назад

Thank you Sumaya, Glad it was helpful! 😊🙏

@adyasamishra3392 12 дней назад

Amazing tutorial sir. It worked.

@PnTutorialsbyPradnyankurNikam 11 дней назад

Thanks Adyasa for the positive feedback. Glad to know the tutorial worked for you.

@udaykiranblogging 22 дня назад

Thank you very much for this bro, it really helped me to connect to the server.

@PnTutorialsbyPradnyankurNikam 21 день назад

You are welcome Uday, Glad to know the tutorial was helpful to you. Thanks for the feedback 😊🙏

@pruebaerror6977 7 месяцев назад

thanks so much, such a simple and easy to follow video

@PnTutorialsbyPradnyankurNikam 7 месяцев назад

You are welcome. Glad to know the tutorial was helpful! 😊🙏

@t6652 Год назад

Thanks Sir!, It helped me a lot.

@PnTutorialsbyPradnyankurNikam Год назад

Glad to hear that the tutorial was helpful to you. 🙏😊

@miguelaquilesplazarosillon7731 4 месяца назад

Thanks a lot! It really helped me recovering the root password

@PnTutorialsbyPradnyankurNikam 4 месяца назад

Glad to hear that Miguel 😊🙏

@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. 😊🙏

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

@BernicePezuzu Год назад

Thank you for making this video 🙏🏾🙏🏾🙏🏾🙏🏾

@PnTutorialsbyPradnyankurNikam Год назад

You're welcome Bernice 😊🙏

@anakmit5494 3 месяца назад

You saved my time! thank you brother

@PnTutorialsbyPradnyankurNikam 3 месяца назад

You are welcome AnakMit bro 😊🙏

@mtbmtbmtbcycle8797 7 дней назад

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 7 дней назад

Thank you for your contribution, I appreciate it.

@kalyan-k 7 месяцев назад

Thanks a lot for your efforts.

@PnTutorialsbyPradnyankurNikam 7 месяцев назад

It's my pleasure Kalyan 😊🙏

@442trash 13 дней назад

THANK YOU SO MUCH

@PnTutorialsbyPradnyankurNikam 12 дней назад

You are welcome Jank 😊🙏

@ItzHussuni Год назад

Thank you so much!

@PnTutorialsbyPradnyankurNikam Год назад

You are welcome Hussain 😊🙏

@howtostepbystep3756 3 месяца назад

Thank so much for this video...

@PnTutorialsbyPradnyankurNikam 3 месяца назад

You are most welcome 😊🙏

@oxide_digno0657 8 месяцев назад

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 8 месяцев назад

You can reset the password. I already have given the steps in this video.

@onepercentdaily 8 дней назад

thanks so much. savior

@PnTutorialsbyPradnyankurNikam 8 дней назад

You are welcome Daniel 😊🙏

@ashmitgupta5303 19 дней назад

Thanks!

@PnTutorialsbyPradnyankurNikam 19 дней назад

Thank you Ashmit for the "Super Thanks". Glad to know the video tutorials was helpful to you. 😊🙏

@jonluis2647 20 дней назад

legend, thank you

@PnTutorialsbyPradnyankurNikam 20 дней назад

Thank you very much for the positive feedback Jon 😊🙏

@VLPN_world 4 месяца назад

Thank you so much 👍

@PnTutorialsbyPradnyankurNikam 4 месяца назад

You are welcome

@RickyLloren Год назад

THANKS MAN!

@PnTutorialsbyPradnyankurNikam Год назад

You are welcome Ricky 😊🙏

@ushaprudhvi6121 Год назад

Thank You!!

@PnTutorialsbyPradnyankurNikam Год назад

You're welcome! Usha 😊🙏

@keyur-vamja-it Год назад

Thankful.

@PnTutorialsbyPradnyankurNikam Год назад

You are welcome Keyur 😊🙏

@jennyzhang7332 Год назад

THANK YOU!!!

@PnTutorialsbyPradnyankurNikam Год назад

You are welcome Jenny 😊🙏

@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 Месяц назад

@@PnTutorialsbyPradnyankurNikam It happens to me too :(

@kylekim2847 14 дней назад

Thank you

@PnTutorialsbyPradnyankurNikam 14 дней назад

You are welcome Kyle 😊🙏

@arpitasarang2870 21 день назад

ekdam mast bataya h

@PnTutorialsbyPradnyankurNikam 21 день назад

Thank you very much for the feedback, glad to know the video was helpful to you 😊🙏

@kishanpatel7334 2 месяца назад

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 2 месяца назад

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 2 месяца назад

Yes Thanks a lot brother Currently I am working on Mac 14 sonoma

@kishanpatel7334 2 месяца назад

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 2 месяца назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y33uhgh5eOc.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11B8Ori9ArA.html Let me know if it works. Regards, Pradnynkur

@kishanpatel7334 2 месяца назад

I just wanted to ask you so what’s the actual reason why lastest version is not working in Mac right now?

@Finding-NEMO-14 3 месяца назад

amazing. Thank you

@PnTutorialsbyPradnyankurNikam 3 месяца назад

You are welcome 😊🙏

@tinu1503 7 месяцев назад

Thank you soooo soooo much

@PnTutorialsbyPradnyankurNikam 7 месяцев назад

You're welcome Tinu 😊🙏

@karanmehndiratta6614 11 месяцев назад

super awesome!!!!!

@PnTutorialsbyPradnyankurNikam 11 месяцев назад

Thank you Karan 😊🙏

@AliHasan-q9o 14 дней назад

Hi sir for me its showing access denied to the bin folder. Can you help ?

@PnTutorialsbyPradnyankurNikam 13 дней назад

Hi Ali, Make sure you are logged in to your computer using root user account.

@Ibrahimmairo Год назад

thank you!

@PnTutorialsbyPradnyankurNikam Год назад

You're welcome Mario 😊🙏

@jeanlaguna6949 Год назад

love youuuuu!!!!

@PnTutorialsbyPradnyankurNikam Год назад

Love you too Jean 😊🙏

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PBAnWXKIps8.html

@stephaniehunter7691 Год назад

@@PnTutorialsbyPradnyankurNikam thank you, this worked!

@TasnuvaNusratTahsin 8 дней назад

thanks saved my life

@PnTutorialsbyPradnyankurNikam 8 дней назад

You are welcome Tasnuva 😊🙏

@abhijith4842 4 месяца назад

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 4 месяца назад

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

@aminnizami3661 Год назад

Can you please guide us on how we can install SSMS on MAC? Thank you.

@PnTutorialsbyPradnyankurNikam Год назад

Hi Amin, Currently I don't have SSMS tutorials. I'll consider it adding in future.

@aminnizami3661 Год назад

@@PnTutorialsbyPradnyankurNikam Thank you so much for this consideration.

@B4BUNNYop Месяц назад

my sql server getting close immediately when i started the server from setting, what to do ?

@PnTutorialsbyPradnyankurNikam Месяц назад

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 Месяц назад

@@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 Месяц назад

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.

@ghy518 Год назад

Thank you, handsome bro

@PnTutorialsbyPradnyankurNikam Год назад

Thank you Bobby ☺️ This was first one. I mean, nobody called me handsome before 😆

@zhenbinchong6186 18 дней назад

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 17 дней назад

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 17 дней назад

@@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 17 дней назад

Glad to know you were able to fix the issue.

@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 8 месяцев назад

Can you explain me that it says command not found @@PnTutorialsbyPradnyankurNikam

@snehasgowda8726 3 месяца назад

HI I AM gettingn error that mysqld_safe command not found

@PnTutorialsbyPradnyankurNikam 3 месяца назад

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

@ackmadelfanpurnama6580 2 месяца назад

sangat membantu bangettttt😘😘

@PnTutorialsbyPradnyankurNikam 2 месяца назад

You are welcome 😊🙏

@Miki-fr8bu 2 месяца назад

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 2 месяца назад

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 Месяц назад

I have the same problem

@Miki-fr8bu Месяц назад

@@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 🙏🏽

@shantohossain1372 Год назад

tnx q lot

@PnTutorialsbyPradnyankurNikam Год назад

You are welcome Shanto 😊🙏

@oxide_digno0657 8 месяцев назад

Sir after identified by ( new password )’; enter it doesn’t apper the Query OK plss help me

@oxide_digno0657 8 месяцев назад

‘> that is the only thing that appears when i press enter

@PnTutorialsbyPradnyankurNikam 8 месяцев назад

Hi Can you enter you full SQL statement here, so that I can review and help you fix the issue.

@yogeshishere 5 месяцев назад

For changing root user password- it says ‘mysqld_safe’ command not found

@PnTutorialsbyPradnyankurNikam 5 месяцев назад

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 5 месяцев назад

@@PnTutorialsbyPradnyankurNikam worked … thank you so much

@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

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CBtBZgmP22M.html

@ayushsharma9158 Месяц назад

My sql server gets active for just 2-3 seconds and then it gets stopped…What should I do now sir?

@B4BUNNYop Месяц назад

same to me 🥲

@PnTutorialsbyPradnyankurNikam Месяц назад

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

@kongpopkeattireangwattana6113 9 дней назад

I use mysql -u root but error 2002(HY000)

@PnTutorialsbyPradnyankurNikam 9 дней назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y33uhgh5eOc.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11B8Ori9ArA.html Let me know if it works. Regards, Pradnynkur

@KishoreKumar-fp6hn Месяц назад

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 Месяц назад

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 Месяц назад

@@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 Месяц назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y33uhgh5eOc.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11B8Ori9ArA.html Let me know if it works. Regards, Pradnynkur

@KishoreKumar-fp6hn Месяц назад

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 Месяц назад

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

@AppuAbhi Месяц назад

My system "Active Instances" shows red. Please suggest

@PnTutorialsbyPradnyankurNikam Месяц назад

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 25 дней назад

@@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 25 дней назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y33uhgh5eOc.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11B8Ori9ArA.html Let me know if it works. Regards, Pradnynkur

@AppuAbhi 23 дня назад

@@PnTutorialsbyPradnyankurNikam thanks now installation done successfully but getting “Local instance 3306 - Warning - not supported”

@PnTutorialsbyPradnyankurNikam 23 дня назад

Which macOS version you are using?

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ddx13KlW8yQ.html Let me know if it helps. Regards, Pradnyankur

@anishkulshreshtha4780 Месяц назад

i forget root user password in mac - can I restore or reset it ?

@PnTutorialsbyPradnyankurNikam Месяц назад

Hi Anish, yes you can reset MySQL root user password by following the steps given in the videos.

@jolo8830 14 дней назад

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 13 дней назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Y33uhgh5eOc.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11B8Ori9ArA.html Let me know if it works. Regards, Pradnynkur

@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

@shyamjeetsharma Месяц назад

I tried but not worked

@PnTutorialsbyPradnyankurNikam 28 дней назад

Hi SHYAMJEET, Are you getting any error message? Let me know more details so that I can help you fix the issue.

@shyamjeetsharma 28 дней назад

@@PnTutorialsbyPradnyankurNikam how can we connect

@PnTutorialsbyPradnyankurNikam 28 дней назад

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.