linux下jsp与mysql连接出现问题！！！！！急急急！在线等待！！

[nmgclm626]

错误提示
Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)

********mysql jdbc已经安装！！！！！！！！！！

[匪六哥]

你的mysql的服务开着了吗？检查一下！

[nmgclm626]

ps 能够检测到服务进程 mysqld_safe

[nmgclm626]

将localhost改为ip地址后提示
Server configuration denies access to data source
怎么办？？？？？？？？？？？？？

[wangyanqiu]

linux下还每怎么玩过！

期待！

[zeeler]

你不用程序，直接操作MySQL数据库正常吗？能登陆并且查看里面的表吗？

[phoenxizhang]

同意zeeler,try

[nmgclm626]

能够正常操作

[nmgclm626]

现在又出现最初的错误提示了。请大家帮帮忙！！！！！！！！

[zeeler]

贴出你的连接数据库的部分代码

[nmgclm626]

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/mysql?user=root&password=";

Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";

[nmgclm626]

up

[nmgclm626]

up

[mty]

1. confirm the "Class.forName("org.gjt.mm.mysql.Driver").newInstance();" can be execute successfully, // use try & catch,
2. if error, there is no JDBC-DRIVER found. download and copy MySql's JDBC driver into TOMCATHOME\common\lib
3. if success, Test your DBServer, for examples: telnet localhost 3306, if can be succussful, your SqlServer is excuting.
4. then you'd create a database and user for your test
5. ok