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