作者：dongfangwujie

核心的SQL

DQL 数据查询语句。select

DML数据操作语言。insert、update、delete

DDL数据定义语言。create、drop、alter

DCL数据控制语言。grant、revoke

非核心

TPL事务处理语言。BEGIN TRASACTION COMMIT ROLLBACK

CCL 指针控制语言

FROM canal/canal-server:v1.1.5
 RUN mkdir /home/admin/canal-server/conf/estate/
 RUN mv /home/admin/canal-server/conf/example /tmp/
 ADD instance.properties /home/admin/canal-server/conf/estate/
EXPOSE 11110 11111 11112 9100 
WORKDIR /home/admin 
ENTRYPOINT [ "/alidata/bin/main.sh" ]
 CMD [ "/home/admin/app.sh" ] 

出自https://github.com/alibaba/canal/blob/master/docker/Dockerfile

cat dockerfile

FROM centos:7.6.1810
RUN mkdir /etc/yum.repos.d/bak /apps
RUN mv /etc/yum.repos.d/*repo /etc/yum.repos.d/bak
RUN curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
RUN yum clean all && yum makecache
RUN yum -y install gcc gcc-c++ zlib zlib-devel openssl openssl-devel pcre-devel unzip patch net-tools
RUN groupadd -r nginx
RUN useradd -s /sbin/nologin -g nginx -r nginx
RUN curl -o nginx-1.22.0.tar.gz http://nginx.org/download/nginx-1.22.0.tar.gz
RUN tar -zxvf nginx-1.22.0.tar.gz && cd nginx-1.22.0 && ./configure –prefix=/apps/nginx/ –with-http_ssl_module –user=nginx –group=nginx –with-http_gzip_static_module –with-http_stub_status_module –with-stream && make -j4 && make install
ADD init.sh /init.sh
CMD [“/bin/bash”,”init.sh”]

cat init.sh

/apps/nginx/sbin/nginx -g ‘daemon off;’

构建nginx

docker build -t nginx_manal:v2 .

启动服务

docker run -d -p 80:80 nginx_manal:v2

结果测试

cat dockerfile

FROM centos:6.9
RUN mkdir /etc/yum.repos.d/bak
RUN mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak
RUN curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-6.repo
RUN sed -i -e ‘s/centos\/\$releasever/centos-vault\/6.10/g’ /etc/yum.repos.d/CentOS-Base.repo
RUN curl -o /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-6.repo
RUN sed -i -e ‘s/com\/epel/com\/epel-archive/g’ /etc/yum.repos.d/epel.repo
RUN yum install openssh-server nginx -y
RUN /etc/init.d/sshd restart
RUN echo 123456|passwd –stdin root
ADD init.sh /init.sh
CMD [“/bin/bash”,”/init.sh”]

cat init.sh

service sshd restart
nginx -g ‘daemon off;’

docker build -t centos6.9_ssh_nginx:v3 .

docker run -d -p 3022:22 -p 80:80 centos6.9_ssh_nginx:v3

测试结果

查看dockerfile文件信息

cat dockerfile

FROM centos:6.9
RUN mkdir /etc/yum.repos.d/bak
RUN mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak
RUN curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-6.repo
RUN sed -i -e ‘s/centos\/\$releasever/centos-vault\/6.10/g’ /etc/yum.repos.d/CentOS-Base.repo
RUN yum install openssh-server -y
RUN /etc/init.d/sshd restart
RUN echo 123456|passwd –stdin root
CMD [“/usr/sbin/sshd”,”-D”]

构建镜像
docker build -t centos6.9_ssh:v2 .

启动镜像
docker run -d -p 2022:22 centos6.9_ssh:v2

构建的结果测试

1、世界经济全球化程度加深，国际市场风险加剧，外贸出口难度加大

2、经济结构调整升级，工业化、城镇化和现代化进程加快，国内市场需求进一步扩大。

人一辈子都在高潮一低潮中浮沉，唯有庸碌的人，生活才如死水一般；或者要有极高的修养，方能廓然无累，真正的解脱。

只要高潮不过分使你紧张，低潮不过分使你颓废，就好了。太阳太强烈，会把五谷晒焦；雨水太猛，也会淹死庄稼。我们只求心理相当平衡，不至于受伤而已。你也不是栽了筋斗爬不起来的人。

新建数据结构

 CREATE TABLE `tbl_tree` ( 
`id` int(11) NOT NULL AUTO_INCREMENT, 
`parent_id` int(11) DEFAULT NULL, 
`name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) 
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;  

插入数据信息

INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('1', '0', '家配成品 类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('2', '0', '营销物料 类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('3', '1', '家配'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('4', '1', '寝具'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('5', '1', '衣百货'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('6', '2', '物料'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('7', '3', '凳类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('8', '3', '椅类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('9', '3', '床类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('10', '3', '餐椅类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('11', '3', '桌台类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('12', '3', '沙发类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('13', '3', '窗帘类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('14', '3', '茶几类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('15', '3', '床头柜类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('16', '3', '软床类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('17', '3', '按摩护理 类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('18', '3', '其它配套 类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('19', '4', '软床类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('20', '4', '床垫类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('21', '4', '床配类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('22', '4', '床头柜类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('23', '4', '排骨架类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('24', '4', '销售道具'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('25', '5', '礼包类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('26', '5', '日用品类'); 
INSERT INTO `tbl_tree` (`id`, `parent_id`, `name`) VALUES ('27', '5', '家居饰品 类');

for i in `cd /proc;ls |grep “^[0-9]”|awk ‘ $0 >100’` ;do awk ‘/Swap:/{a=a+$2}END{print ‘”$i”‘,a/1024″M”}’ /proc/$i/smaps ;done |sort -k2nr 

#1、在mysql的安装目录中，新建data目录及my.ini#注意事项my.ini文件必须要用ansi的方式编码

#2、编辑my.ini

[mysqld] 
basedir=D:\mysql-5.7.36-winx64
datadir=D:\mysql-5.7.36-winx64\data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server=utf8
character_set_filesystem=utf8

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

#3、将D:\mysql-5.7.36-winx64\bin路径添加到path中

#4.初始化数据库D:\mysql-5.7.36-winx64\bin>mysqld –initialize –user=mysql –console

2022-03-30T07:44:01.640992Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).

2022-03-30T07:44:01.641071Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-03-30T07:44:01.641079Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-03-30T07:44:02.890183Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-03-30T07:44:03.350137Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2022-03-30T07:44:03.496899Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2b9d5b48-affd-11ec-83b7-0250f2000002.
2022-03-30T07:44:03.537576Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-03-30T07:44:04.828539Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-03-30T07:44:04.828830Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-03-30T07:44:04.829738Z 0 [Warning] CA certificate ca.pem is self signed.
2022-03-30T07:44:06.375278Z 1 [Note] A temporary password is generated for root@localhost: V8uZTa!8fk.p

#【注意】记录随机生成密码 或 初始采用这条命令：mysqld initialize insecure –user=mysql –console

#5.启动服务mysql服务net start mysql

【帮助指南】

1、netstat -ano|findstr 3306
2、Windows下Mysql5.7忘记root密码的解决方法

1. 打开第一个cmd窗口执行 net stop mysql57
2. 在第一个cmd窗口执行 mysqld –defaults-file=”C:\ProgramData\MySQL\MySQL Server 5.7\my.ini” –skip-grant-tables —注意以你的路径为准
3. 打开第二个cmd窗口执行 mysql -uroot -p 提示输入密码，直接回车（不用输入密码）
4. 选择数据库：use mysql;
5. 更新root的密码：update user set authentication_string=password(‘新密码’) where user=’root’ and Host=’localhost’;
6. 刷新权限：flush privileges;
7. 退出：quit
8. 重新登录：mysql -uroot -p 提示输入密码，这时输入密码才能登录。完成！！！

【FQA】mysqld: [ERROR] Found option without preceding group in config file D:\mysql-5.7.36-winx64\my.ini at line 1!
 
没有新建库，需要建立一个库