Homebrew Mariadb Mysql安装根目录访问被拒绝

Question

所以我基本上是用自制程序在mac上安装带有mysql的mariadb。以下是我所做的步骤：

警告：无法使用/usr/local/cellar/mariadb/10.4.6_1/bin/resolveip查找主机'toms-macbook-pro.local'。这可能意味着您的libc库与这个二进制MariaDB版本不是100%兼容。MariaDB守护进程mysqld应该正常工作，但主机名解析不能工作。这意味着在指定MariaDB特权时应该使用IP地址而不是主机名！mysql.user表已经存在！

之后运行mysql_upgrade会出现以下错误：

版本检查失败。调用'MySQL'命令行客户端错误1698（28000）时出现以下错误：拒绝用户'root'@'localhost'访问致命错误：升级失败

mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

但是像这样：

sudo mysql -u root

用户表返回以下内容：

MariaDB [(none)]> USE mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mysql]> SELECT User, Host, plugin FROM mysql.user;
+---------------+-------------------------+-----------------------+
| User          | Host                    | plugin                |
+---------------+-------------------------+-----------------------+
| root          | localhost               | mysql_native_password |
| toms          | localhost               | mysql_native_password |
|               | localhost               |                       |
|               | toms-macbook-pro.local |                       |
+---------------+-------------------------+-----------------------+
4 rows in set (0.004 sec)

Answer 1

您可以尝试更新根密码，然后访问它

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

退出Mysql并尝试登录

mysql -uroot -p # then use root as a password