搜索到
3
篇与
的结果
-
-
Mysql 查流程：show processlist;授权：grant all privileges on . to 'root'@'%' identified by '密码' with grant option;flush privileges;白名单例： 180.109.%.% 百度搜ip查看掩码删旧用户use mysql;select user,host from user;delete from user where user='' and host ='';递归sqlgroup_concat默认长度1M超出自动截取，手动改100M解决丢失问题在MySQL配置文件中my.conf或my.ini中[mysqld]里添加:group_concat_max_len=102400 向上递归SELECT T2.area_id FROM ( SELECT @r AS _id, (SELECT @r := pid FROM sys_area aa WHERE area_id = _id) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := 自己的ID, @l := 0) vars, sys_area h WHERE @r <> 0) T1 JOIN sys_area T2 ON T1._id = T2.area_id向下递归 SELECT DATA.area_id FROM ( SELECT @ids AS _ids, (SELECT @ids := GROUP_CONCAT(area_id) FROM sys_area WHERE enabled = true and FIND_IN_SET(pid, @ids)) AS cids, @l := @l + 1 AS LEVEL FROM sys_area, (SELECT @ids := 自己的ID, @l := 0) b WHERE @ids IS NOT NULL ) ID, sys_area DATA WHERE enabled = true and FIND_IN_SET(DATA.area_id, ID._ids) and area_id != 自己的ID
-
Maven 仓库地址https://mvnrepository.com/国内镜像<?xml version="1.0" encoding="UTF-8"?> <settings xmlns="http://maven.apache.org/SETTINGS/1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 http://maven.apache.org/xsd/settings-1.0.0.xsd"> <mirrors> <!-- <mirror>--> <!-- <id>mirrorId</id>--> <!-- <mirrorOf>repositoryId</mirrorOf>--> <!-- <name>Human Readable Name for this Mirror.</name>--> <!-- <url>http://my.repository.com/repo/path</url>--> <!-- </mirror>--> <mirror> <id>alimaven</id> <name>aliyun maven</name> <url>http://maven.aliyun.com/nexus/content/groups/public/</url> <mirrorOf>central</mirrorOf> </mirror> <mirror> <id>uk</id> <mirrorOf>central</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://uk.maven.org/maven2/</url> </mirror> <mirror> <id>CN</id> <name>OSChina Central</name> <url>http://maven.oschina.net/content/groups/public/</url> <mirrorOf>central</mirrorOf> </mirror> <mirror> <id>nexus</id> <name>internal nexus repository</name> <url>http://repo.maven.apache.org/maven2</url> <mirrorOf>central</mirrorOf> </mirror> <!-- junit镜像地址 --> <mirror> <id>junit</id> <name>junit Address/</name> <url>http://jcenter.bintray.com/</url> <mirrorOf>central</mirrorOf> </mirror> <!-- <mirrors>--> <!-- mirror | Specifies a repository mirror site to use instead of a given repository. The repository that | this mirror serves has an ID that matches the mirrorOf element of this mirror. IDs are used | for inheritance and direct lookup purposes, and must be unique across the set of mirrors. | <mirror> <id>mirrorId</id> <mirrorOf>repositoryId</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://my.repository.com/repo/path</url> </mirror> --> <mirror> <!--This sends everything else to /public --> <id>nexus-aliyun</id> <mirrorOf>*</mirrorOf> <name>Nexus aliyun</name> <url>http://maven.aliyun.com/nexus/content/groups/public</url> </mirror> <mirror> <id>osc</id> <mirrorOf>*</mirrorOf> <url>http://maven.oschina.net/content/groups/public/</url> </mirror> <mirror> <id>repo2</id> <mirrorOf>central</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://repo2.maven.org/maven2/</url> </mirror> <mirror> <id>net-cn</id> <mirrorOf>central</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://maven.net.cn/content/groups/public/</url> </mirror> <mirror> <id>ui</id> <mirrorOf>central</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://uk.maven.org/maven2/</url> </mirror> <mirror> <id>ibiblio</id> <mirrorOf>central</mirrorOf> <name>Human Readable Name for this Mirror.</name> <url>http://mirrors.ibiblio.org/pub/mirrors/maven2/</url> </mirror> <mirror> <id>jboss-public-repository-group</id> <mirrorOf>central</mirrorOf> <name>JBoss Public Repository Group</name> <url>http://repository.jboss.org/nexus/content/groups/public</url> </mirror> <mirror> <id>JBossJBPM</id> <mirrorOf>central</mirrorOf> <name>JBossJBPM Repository</name> <url>https://repository.jboss.org/nexus/content/repositories/releases/</url> </mirror> </mirrors> </settings>
