Docker安装Yearning

先在MySQL中创建"yearning"数据库，编码为utf8mb4。

运行容器：

docker run -d \
--name yearning \
-p 8000:8000 \
-e Y_LANG=zh_CN \
-e SECRET_KEY=d38d4804d1b8f722 \
-e MYSQL_ADDR=172.25.13.49:3306 \
-e MYSQL_USER=root \
-e MYSQL_PASSWORD=joycode \
-e MYSQL_DB=yearning \
yeelabs/yearning

执行SQL添加管理员：

INSERT INTO `core_accounts` (`username`,`password`,`department`,`real_name`,`email`,`is_recorder`,`query_password`) VALUES ('admin','pbkdf2_sha256$120000$zBsKAIdklVkR$PONEgTOLwSTL1mhmoXt3A+sN4GzdFIBGZSRtHe+yWhs=','DBA','超级管理员','',0,'');
 
INSERT INTO `core_global_configurations` (`authorization`,`ldap`,`message`,`other`,`stmt`,`audit_role`,`board`) VALUES ('global','{"url":"","user":"","password":"","type":"(\u0026(objectClass=organizationalPerson)(sAMAccountName=%s))","sc":"","ldaps":false,"map":"","test_user":"","test_password":""}','{"web_hook":"","host":"","port":25,"user":"","password":"","to_user":"","mail":false,"ding":false,"ssl":false,"push_type":false,"key":"","format":""}','{"limit":1000,"idc":["Aliyun","AWS"],"query":false,"register":false,"export":false,"ex_query_time":60}',0,'{"DMLAllowLimitSTMT":false,"DMLInsertColumns":false,"DMLMaxInsertRows":10,"DMLWhere":false,"DMLOrder":false,"DMLSelect":false,"DMLAllowInsertNull":false,"DMLInsertMustExplicitly":false,"DDLEnablePrimaryKey":false,"DDLCheckTableComment":false,"DDlCheckColumnComment":false,"DDLCheckColumnNullable":false,"DDLCheckColumnDefault":false,"DDLEnableAcrossDBRename":false,"DDLEnableAutoincrementInit":false,"DDLEnableAutoIncrement":false,"DDLEnableAutoincrementUnsigned":false,"DDLEnableDropTable":false,"DDLEnableDropDatabase":false,"DDLEnableNullIndexName":false,"DDLIndexNameSpec":false,"DDLMaxKeyParts":5,"DDLMaxKey":5,"DDLMaxCharLength":10,"MaxTableNameLen":10,"MaxAffectRows":1000,"MaxDDLAffectRows":0,"SupportCharset":"","SupportCollation":"","CheckIdentifier":false,"MustHaveColumns":"","DDLMultiToCommit":false,"DDLPrimaryKeyMust":false,"DDLAllowColumnType":false,"DDLImplicitTypeConversion":false,"DDLAllowPRINotInt":false,"DDLAllowMultiAlter":false,"DDLEnableForeignKey":false,"DDLTablePrefix":"","DDLColumnsMustHaveIndex":"","DDLAllowChangeColumnPosition":false,"DDLCheckFloatDouble":false,"IsOSC":false,"OSCExpr":"","OscSize":0,"AllowCreateView":false,"AllowCrateViewWithSelectStar":false,"AllowCreatePartition":false,"AllowSpecialType":false,"PRIRollBack":false}','');
 
INSERT INTO `core_graineds` (`username`,`group`) VALUES ('admin','["71757f41-09af-4a88-9ffd-d7a04d11eb43"]');
 
INSERT INTO `core_role_groups` (`name`,`permissions`,`group_id`) VALUES ('admin','{"ddl_source":[],"dml_source":[],"query_source":[]}','71757f41-09af-4a88-9ffd-d7a04d11eb43');

访问http://127.0.0.1:8000,登录账号：admin/Yearning_admin