macos10.15 手动安装 mysql8.0

下载

官网地址： https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.22-macos10.15-x86_64.tar.gz

安装

下载完成后，解压到 /usr/local ，然后重命名为 mysql
即最终目录为：/usr/local/mysql

调整目录权限

1cd /usr/local
2sudo chown -R zhangcong:staff mysql

初始化数据库

1./bin/mysqld --initialize --user=mysql
22018-12-01T14:42:12.002186Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.22) initializing of server in progress as process 4229
32018-12-01T14:42:12.004783Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
42018-12-01T14:42:12.006285Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
52018-12-01T14:42:14.187443Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: iM46X&03qRc_
62018-12-01T14:42:15.427614Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) initializing of server has completed

初始化过程中，会生成一个随机的root初始密码，记好这个，后面会用到。
如果没记下这个密码，导致后面无法登录，可以rm -rf /usr/local/mysql/data/* 把所有文件干掉，再来一把。

启动mysql

1./support-files/mysql.server start

看到这个SUCCESS就表示启动成功了。
注：start为启动服务；类似的，status为查看状态，stop为停止服务

登录后的操作

登录，修改密码：

 1### 登录（使用上面生成的密码）
 2./bin/mysql -uroot -p
 3
 4### 修改密码为123456
 5ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
 6
 7### 刷新缓存
 8FLUSH PRIVILEGES;
 9
10### 远程登录
11update mysql.user set host='%' where host='localhost' and user='root';
12
13### 刷新缓存
14FLUSH PRIVILEGES;