Shulou(Shulou.com)06/01 Report--

Mysql can be set when it is installed, but the lower version doesn't seem to work. It needs to be installed before it can be set up.

Error occurred in mysql5.7.18 connection under mac. The error message is: Access denied for user 'root'@'localhost' (using password: YES)

() the commands entered in shell must include all symbols such as; &.

Step 1: Apple-> system preferences-> lowest point mysql, shut down the mysql service

Step 2: enter the terminal input (cd / usr/local/mysql/bin/) and enter

Enter (sudo su) enter to obtain administrator privileges

Enter (. / mysqld_safe-- skip-grant-tables &) to disable the mysql verification function, mysql will restart automatically, and the mysql status in the preferences will become running

Step 3: enter the command (. / mysql) enter

Enter the command (flush privileges;) semicolon and don't forget to lose

Enter the root in the command (set password for 'root'@'localhost' = password (' root');) password ('root') as the new password. Don't forget to enter the semicolon yourself.

At this point, the password has been successfully modified and you can log in normally.

Summary

The above is the simple way to set the password of mac version 5.6 mysql that Xiaobian introduced to you. I hope it will be helpful to you. If you have any questions, please leave a message for me. The editor will reply you in time!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.