MySQL: Change root password in Mac

MySQL启动与密码设置

最新推荐文章于 2024-04-17 22:13:04 发布

原创最新推荐文章于 2024-04-17 22:13:04 发布 · 733 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mac #mysql #change #root #password

MySQL 专栏收录该内容

36 篇文章

订阅专栏

Step 1.

$ sudo /usr/local/mysql/bin/mysqld_safe –user=root & 
//start MySQL(Also, can start MySQL in System Preferences)

Step 2.

$ sudo /usr/local/mysql/bin/mysqladmin -uroot password yourpassword 
//set MySQL password to yourpassword（Attention: this command used when there is no password the first time）

Step 2.

$ sudo /usr/local/mysql/bin/mysqladmin -uroot -pyourCurrentpassword password yourNewpassword 
//change MySQL password to yourNewpassword（Attention: this command used to change the current password）