[問題]不知道哪理出錯

文章由 **frankh** » 2004-08-19 16:05

本來我是連phpmyadmin都不能進去...後來我把config.ini.php裡面ㄉ帳號密碼都沒有設我才行登錄到phpmyadmin/index.php但現在又出現我要新增資料庫沒有權限.....

SQL 語法: 

(

SELECT `User` , `Host` , `Db` , `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv` 
FROM `db` 
WHERE `Db` LIKE _latin1 'mysql'
COLLATE latin1_swedish_ci
AND NOT (
`Select_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Insert_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Update_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Delete_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Create_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Drop_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Grant_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `References_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
)
)
UNION (

SELECT `User` , `Host` , "*" AS "Db", `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Grant_priv` , `References_priv` 
FROM `user` 
WHERE NOT (
`Select_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Insert_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Update_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Delete_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Create_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Drop_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `Grant_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
AND `References_priv` = _latin1 'N'
COLLATE latin1_swedish_ci
)
)
ORDER BY `User` ASC , `Host` ASC , `Db` ASC ;

mysql

代碼: 選擇全部

#1267 - Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION'

請問我該如何解決...因為我連灌phpbb都抓不道資料庫..
我是灌在iis上...因為我對這套系統不太熟....但是因為要跑asp....
所以請教我如何解決..拜託...
Os: Windows 2000 Server sp4
Constitute: IIS.5 + php4.3.4+mysql-5.0.0 + phpMyAdmin2.6.0
Networking: T1 ADSL