mariadb-secure-installation (Ver15.1)错误1698 (28000)：拒绝访问用户'root'@'localhost‘
mariadb-secure-installation (Ver15.1)错误1698 (28000)：拒绝访问用户'root'@'localhost‘
提问于 2021-04-18 18:54:05
我按照这个tutorial在macOs Mojave上安装mariadb。当我尝试用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吗？?
回答 1
Stack Overflow用户
回答已采纳
发布于 2021-04-19 16:53:19
我用Noahmay的建议解决了这个错误(sudo mariadb-secure-installation)
所以我首先启动了mySql服务器：
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然后，您可以将这条神奇的线放到secure MariaDB中并完成
➜ ~ sudo mariadb-secure-installation我希望它能帮助macOs用户。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/67147732
复制相关文章
相似问题
腾讯云开发者
