m1 arm64版本mac安装mysql记录

1. 下载

https://dev.mysql.com/downloads/mysql/ 选择arm版本的 下载tar

2. 解压缩

双击解压后，在下载里多出了一个文件夹

3. 安装

   cd /usr/local

   sudo mv ~/Downloads/mysql-8.0.27-macos11-arm64 .

   sudo mv mysql-8.0.27-macos11-arm64 mysql

   sudo chown -R 你的电脑用户名（不是中文的英文的） mysql

做完上一步 基本算是安装完毕

4. 初始化

   cd /usr/local/mysql/bin

   sudo ./mysqld --initialize --user=mysql 正确的样子是

   2021-11-11T14:31:48.557093Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.27) initializing of server in progress as process 3235 2021-11-11T14:31:48.558489Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 2021-11-11T14:31:48.563895Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-11-11T14:31:48.662172Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2021-11-11T14:31:49.271952Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main 2021-11-11T14:31:49.271970Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main 2021-11-11T14:31:49.295930Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wJEw,&aY8iai 2021-11-11T14:31:49.568618Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.27).

一定记住这个临时密码 我的是“wJEw,&aY8iai” 随机的都是。

如果出现了下面的问题，请执行 rm -rf /usr/local/mysql/data

2021-11-11T14:27:14.202825Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.27) initializing of server in progress as process 2931 2021-11-11T14:27:14.204838Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2021-11-11T14:27:14.204873Z 0 [ERROR] [MY-013236] [Server] The designated data directory /usr/local/mysql/data/ is unusable. You can remove all files that the server added to it. 2021-11-11T14:27:14.204918Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-11-11T14:27:14.205320Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.27) MySQL Community Server - GPL.

5. 启动服务

   cd /usr/local/mysql/support-files sudo ./mysql.server start 可以看到

Starting MySQL .Logging to '/usr/local/mysql/data/bogon.err'. SUCCESS!

 cd /usr/local/mysql/bin 
mysql -uroot -p  

输入那个密码 可以直接粘贴。

进入之后直接输入命令：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你要设置的密码';

完事儿，完美安装。

后续：如果想把mysql等指令当成常用指令 vim ~/.bash_profile

source .bash_profile

输入：

 export  PATH=$PATH:/usr/local/mysql/bin
 export  PATH=$PATH:/usr/local/mysql/support-files

按esc，输入“:wq”

source .bash_profile 

说句实话，用了mac并没有觉得它比Ubuntu好，钱白花了

本站文章除注明转载/出处外，均为本站原创或翻译，转载前请务必署名,转载请标明出处
最后编辑时间为: 2021/11/12 02:43