MYSQL 5.7 在安装时,会自动生成一个密码?坑爹啊。ubuntu下生成到哪里了?
访问量: 2266
refer to: https://skyf.org/reset-mysql579-root-password/
以及我的答案: http://stackoverflow.com/a/38070525/445908Under 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.