在OSX上重置MySQL/MariaDB密码 [英] Reset MySQL / MariaDB password on OSX
本文介绍了在OSX上重置MySQL/MariaDB密码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在遵循本指南.一切正常,但是今天root密码已经过期,我似乎无法使用任何—skip-grant-tables —skip-networking
类型选项来重置它.
I have installed MariaDB via Homebrew after following this guide. It has been working fine, however today the root password has expired and I cannot seem to reset it with any of the —skip-grant-tables —skip-networking
type options.
到目前为止,我已经尝试过:
So far I have tried:
brew services stop mariadb
mysqld_safe --skip-grant-tables --skip-networking
mysql_secure_installation
也尝试过
mysql_secure_installation --connect-expired-password
哪个给我:
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
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
/usr/local/Cellar/mariadb/10.3.13_1/bin/mysql: unknown option '--connect-expired-password'
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] Y
New password:
Re-enter new password:
/usr/local/Cellar/mariadb/10.3.13_1/bin/mysql: unknown option '--connect-expired-password'
Password update failed!
Cleaning up...
我还添加了:
[mysqld]
default_password_lifetime=0
skip-grant-tables
到/usr/local/etc/my.cnf
仍然不允许我使用上述命令更新root密码. 酿酒医生回来干净了,我快要尝试的东西用光了.
Still doesn't let me update the root password with the above commands. Brew doctor comes back clean and I'm running out of things to try.
推荐答案
登录
mysql -uroot
然后做
set password = password("your_password");
这篇关于在OSX上重置MySQL/MariaDB密码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文