在OS X操作系统下设置MySQL root用户密码

我刚刚在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命令行!

为什么会这样?

当前回答

停止mysqld服务器。

Mac OS X:系统首选项→MySQL→停止MySQL服务器 Linux(从终端):sudo systemctl停止mysqld.service

Start the server in safe mode with privilege bypass From Terminal: sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables In a new terminal window: sudo /usr/local/mysql/bin/mysql -u root This will open the MySQL command-line client. From here enter: UPDATE mysql.user SET authentication_string=PASSWORD('NewPassword') WHERE User='root'; FLUSH PRIVILEGES; quit Stop the mysqld server again and restart it in normal mode. Mac OS X (From Terminal): sudo /usr/local/mysql/support-files/mysql.server restart Linux Terminal: sudo systemctl restart mysqld

2016-09-04 12:05:20

其他回答

当您登录MySQL终端时，请尝试执行FLUSH PRIVILEGES命令。如果这不起作用，请在MySQL终端中尝试以下命令集

mysql -u root

mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

用你想要的任何密码更改NEWPASSWORD。应该都准备好了!

更新:从MySQL 5.7开始，密码字段被重命名为authentication_string。修改密码时，使用以下查询来修改密码。所有其他命令保持不变:

mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';

请不要使用MySQL 8.0+

mysql> UPDATE mysql.user SET authentication_string='password' WHERE User='root';

因为它覆盖了authentication_string，它应该是一个哈希而不是纯文本，而是使用:

mysql> `ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';`

2011-06-24 23:58:52

在新的MySQL 5.7版本中，由于某些原因MySQL的二进制命令没有附加到shell中，你必须这样做:

安装完成后重新启动Mac。 MySQL开始: System Preferences→MySQL→Start按钮进入终端的MySQL install文件夹: cd /usr/local/mysql/bin/ 访问MySQL: ./mysql -u root -p 并输入为安装提供的初始密码。在MySQL客户端修改密码: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword'

2017-02-25 19:09:12

要引用MySQL 8.0.15 +， password()函数不可用。使用下面的命令。

请使用

UPDATE mysql.user SET authentication_string='password' WHERE User='root';

2019-10-24 06:58:40

如果你忘记了你的密码或者想把它改成你的MySQL:

Start your terminal and enter: sudo su Enter the password for you system Stop your MySQL server: sudo /usr/local/mysql/support-files/mysql.server stop Leave this window open, run second terminal window and enter here: mysql -u root And change your password for MySQL: UPDATE mysql.user SET authentication_string=PASSWORD('new_password') WHERE User='root'; where "new_password" - your new password. You don't need old password for MySQL. Flush, quit and check your new password: FLUSH PRIVILEGES; Close all windows and check your new password for MySQL.

2017-12-22 23:34:42

一旦你安装了MySQL，你需要建立“根”密码。如果您没有设置根密码，那么就没有根密码，您也不需要密码来登录。

因此，话虽如此，您需要建立一个根密码。

使用终端输入如下:

安装:设置root用户密码:

/usr/local/mysql/bin/mysqladmin -u root password NEW_PASSWORD_HERE

如果你犯了一个错误，或者需要修改root密码，请使用以下方法:

修改root密码:

cd /usr/local/mysql/bin/
./mysql -u root -p
> Enter password: [type old password invisibly]

use mysql;
update user set password=PASSWORD("NEW_PASSWORD_HERE") where User='root';
flush privileges;
quit

2012-04-16 22:35:23

在OS X操作系统下设置MySQL root用户密码

推荐文章

最新文章

标签