Back

MYSQL 5.7 在安装时,会自动生成一个密码?坑爹啊。ubuntu下生成到哪里了?

发布时间: 2016-06-28 08:09:00

refer to:  https://skyf.org/reset-mysql579-root-password/

以及我的答案: http://stackoverflow.com/a/38070525/445908

Under MYSQL 5.7, If you are using mysql for development purpose, just :

1.kill mysql :

$ sudo service mysql stop

2.start mysql under --skip-grant-tables mode:

$ sudo mysqld_safe --skip-grant-tables

and, further, you could try to change the user table under "skip-grant-table" mode, however I failed.

so, this is just a workaround.

Back