mac下brew安装mysql8.0.19
程序员文章站
2022-04-30 18:21:11
...
之前在MAC上安装MYSQL一般是用官方的直接解压安装或下载dmg安装包或者自己编译安装,今天尝试第四种方式brew安装。
1、先brew info mysql查看下版本信息:
2、brew install mysql直接安装:
3、启动MYSQL服务
mysql.server start
4、初始化配置mysql_secure_installation
5、连接
brew安装后MYSQL的配置文件my.cnf位置为:/usr/local/etc/my.cnf
常用命令:
启动:sudo mysql.server start
关闭:sudo mysql.server stop
重启:sudo mysql.server restart
连接:mysql -u root -p
开机启动:brew services start mysql
用Navicat Premium尝试连接刚安装的MYSQL服务报如下错误:
Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
解决办法:
1、先修改my.cnf:
在[mysqld]块增加下面两行代码:
[caching_sha2_password]
default_authentication_plugin= mysql_native_password
重启MYSQL服务: sudo mysql.server restart
然后进入mysql:
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.19 Homebrew
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的ROOT密码';';
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> exit
再试
下一篇: 后缀自动机