docker-compose 配置mysql，密码无效问题修复----已实践

时间：2025-03-19 16:42:40

  • 将配置文件从容器映射出来，并加上 skip-grant-tables

    # Copyright (c) 2017, 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  Server configuration file.
#
# For explanations see
# /doc/mysql/en/

[mysqld]
pid-file        = /var/run/mysqld/
socket          = /var/run/mysqld/
datadir         = /var/lib/mysql
secure-file-priv= NULL
skip-grant-tables

# Custom config should go here
!includedir /etc/mysql//

  • 重启容器

  • 进入容器

    docker exec -it mysql mysql
    • 将mysql的登陆密码设置为空并刷新
    update  set authentication_string='' where User='root';

flush privileges;

  • 将配置文件中的 skip-grant-tables删掉

  • docker exec -it mysql mysql 重新进入mysql

  • 设置新的密码并刷新

    ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;

  • 设置远程连接并刷新

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
flush privileges;

  • 重启docker

    • 相关文章