docker第三天作业

使用discuz和mysql搭建论坛

[root@192 yum.repos.d]# docker search discuz

[root@192 yum.repos.d]# docker pull tencentci/discuz

[root@192 yum.repos.d]# docker images
[root@192 yum.repos.d]# docker run -P -d tencentci/discuz

[root@192 yum.repos.d]# docker ps -a

[root@192 yum.repos.d]# docker search php

[root@192 yum.repos.d]# docker pull php
[root@192 yum.repos.d]# docker top quirky_bose
[root@192 yum.repos.d]# yum install mariadb-server -y
[root@192 yum.repos.d]# systemctl start mariadb
[root@192 yum.repos.d]# mysql_secure_installation

[root@192 yum.repos.d]# mysql -uroot -p
MariaDB [(none)]> show databases;

MariaDB [(none)]> create database luntan;

MariaDB [(none)]> use luntan;

MariaDB [luntan]> show tables;
Empty set (0.00 sec)
MariaDB [luntan]> exit
Bye
[root@192 yum.repos.d]# docker exec quirky_bose hostname -I
172.17.0.2 

[root@192 yum.repos.d]# mysql -uroot -p
Enter password: 
MariaDB [(none)]> use mysql
MariaDB [mysql]> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
24 rows in set (0.00 sec)
MariaDB [mysql]> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| ::1       | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-----------+------+-------------------------------------------+
3 rows in set (0.00 sec)
MariaDB [mysql]> grant all on *.* to 'root@%' identified by '123'
    -> ;

MariaDB [mysql]> select host,user,password from user;
+-----------+--------+-------------------------------------------+
| host      | user   | password                                  |
+-----------+--------+-------------------------------------------+
| localhost | root   | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| 127.0.0.1 | root   | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| ::1       | root   | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| %         | root@% | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-----------+--------+-------------------------------------------+
MariaDB [mysql]> flush privileges
    -> ;
MariaDB [mysql]> exit
Bye
[root@192 yum.repos.d]# mysql -uroot -p123
MariaDB [(none)]> grant all on *.* to root@'192.168.159.133' identified by '123' ;
MariaDB [(none)]> use mysql
MariaDB [mysql]> update user set user='root' where host='%';

MariaDB [mysql]> select user,host,password from user;
+------+-----------------+-------------------------------------------+
| user | host            | password                                  |
+------+-----------------+-------------------------------------------+
| root | localhost       | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | 127.0.0.1       | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | ::1             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | 192.168.159.133 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| root | %               | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+------+-----------------+-------------------------------------------+
MariaDB [mysql]> flush privileges
MariaDB [mysql]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| luntan             |
| mysql              |
| performance_schema |
+--------------------+
在浏览器上访问192.168.159.133:49154

进入安装向导第三步输入相关账号密码信息然后下一步