apache容器远程mysql容器导入数据库

apache容器远程mysql容器导入数据库(docker)

1.远程访问apache容器

2.因为centos7默认是安装mariadb,所以yum remove mariadb*

3.yum list installed mysql* mariadb*

4.wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

5.rpm -ivh mysql-community-release-el7-5.noarch.rpm 此时yum源中会有mysql的源

6.yum install mysql

7.find / -name mysqld 然后启动mysql

8.mysql -h ip -u user -p

9.source 路径(apache容器下的sql文件路径)

启动mysql服务期间可能遇到问题:

1.TIMESTAMP with implicit DEFAULT value is deprecated

解决办法:

在/etc/my.cnf 文件中的[mysqld]下添加一行explicit_defaults_for_timestamp=true。就可以了

2.Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

解决办法:

在/etc/my.cnf文件中，指定user=root;

3.Plugin 'FEDERATED' is disabled

解决办法:

没有初始化,执行/usr/bin/mysql_install_db --user=mysql