bitnami mysql默认密码_重置Bitnami mysql 密码

mysql 默认密码为安装时设置的系统应用密码

How to reset the MySQL root password on Windows?

If you don't remember your MySQL root password on Windows, you can follow the steps below to reset it to a new value:

Assuming your BitNami stack is located in the C:\Bitnami directory and that you have opened theBitnami Console

, create a file in C:\Bitnami\mysql-init.txt with the content shown below (replace mynewpassword string with the one you want):

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mynewpassword');

fc8c05f2c79d

Stop the MySQL server using theManager Tool

.

Start MySQL with the following command into the Bitnami Console to set the new password:

mysql\bin\mysqld --defaults-file=mysql\my.ini --init-file=C:\Bitnami\mysql-init.txt --console

fc8c05f2c79d

Press Ctrl-c when the process finished showing the MySQLversion to kill the process. For example:

Version: '5.5.42'  socket: ''  port: 3306  MySQL Community Server (GPL)

fc8c05f2c79d

Start the MySQL server again using the Bitnami Manager Tool and delete the mysql-init script.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值