Docker MySQL（docker mysql容器重启数据还在吗）

25-03-04 10

此处将为大家介绍关于DockerMySQL的详细内容，并且为您解答有关dockermysql容器重启数据还在吗的相关问题，此外，我们还将为您介绍关于Can''tconnecttolocalMySQLs

此处将为大家介绍关于Docker MySQL的详细内容，并且为您解答有关docker mysql容器重启数据还在吗的相关问题，此外，我们还将为您介绍关于Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)、Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''、CentOS yum安装mysql后 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’、Docker MySQL无法连接到socket的有用信息。

本文目录一览：

Docker MySQL（docker mysql容器重启数据还在吗）
Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)
Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''
CentOS yum安装mysql后 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
Docker MySQL无法连接到socket

Docker MySQL（docker mysql容器重启数据还在吗）

Docker 下 MySQL 的安装

# 搜索 mysql 镜像
docker search mysql
# 通常输出:
NAME                            DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED
mysql                           MySQL is a widely used, open-source relati...   4511      [OK]
mysql/mysql-server              Optimized MySQL Server Docker images. Crea...   310                  [OK]
centurylink/mysql               Image containing mysql. Optimized to be li...   51                   [OK]
zabbix/zabbix-server-mysql      Zabbix Server with MySQL database support       42                   [OK]
zabbix/zabbix-web-nginx-mysql   Zabbix frontend based on Nginx web-server ...   23                   [OK]
imega/mysql                     Size: 149 MB, alpine:3.5, Mysql Server: 10...   11                   [OK]
# ...

# 拉取 mysql 镜像
# 这里选择 mysql/mysql-server(size:200+MB),而不选择 mysql(size:400+MB)
docker pull mysql/mysql-server
# 看网络情况,等待即可...
# 拉取完成后,可以查看下本地镜像列表
docker image list
# 通常输出:
REPOSITORY                                      TAG                 IMAGE ID            CREATED             SIZE
mysql/mysql-server                              latest              3ab554875eb9        2 weeks ago         215MB

# 基于 mysql 镜像启动一个 mysql 容器
# run 命令会先创建一个容器,再运行
# --env 环境参数中必须设置 mysql 的 root 密码,不然启动失败.
docker container run 
--name=mysql-1 
--publish=3306:3306 
--volume=/data/mysql/:/var/lib/mysql/ 
--restart=always 
--env=MYSQL_ROOT_PASSWORD=mysqllPassword 
-d mysql/mysql-server

# 查看容器列表
docker container list
# mysql 容器启动成功的话,通常输出:
CONTAINER ID        IMAGE                COMMAND                  CREATED             STATUS              PORTS                               NAMES
82111d39fc1e        mysql/mysql-server   "/entrypoint.sh my..."   8 seconds ago       Up 7 seconds        0.0.0.0:3306->3306/tcp, 33060/tcp   mysql-1

Tips:MySQL 默认会把 root 用户限制为只允许本地登录,意味着不做任何修改的情况下,我们是没法远程访问该 mysql 数据库的, 解决办法.

参考文档

Docker Swarm 部署Mysql/Mariadb高可用主从复制集群

Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)

ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)

原因：系统盘满了

[root@localhost opt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
18G 17G 0 100% /
tmpfs 504M 0 504M 0% /dev/shm
/dev/sda1 477M 80M 372M 18% /boot
[root@localhost opt]#

解决：

删除大文件后，重启系统解决

[root@localhost mysql]# /opt/lampp/lampp status
Version: XAMPP for Linux 1.8.3-3
Apache is not running.
MySQL is not running.
ProFTPD is running.

df: 未处理文件系统
[root@localhost opt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
18G 17G 0 100% /
tmpfs 504M 0 504M 0% /dev/shm
/dev/sda1 477M 80M 372M 18% /boot
[root@localhost opt]#

[root@localhost ~]# /opt/lampp/lampp status
Version: XAMPP for Linux 1.8.3-3
Apache is not running.
MySQL is running.
ProFTPD is running.

转

xampp 无法启动mysql 找不到mysql.sock

(2016-02-24 23:21:24)

转载▼

分类：技术

出现的问题：
如果xampp中的mysql启动不了，出现ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)报错，
停止xampp的时候报：
-bash-4.1# /opt/lampp/lampp stop
Stopping XAMPP for Linux 1.8.2-6...
XAMPP: Stopping Apache...ok.
XAMPP: Stopping MySQL...ok.
XAMPP: Stopping ProFTPD...kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec ... or kill -l [sigspec]
fail.

解决办法：
如果网上一些方法不好用的话，可以试试以下方法：
1. 确定系统盘是否满了
#df -h
2. 删除/opt/lampp目录中的pid文件（删掉后xampp重启时会重建，如果不放心，可以先备份lampp目录）
删除mysql相关缓存：
#rm -rf /opt/lampp/var/mysql/VM_*
删除proftp相关缓存：
#rm -rf /opt/lampp/var/proftpd.pid
如果找不到pid文件，可以搜一下：
#find /opt/lampp -name ''*.pid''

Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''

MySQL已经被我移到数据盘了，本地连接数据库会报错：Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''

但是远程是可以连接的，my.cnf设置mysql的根目录也改成了数据盘的地址，还要在加上client的参数，设置如下：

[client]
socket = /home/data/mysql/mysql.sock

之后重启下mysql就可以了

CentOS yum安装mysql后 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

亲，是不是忘记了开MysqL服务，service MysqLd start

Docker MySQL无法连接到socket

我正在学习Docker,我在尝试连接乘客满容器和mysql容器上的Rails应用程序时遇到了问题.两者都在撰写文件中链接

app:
  build: ./rails
  ports:
    - "80:80"
  links:
    - database
  volumes:
    - ./rails:/home/app/webapp
database:
  image: MysqL
  environment:
    - MysqL_DATABASE="dockertest"
    - MysqL_USER="dockertest"
    - MysqL_PASSWORD="dockertest"
    - MysqL_ROOT_PASSWORD="root"

所以我在我的Dockerfile顶部添加了apt-get install

FROM phusion/passenger-full
RUN apt-get update && apt-get install libMysqLclient-dev MysqL-client -y

# Set correct environment variables.
ENV HOME /root

# Use baseimage-docker's init process.
CMD ["/sbin/my_init"]

RUN rm -f /etc/service/Nginx/down
RUN rm /etc/Nginx/sites-enabled/default
ADD webapp.conf /etc/Nginx/sites-enabled/webapp.conf

RUN mkdir /home/app/webapp
workdir /home/app/webapp
ADD . /home/app/webapp
RUN cd /home/app/webapp && bundle install
RUN touch /home/app/webapp/tmp/restart.txt

# Clean up APT when done.
RUN apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

这也是我在Rails应用程序中的database.yml.

default: &default
  adapter: MysqL2
  database: dockertest
  host: <%= ENV['MysqL_PORT_3306_TCP_ADDR'] %>
  port: <%= ENV['MysqL_PORT_3306_TCP_PORT'] %>
  username: dockertest
  password: dockertest

development:
  <<: *default

production: 
  <<: *default

问题是我无法停止接收错误

Can't connect to local MysqL server through socket '/var/run/MysqLd/MysqLd.sock' (2)

webconf文件是

# /etc/Nginx/sites-enabled/webapp.conf:
server {
    listen 80;
    server_name localhost;
    root /home/app/webapp/public;

    passenger_enabled on;
    passenger_user app;
    passenger_ruby /usr/bin/ruby2.2;
}

这是正确的方法吗？你可以看到我对码头工作者来说很新.

解决方法:

这里的问题是你的docker-compose.yml文件中的links指令.你有：

links:
  - database

根据docker-compose.yml reference,这基本上是说链接名称：别名是database：database.

此外,如果您阅读linking container docs,则可以看到导出到源容器的环境的格式为ALIAS_XXX,例如ALIAS_PORT_3306_TCP_PORT.所以在你的database.yml中本质上你想要做的是这样的：

default: &default
  adapter: MysqL2
  database: dockertest
  host: <%= ENV['DATABASE_PORT_3306_TCP_ADDR'] %>
  port: <%= ENV['DATABASE_PORT_3306_TCP_PORT'] %>
  username: dockertest
  password: dockertest

development:
  <<: *default

production: 
  <<: *default

如果你想使用MysqL别名,你的链接必须在你的docker-compose.yml文件中看起来像这样.

links:
  - database:MysqL

错误：

Can't connect to local MysqL server through socket '/var/run/MysqLd/MysqLd.sock' (2)

基本上来自你的Rails应用程序不是要查看database.yml中的内容并默认为本地/var/run/MysqLd/MysqLd.sock连接.

希望能帮助到你.

今天的关于Docker MySQL和docker mysql容器重启数据还在吗的分享已经结束，谢谢您的关注，如果想了解更多关于Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)、Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''、CentOS yum安装mysql后 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’、Docker MySQL无法连接到socket的相关知识，请在本站进行查询。

本文标签：