Great!

Thanks

Great

Sure

Great!

Thanks!

Hello Steve, the reason you are getting the error message is because the /usr/local path is not yet written to your bash profile. So, you should first edit the bash profile to include that path, then try to login again. Perform any of the following on terminal Open a terminal window and type in the code below, then enter on your keyboard Sudo nano /etc/paths Add the following lines to that file. To insert such changes, press i on your keyboard, then use the down arrow to screw down to a new line and insert the two changes below /usr/local/mysql/bin /usr/local/mysql/support-files To save and exit, press esc on your keyboard, then :wq! Then enter. After this step, restart your terminal and proceed with the installation as shown in the video.Video link is again included here for you@

Earnest IT Thanks my g!

@@ITVidz THANK YOU SO MUCH

@@ITVidz I want to die bruh it won't save and exit

Hi Sruthi, please note that to install applications on your computer using "sudo or Supper user" you need to have admin privileges to the device in which you are using. Otherwise, it will be impossible if you don't have such privileges. If you are the admin user of your Mac, all you have to do is to change from z shell to bash shell. I will make a video on that as well

Hi Zhang. Use the link below to review Mysql documentation section that speaks specifically about caching_sha2_password issue you are facing. I hope this helps. dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-data-dictionary-changes

see my reply to your original comment.

I'm stuck too, did you figure out how to solve that

Ok. Change your default shell back to bash, install the mysql, then change it back to Z shell. Steps Change Zsh to bash: copy and paste this on terminal, then hit enter: chsh -s /bin/bash Change bash back to Zsh: Copy and paste this on terminal after you have installed mysql, then hit enter: chsh -s /bin/zsh

Here is an updated video on MySQL if you are on windows. kzfaq.info/get/bejne/pruandZem7DDpok.html

On macOS Catalina, open terminal and try the following. Sudo nano /etc/paths With that file open, add the following to the bottom of the file. To do this, just click the (i) key on your keyboard to activate insert action. /usr/local/mysql/bin Safe the file by pressing esc, then :wq! Close and reopen the terminal window, then try running: mysql -u root -p Hopefully, this should work.

@@ITVidz add what ? I have exactly the same issue

Hi Mikael, directly above the show databases; command are two execution signs that you can click to run that sql code. when you do, you should see a list of databases within your instance.

Hi Valerie, you have to set that up. Use the article or link to guide you in the process www.richardcastera.com/blog/how-to-setup-a-local-web-server-on-your-computer-using-xampp/

Try to add aliases to your shell's resource file to make it easier to access mysql and mysqladmin from the command line, then try to connect as root using the Mysql -u root -p. The syntax to add alianses to bash is as follows: alias mysql=/usr/local/mysql/bin/mysql alias mysqladmin=/usr/local/mysql/bin/mysqladmin Even better, add /usr/local/mysql/bin to your PATH environment variable. You can do this by modifying the appropriate startup file for your shell. For more information, see Section 4.2.1, “Invoking MySQL Programs”. If this don’t work, use this link dev.mysql.com/doc/refman/8.0/en/dynindex-command.html to review other options for Mysql Documentation especially the bash section.

Hi Carl, if the solution I provided earlier does not work, use this one instead. Open terminal and install MySql using the command below brew install MySql Then click enter on your keyboard Once that is done, login to MySql as root using MySql -u root -p Then inter your root password. This should work.

@@ITVidz still not working dude i tried

@@priyanshus6108 If you do not have admin access to your computer, you will not be able to succeed with such installation. Another reason, could be that the software on your system is not up to date or something. So, check that and retry. Also, macOS Catalina now uses Zshell instead of bash, so check for compatibility of MySql with that shell, then try installation again. It could be a host of reasons why you are not able to install and configure MySql on your system

Hello Carl This is the problem with your $PATH: /usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin which probably doesn't exist. Instead you want ${PATH}:/usr/local/mysql/bin. So do export PATH=${PATH}:/usr/local/mysql/bin. do this export and you see working

same problem, can u tell me how to fix it

Same problem

Hello Varma, please note that it is not "sudo in" it is "sudo LN" lower case, not i as in ink, but l as in link. Also, note that there is a space before the last section of the command. I have re-written it here so you can just copy and paste on your terminal window: sudo ln -s /usr/local/mysql/bin/mysql/bin/mysql /usr/local/bin; then cmd enter on your computer.

If your cursor is not working, try to use the backspace button on you keyboard or restart your computer and try again

Hi Davidd, use this link and try option 3 that starts with sudo sh -c 'echo stackoverflow.com/questions/10577374/mysql-command-not-found-in-os-x-10-7

Earnest IT : Hi Earnest IT, thanks for getting back to me. I’ve tried option 3 and that doesn’t work. I really don’t know where to turn or what to do. It’s simply not working.

@Soja 2 Me too. Have you solved it?

Solved It: I forgot to link the mysql.exec with my usr/local/bin folder. Link it via: "sudo ln -s /usr/local/mysql/bin/mysql /usr/local/bin"

@@timderkekskeks4590 Thank you very much

@@timderkekskeks4590 You're the best! Thank you very much!

@@timderkekskeks4590 how did you link it? I am having the same problem

Hi Parita. Please use this path on your terminal window. Just copy and paste it as it is. ln -s /usr/local/mysql/bin/mysql/bin/mysql /usr/local/bin Then press CMD inter on your Mac You should receive an option to inter the password for your computer. If the mysql bin directory already exist in you environment, you may consider setting the password for that directory using: mysqladmin -u root password Newpassword or try connecting to mysql using: mysql_secure_connection. If none of this works, then I will presume that the current version of you Mac software may not allow you to install and configure the application or you may not have the necessary admin privileges to install and configure applications in your environment. I hope this was helpful.

I omitted sudo in my initial response, so, just copy the path below to terminal, then cmd inter: sudo ln -s /usr/local/mysql/bin/mysql/bin/mysql /usr/local/bin

@@ITVidz Thank you very much I appreciate!! I got it to work!!

@@ITVidz sir i have the same problem and it keeps on saying file exists and im the admin and unique user of my pc . any suggestion? thnx alot

@@midohegazi5986 File exists means you already have the file on your computer. Now, the default MySql installation installs to /usr/local/mysql which is not in your path, specifically the MySql client is installed at /usr/local/mysql/bin/mysql. You can specify it exactly to launch the client by using this path: /usr/local/mysql/bin/mysql -u root I hope this helps.

Use the mysql website and follow the video to download the recent software package for mysql.

just go to your package folder mysql-8-0-20-macos10.15-x86_64.pkg and make a right click on it then open it it will work

Same issue. Is your issue resolved?

Hi Asenk Kwan, your access was denied because you are using either a guest account, probably with or without root privileges. Us this link from stack overflow and try solution 76. stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

@@ITVidz okey thanks bro... i try