docker mysql忘记密码,docker mysql命令

进入容器 docker exec -it mysql /贪玩的丝袜/bash 修改配置文件 执行一下命令 cd /etc/mysqlvi my.cnf#在最后添加:skip-grant-tables #在启mysql时不启动grant-tables my.cnf 文件内容 # Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.## This program is free software; you can redistribute it and/or modify# it under the terms of the GNU General Public License as published by# the Free Software Foundation; version 2 of the License.## This program is distributed in the hope that it will be useful,# but WITHOUT ANY WARRANTY; without even the implied warranty of# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the# GNU General Public License for more details.## You should have received a copy of the GNU General Public License# along with this program; if not, write to the Free Software# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA## The MySQL Community Server configuration file.## For explanations see# http://dev.mysql.com/doc/mysql/en/server-system-variables.html[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysqld_safe]pid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.socknice = 0[mysqld]skip-host-cacheskip-name-resolveuser = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplc-messages-dir = /usr/share/mysqlexplicit_defaults_for_timestamp# Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.#贪玩的丝袜d-address = 127.0.0.1#log-error = /var/log/mysql/error.logskip-grant-tables #在启mysql时不启动grant-tables# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# * IMPORTANT: Additional settings that can override those from this file!# The files must end with '.cnf', otherwise they'll be ignored.# 重启容器 docker restart mysql 后续操作 再次进入容器，运行下面命令 mysql -u root -p 无需输入密码直接回车登录，登录成功后进行修改密码相关操作，修改密码完成后将之前修改的文件添加的skip-grant-tables撤销，再重启容器就可以启用账号密码登录