01 * * * note * * *
Install the * * * *
1) first of all to the environment I used centos, use the yum install docker docke then r installation, use the docker pull mysql: lower version installed mysql best choice, and if you choose the latest or latest behind (not write) then may go wrong,
2) use the docker run - name vessel name - d - 3306: p. 3306 - v/conf/mysql:/etc/mysql/conf. D (mount configuration file) - e MySQL_ROOT_PASSWORD=password mysql: version
Or simply docker run - name vessel name - d - 3306: p. 3306 - l MySQL_ROOT_PASSWORD=password mysql: version
3) check the docker ps - whether a check to see if the status for the up virtual machine for bridge or with another machine on the same network segment, the router DNS address is correct, the firewall is closed or open port in order to facilitate to shut it down first service firewalld stop check status service firewalld status
4) modify mysql remote connection to use docker exec - bash it container name can use docker ps - a view the container name
Into the container output mysql -u root -p then enter into the password to check the use the mysql select the host, the user from the user. See if any % | root line if no input grant all privileges on *. * to root @ "%" identified by "password" with grant on;
Flush privileges;
5) using another computer navicat mysl, might fail here
Basic error resolution * * * * 1
) the database version is too high and cause visual tools version is too low, solution: visual tools to upgrade, the database version to reduce to download version, I've been in here 5. 6 check mysql version method docker images found a column tag
2) two machines of firewall problem or visualization tool to connect to the database connection properties input incorrect
Conclusion * * * *
I am a self-study Java is looking for a job internship students, this is my first post wrote not neat is not comprehensive, if there is a problem in the comments below, I will try my best to help you solve, this is CSDN, of course, there are a lot of bosses, if she hadn't answer let heavyweight title, very chatty ah, ha ha, the product comforms to the