yfl@slave4:~$ docker pull mysql:5.5.53
5.5.53: Pulling from library/mysql
386a066cd84a: Pull complete
827c8d62b332: Pull complete
de135f87677c: Pull complete
05822f26ca6e: Pull complete
581edb358f3e: Pull complete
df4ad3824469: Pull complete
de3fccb307ff: Pull complete
98bc471865b4: Pull complete
0d19ce23241a: Pull complete
5a3a76908528: Pull complete
068c2a1c3d8e: Pull complete
Digest: sha256:2aa365becf97739d924798b4304bbf6146467efd8b252b555f13bec28a12f8f9
Status: Downloaded newer image for mysql:5.5.53
yfl@slave4:~$ docker run --name=mysql -itd -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql
Unable to find image 'mysql:latest' locally
docker: Error response from daemon: Get https://registry-1.docker.io/v2/: remote error: tls: handshake failure.
See 'docker run --help'.
yfl@slave4:~$ docker run --name=mysql -itd -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql:5.5.53
ef8b19faba4001b933815579671840852db3e2a8d3f60982cf43479d2a0d2ef2
yfl@slave4:~$ docker exec -it mysql /bin/bash
root@ef8b19faba40:/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.53 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from user;
+------+------+
| user | host |
+------+------+
| root | % |
+------+------+
1 row in set (0.00 sec)
mysql> delete from user where host !='%';
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from user;
+------+------+
| user | host |
+------+------+
| root | % |
+------+------+
1 row in set (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>