通过brew安装MySQL

brew install mysql

安装成功如下图：

image.png

启用密码登录

执行：mysql_secure_installation

如果报错：Error: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)。执行重启服务：mysql.server start；重启后再执行：mysql_secure_installation；然后根据提示完成配置。

  1. apple@appledeMac-mini ~ % mysql_secure_installation
  3. Securing the MySQL server deployment.
  5. Enter password for user root: 
  6. Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  7. apple@appledeMac-mini ~ % mysql.server start
  8. Starting MySQL
  9. .. SUCCESS! 
  10. apple@appledeMac-mini ~ % mysql_secure_installation
  12. Securing the MySQL server deployment.
  14. Connecting to MySQL using a blank password.
  16. VALIDATE PASSWORD COMPONENT can be used to test passwords
  17. and improve security. It checks the strength of password
  18. and allows the users to set only those passwords which are
  19. secure enough. Would you like to setup VALIDATE PASSWORD component?
  22. Press y|Y for Yes, any other key for No: 
  23. Please set the password for root here.
  25. New password: 
  27. Re-enter new password: 
  28. By default, a MySQL installation has an anonymous user,
  29. allowing anyone to log into MySQL without having to have
  30. a user account created for them. This is intended only for
  31. testing, and to make the installation go a bit smoother.
  32. You should remove them before moving into a production
  33. environment.
  35. Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
  36. Success.
  39. Normally, root should only be allowed to connect from
  40. 'localhost'. This ensures that someone cannot guess at
  41. the root password from the network.
  43. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
  44. Success.
  46. By default, MySQL comes with a database named 'test' that
  47. anyone can access. This is also intended only for testing,
  48. and should be removed before moving into a production
  49. environment.
  52. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
  53.  - Dropping test database...
  54. Success.
  56.  - Removing privileges on test database...
  57. Success.
  59. Reloading the privilege tables will ensure that all changes
  60. made so far will take effect immediately.
  62. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
  63. Success.
  65. All done!

登录MySQL

执行：mysql -uroot -p
然后输入密码即可登录成功

  1. apple@appledeMac-mini ~ % mysql -uroot -p
  2. Enter password: 
  3. Welcome to the MySQL monitor.  Commands end with ; or \g.
  4. Your MySQL connection id is 14
  5. Server version: 8.0.26 Homebrew
  7. Copyright (c) 2000, 2021, Oracle and/or its affiliates.
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  15. mysql> show databases;
  16. +--------------------+
  17. | Database           |
  18. +--------------------+
  19. | information_schema |
  20. | mysql              |
  21. | performance_schema |
  22. | sys                |
  23. +--------------------+
  24. 4 rows in set (0.00 sec)

注：启动MySQL命令：mysql.server start 或者 brew services start mysql