mysql 5.6.39 初始化root密码

最新推荐文章于 2025-04-22 10:11:11 发布

go_sparrow

最新推荐文章于 2025-04-22 10:11:11 发布

阅读量2.9k

点赞数

本文链接：https://blog.csdn.net/java_sparrow/article/details/79137429

版权

mac 专栏收录该内容

7 篇文章

订阅专栏

System Preferences->MySQL->Stop MySQL Server

cd /usr/local/mysql/bin
sudo mysqld_safe --skip-grant-tables

再开一个Terminal
mysql -u root

#5.6.39
UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';

其它版本
UPDATE mysql.user SET authentication_string=PASSWORD('your_new_password') WHERE User='root';

   mysql 
 
   tar -zxf 
 
   /usr/local/mysql 
 
   groupadd mysql 
 
   useradd -r -g mysql mysql 
 
   chown -R mysql:mysql data 
 
   ./scripts/mysql_install_db --user=mysql 
 
   chown -R root:root ./ 
 
   chown -R mysql:mysql data 
 
   ./support-files/mysql.server start 
 
   ./bin/mysqladmin -u root password 'root' 
 
   mysql -uroot -h 127.0.0.1 -p