mysql指定ip访问

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO ‘root’@’192.168.1.204’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; flush privileges; select * from user; 如果是更新 update user set host =’192.168.1.2′ where user = ‘root’ and Host=’localhost’;

FtpConfig.java

package FTPDemo; /** * @date 2016年12月30日 * @author xie * */ public class FtpConfig { // 主机ip private String FtpHost; // 端口号 private Integer FtpPort; // ftp用户名 private String FtpUser; // ftp密码 private String FtpPassword; // ftp中的目录 private String FtpPath; public String getFtpHost() { return FtpHost; } public Integer getFtpPort() { return FtpPort; } public … Read more

FtpUtil.java

package FTPDemo; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.logging.Logger; import org.apache.commons.net.ftp.FTPClient; import org.apache.commons.net.ftp.FTPFile; import org.apache.commons.net.ftp.FTPReply; public class FtpUtil { private static FTPClient ftp; /** * 获取ftp连接 * @param f * @return * @throws Exception */ public static boolean connectFtp(FtpConfig f) throws Exception{ ftp=new FTPClient(); boolean flag=false; if (f.getFtpPort()==null) { ftp.connect(f.getFtpHost(),21); … Read more