linux centOS7docker安装mysql镜像

下载mysql:docker pull mysql

第一次启动配置文件:docker-compose -f docker-compose-mysql.yml up  (文件配置在最下方)

启动没报错后退出再重新启动:docker-compose -f docker-compose-mysql.yml start

进入mysql容器:docker exec -it (容器id) /bin/sh

进入mysql命令行:mysql -u root -p

执行命令:use mysql;

创建远程连接用户:create user 'nlframe'@'%' identified by 'nlframe';

用户授权:grant all privileges on *.* to 'nlframe'@'%';

修改加密方式:alter user 'nlframe'@'%' identified by 'nlframe' password expire never;

     alter user 'nlframe'@'%' identified with mysql_native_password by 'nlframe';

保存修改:flush privileges;

退出容器:exit

关闭mysql:docker-compose -f docker-compose-mysql.yml stop

docker-compose-mysql.yml文件配置如下：

 

mysql:
        image: mysql
        volumes:
            - /docker/mysql/lib:/var/lib/mysql
            - /docker/mysql/etc/my.cnf:/etc/my.cnf:ro
            - /docker/mysql/conf/:/etc/mysql/conf.d
            - /docker/mysql/logs:/logs
            - /docker/mysql/tmp/cache:/tmp/cache
            - /docker/mysql/configs:/etc/configs/:ro
        restart: always
        ports:
             - "3306:3306"
        environment:
            MYSQL_ROOT_PASSWORD: root
            MYSQL_DATABASE: nlframe
            MYSQL_USER: mysql
            MYSQL_PASSWORD: mysql