连接mysql服务器

lenf

　　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