连接mysql服务器

mysql>  SELECT
    -> user();
+----------------+
| user()         |
+----------------+
| ODBC@localhost |
+----------------+
1 row in set (0.00 sec)

=========
  14:00:51  Baron-lwl  (#)YingNing  E:/HYN/Java/B2C/customer/info/src/vssver.scc －（不存在）
2006-7-24  14:01:12  Baron-lwl  (#)YingNing  经理，eclips提示这个不存在
2006-7-24  14:01:25  (#)YingNing  Baron-lwl  这个没有用的，按F5刷新一下就好了。
2006-7-24  14:01:34  Baron-lwl  (#)YingNing  ok
2006-7-24  14:03:04  Baron-lwl  (#)YingNing  我调试项目，总提示说所需项目中存在错误:info.
2006-7-24  14:03:29  Baron-lwl  (#)YingNing  .java文件中又没错误提示
2006-7-24  14:03:41  Baron-lwl  (#)YingNing  只有些警告
2006-7-24  14:13:19  Baron-lwl  (#)YingNing  是不是数据库没设置的原因？
2006-7-24  14:15:33  (#)YingNing  Baron-lwl  通过Eclipse重新编译一次。数据库错误的话在 resin 运行的提示中显示。
2006-7-24  14:20:58  Baron-lwl  (#)YingNing  所需项目中存在错误:info. 但可以启动
2006-7-24  14:21:17  (#)YingNing  Baron-lwl  那没问题。
2006-7-24  14:24:08  Baron-lwl  (#)YingNing  启动后再插软件狗也行吗？
2006-7-24  14:24:25  (#)YingNing  Baron-lwl  可以
2006-7-24  14:24:39  (#)YingNing  Baron-lwl  一直插着就是了。
2006-7-24  14:24:46  Baron-lwl  (#)YingNing  好
2006-7-24  14:42:39  Baron-lwl  (#)YingNing  file:/E:/HYN/Java/B2C/customer/info/info/WEB-INF/struts-html.tld:19: java.lang.NoSuchMethodError: javax.servlet.jsp.tagext.TagAttributeInfo.<init>(Ljava/lang/String;ZLjava/lang/String;ZZ)V 
2006-7-24  14:43:08  Baron-lwl  (#)YingNing  经理，这是什么原因？百度没度到
2006-7-24  14:44:10  Baron-lwl  (#)YingNing  我在浏览器中输入http://localhost:8080/info/，出现那个问题
2006-7-24  15:00:49  (#)YingNing  Baron-lwl  servlet 包的版本问题。没有这个方法。我把我设置好的配置文件发给你吧。
14:05:48      (#)YingNing sends Eclipse-info.rar
2006-7-25  14:16:28      You have successfully received F:/Java/info程序/Eclipse-info.rar from (#)YingNing.
2006-7-29  15:07:49  Baron-lwl  (#)YingNing  经理，是不是用你发过来的Eclipse-info.rar里的文件替换掉原来的就ok了？
2006-7-29  15:10:12  (#)YingNing  Baron-lwl  是的
2006-7-29  15:10:50  Baron-lwl  (#)YingNing  ok
2006-7-29  15:19:54  Baron-lwl  (#)YingNing  呵呵，可以运行了啊
2006-7-29  15:22:37  Baron-lwl  (#)YingNing  经理，登录的用户和密码是？我输入hyn，hyn，不行
2006-7-29  15:23:46  (#)YingNing  Baron-lwl  是 hyn 密码 hyn
2006-7-29  15:25:54  (#)YingNing  Baron-lwl  看数据库连接是否有错误。mysql安装时指定 用户名和密码都是 root
2006-7-29  15:27:20  (#)YingNing  Baron-lwl  运行 E:/Server/MySQL-Server/bin/winmysqladmin.exe 来安装 mysql数据库
Baron-lwl says:
mysql> -u user -p B2C
    -> ;
ERROR 1064: You have an error in your SQL syntax near '-u user -p B2C' at line 1
Baron-lwl says:
[WinMySQLadmin]
Server=E:/Server/MySQL-Server/bin/mysqld-nt.exe
user=user
password=root
Baron-lwl says:
因为local user name是user,我就设user=user了
 YingNing says:
用户名用 root 吧，不然程序的配置还要改。你还不属性，先别改，一切按默认的设置吧。
Baron-lwl says:
哦,好的.开始我试过root,登录不了数据库(cmd下),然后才改的.
我现在改回来
Baron-lwl says:
Server=E:/Server/MySQL-Server/bin/mysqld-nt.exe
user=root
password=root
Baron-lwl says:
E:/Server/MySQL-Server/bin>mysql -h LWL -u root -proot mysql;
ERROR 1045: Access denied for user: 'root@202.116.86.136' (Using password: YES)
这是什么原因啊?
Baron-lwl says:
E:/Server/MySQL-Server/bin>mysql -h localhost -u root -proot B2C;
ERROR 1049: Unknown database 'b2c;'
 YingNing says:
不要;
Baron-lwl says:
哦
Baron-lwl says:
可以了,晕死

 

Baron-lwl says:
mysql> show databases;
+----------+
| Database |
+----------+
| B2C      |
| mysql    |
| tmp      |
+----------+
3 rows in set (0.11 sec)

mysql> use mysql
ERROR 1044: Access denied for user: '@127.0.0.1' to database 'mysql'

E:/Server/MySQL-Server/bin>mysql -h LWL -u user -proot mysql;
ERROR 1045: Access denied for user: 'user@202.116.86.136' (Using password: YES)

E:/Server/MySQL-Server/bin>mysql -h LWL -u root -proot mysql;
ERROR 1045: Access denied for user: 'root@202.116.86.136' (Using password: YES)

E:/Server/MySQL-Server/bin>mysql -h localhost -u root -proot mysql;
ERROR 1049: Unknown database 'mysql;'

E:/Server/MySQL-Server/bin>mysql -h localhost -u root -proot B2C;
ERROR 1049: Unknown database 'b2c;'

E:/Server/MySQL-Server/bin>mysql -h localhost -u root -proot B2C
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 8 to server version: 4.0.3-beta-nt

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> select database();
+------------+
| database() |
+------------+
| b2c        |
+------------+
1 row in set (0.05 sec)
---------------
E:/Server/MySQL-Server/bin>mysql -u root -h localhost -p   //sequence is trivial
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 10 to server version: 4.0.3-beta-nt

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

E:/Server/MySQL-Server/bin>mysql -p -u root -h localhost
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 11 to server version: 4.0.3-beta-nt

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
--------------------------

C:/Documents and Settings/user>mysql -h host -u root -p
'mysql' 不是内部或外部命令，也不是可运行的程序
或批处理文件。//must in the current directory

C:/Documen