50,530
社区成员
发帖
与我相关
我的任务
分享
一、root用户登录进入命令行
二、
use mysql;
select user,host from user;
update user set host='%' where user='root';
flush privileges;
三、
以账号密码链接:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;
指定ip链接:
GRANT ALL PRIVILEGES ON *.* TO 'tuser'@'192.168.1.1' IDENTIFIED BY 'tpwd' WITH GRANT OP
flush privileges;
[/quote]
打漏了字母ip链接那里最后还是:OPTION
一、root用户登录进入命令行
二、
use mysql;
select user,host from user;
update user set host='%' where user='root';
flush privileges;
三、
以账号密码链接:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;
指定ip链接:
GRANT ALL PRIVILEGES ON *.* TO 'tuser'@'192.168.1.1' IDENTIFIED BY 'tpwd' WITH GRANT OP
flush privileges;
public Connection getConnection() {
try {
if (conn == null || conn.isClosed()) {
Class.forName(driver);
conn = DriverManager.getConnection(url, "root", "qq971024");
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
在返回空之前,必定会先报一个SQLException 或者ClassNotFoundException 。感觉是报错日志没打全吧。日志等级调一下,或者直接看服务器上的tomcat日志,应该有新发现。 public Connection getConnection() {
try {
if (conn == null || conn.isClosed()) {
Class.forName(driver);
conn = DriverManager.getConnection(url, "root", "qq971024");
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
在返回空之前,必定会先报一个SQLException 或者ClassNotFoundException 。感觉是报错日志没打全吧。日志等级调一下,或者直接看服务器上的tomcat日志,应该有新发现。[/quote]
能不能教下啊?刚接触Linux呢,还不太会,而且是没有界面的Ubuntu系统,不知道怎么查看日志[/quote]
查看tomcat路径
ps -ef|grep tomcat
查看日志
tail -f /tomcat路径/logs/catalina.out
war最终也是会解压成文件。测试的话,直接替换.class文件,再重启就行了。可以在BaseDaoMysql类中多写几个System.out.print来调试。 public Connection getConnection() {
try {
if (conn == null || conn.isClosed()) {
Class.forName(driver);
conn = DriverManager.getConnection(url, "root", "qq971024");
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}