連線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