我刚刚在Mac OS x上安装了MySQL，下一步是设置root用户密码，所以我接下来这样做:
启动终端应用程序以访问Unix命令行。
在Unix提示符下，我执行了以下命令:
cd /usr/local/mysql/bin
./mysqladmin -u root password' password'
但是，当我执行命令时
./mysql -u root，这是答案:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 224
Server version: 5.5.13 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, 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>
我不需要密码就能进入mysql命令行!
为什么会这样?
停止MySQL服务器
sudo /usr/local/mysql/support-files / mysql。服务器停止
以安全模式启动MySQL
Sudo /usr/local/mysql/bin/mysqld_safe——skip-grant-tables &
修改root用户密码
/usr/local/mysql/bin/mysql -u root
use mysql;
UPDATE user SET authentication_string=PASSWORD('NEW_PASSWORD') WHERE user='root';
FLUSH PRIVILEGES;
exit
测试
执行/usr/local/mysql/bin/mysql -u root命令
现在输入新密码开始使用MySQL。
macOS v10.14 (Mojave)及更高版本，从Mac OS X DMG安装程序安装5.7.26。
当尝试使用其他用户发布的UPDATE命令时，会导致以下错误:
错误1820 (HY000):在执行此语句之前，您必须使用ALTER USER语句重置密码。
复制安装程序提供给您的密码，打开终端，然后执行以下操作:
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURPASSWORDHERE';
如果您不记得设置的root密码，需要重置密码，请执行以下步骤:
Stop the mysqld server, this varies per install
Run the server in safe mode with privilege bypass
sudo mysqld_safe --skip-grant-tables;
In a new window connect to the database, set a new password and flush the permissions & quit:
mysql -u root
For MySQL older than MySQL 5.7 use:
UPDATE mysql.user SET Password=PASSWORD('your-password') WHERE User='root';
For MySQL 5.7+ use:
USE mysql;
UPDATE mysql.user SET authentication_string=PASSWORD("your-password") WHERE User='root';
Refresh and quit:
FLUSH PRIVILEGES;
\q
Stop the safe mode server and start your regular server back. The new password should work now. It worked like a charm for me :)
Note
运行
更新mysql。SET authentication_string=null WHERE user ='root';
如果您不想为root用户设置密码。或者PASSWORD()函数不适合您。
MySQL 8
关闭MySQL服务器
进入系统首选项-> MySQL
单击停止MySQL服务器按钮
打开两个终端[命令行]窗口
在第一个终端窗口中运行以下命令:
mysqld_safe --skip-grant-tables
在第二个终端窗口中执行以下操作:
4.1. 登录MySQL
mysql -u root
4.2. 在MySQL提示符中执行如下命令:
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSWORD';
4.3. 退出MySQL
exit;
回到第一个终端窗口并关闭mysqld_safe
5.1. 按CTRL + Z
5.2. 运行以下命令
mysqladmin -u root -p shutdown
5.3. 输入在4.2中设置的新密码。当提示。
启动MySQL服务器[见1.]
