docker安装mysql并远程登录

[daivvv]

1.拉镜像

docker pull index.tenxcloud.com/tenxcloud/mysql 2.启动

docker run -p 3306:3306 --name mysql-container-k8s index.tenxcloud.com/tenxcloud/mysql 3.进入容器 docker ps查到容器id

docker exec -it id /bin/bash 4.进入mysql

mysql -u root -p

5.查看用户 use mysql;

select host,user,password from user;

6.修改密码

SET PASSWORD FOR 'admin'@'%' = PASSWORD('123456'); 远程连接即可. admin 123456

[daivvv]

backup

docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

restore

cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE