时间戳

首页 > 解决方案 > mariadb-secure-installation (Ver15.1) ERROR 1698 (28000): Access denied for user 'root'@'localhost'

macos - mariadb-secure-installation (Ver15.1) ERROR 1698 (28000): Access denied for user 'root'@'localhost'

问题描述

我正在按照本教程mariadb在 macOS Mojave上安装。当我尝试使用它来保护它时，我仍然遇到问题mariadb-secure-installation

touch: .my.cnf.16016: Permission denied
touch: .mysql.16016: Permission denied
chmod: .my.cnf.16016: No such file or directory
chmod: .mysql.16016: No such file or directory

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.

Enter current password for root (enter for none): 
/usr/local/bin/mariadb-secure-installation: line 249: .my.cnf.16016: Permission denied
/usr/local/bin/mariadb-secure-installation: line 250: .my.cnf.16016: Permission denied
/usr/local/bin/mariadb-secure-installation: line 251: .my.cnf.16016: Permission denied
/usr/local/bin/mariadb-secure-installation: line 253: .my.cnf.16016: Permission denied
/usr/local/bin/mariadb-secure-installation: line 218: .mysql.16016: Permission denied
/usr/local/bin/mariadb-secure-installation: line 220: .mysql.16016: No such file or directory
Enter current password for root (enter for none):

我试过这个没有成功：

ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
SET PASSWORD = PASSWORD('my_secret_password');

当我这样做时，mysql.server status我有

 ERROR! MariaDB is running but PID file could not be found

有人可以帮我解决这个问题：）

我必须清理mysql吗？

标签： macosmariadb

解决方案

我用 Noahmay 的建议解决了这个错误 ( sudo mariadb-secure-installation)

所以我首先启动了mySql server：

mysql.server start 
Starting MariaDB
 SUCCESS!

然后我用 mysql_native_password 设置了一个新密码。老实说，我真的不知道是否有必要。

➜  ~ mariadb

MariaDB [(none)]> ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
Query OK, 0 rows affected (0.012 sec)

MariaDB [(none)]> SET PASSWORD = PASSWORD('put_your_password_here');
Query OK, 0 rows affected (0.009 sec)

MariaDB [(none)]> exit
Bye

然后你可以把这条神奇的线和完成来保护 MariaDB

➜  ~ sudo mariadb-secure-installation

我希望它能帮助 macOS 用户。

推荐阅读