å¯ä»¥æ¾ä¸ªå
è´¹/å¼æºç客æ·ç«¯æ¥ä½¿ç¨ï¼ä¾å¦HeidiSQLæè
Navicat Liteï¼ä½ æä¸ä¸å°±è½æ¾å°ã
å®è£
åå¨éé¢è®¾ç½®å¥½è¿æ¥ï¼ä¸»è¦æ¯å¡«ä¸ä¸æå¡å¨å°åãç¨æ·ååå¸å·ï¼å°±è½å¯ä»¥ä½¿ç¨äºï¼æå¡å¨ç«¯å¯è½ä¹éè¦è®¾ç½®èµäºæéï¼ä¸ç¶å°±ä¼åºç°ç±»ä¼¼âERROR 1045 (28000): Access denied for user 'test1'@'localhostâè¿æ ·çé误ï¼å¦åºç°é误åè§åèèµæï¼ã
é»è®¤rootç¨æ·å°±å
·æææçæéï¼ä½ å¯ä»¥æ°å»ºä¸ä¸ªç¨æ·ï¼ä½¿å®æ¥æææçæéï¼è¿å¯ä»¥æå®ä»ä»ä¹å°æ¹ç»éãæéååå¯ä»¥å¾ç»çï¼å¯ä»¥ç²¾ç¡®å°tableï¼åselectè¿ç§ç®åçæ¥çåè½å½ä»¤é½å¯ä»¥éå®ãå
·ä½å½ä»¤åcreateï¼grantççå¯ä»¥æ¾æ¬ä¹¦ççãç¨æ·è®¿é®æé:
mysql.user å
¨å±å±çº§æé(global privileges)
db æ°æ®åºå±çº§(database-specific privileges)
tables_priv 表å±çº§(table-secific privileges)
columns_priv åå±çº§(column-secific privileges)
æ°å»ºç¨æ·
create user 'test1'@'localhost/127.0.0.1' identified by '123',
->'test2'@'%' identified by '123';
è¯æ³: create user 'user'[@'host'] [identified by [password] 'password']
å é¤ç¨æ·
drop user 'test1'@'localhost','test1'@'%','test2'@'localhost';
è¯æ³: drop user 'user'@'host'
æ¤éç¨æ·æé
revoke all on *.* from 'test'@'localhost';
æ´æ¹ç¨æ·å
rename user 'test'@'localhost' to 'test1'@'%';
ç¨æ·ææ
grant all privileges on *.*/dbname.*/dbname.tablename/ to 'test'@'localhost' identified by '123'
->required ssl with grant option;
grant select,update(field1,field2) on dbname.tablename to 'test1'@'%' identified by '123'
->required ssl with grant option;
æç´¢å¾å°ä¸ä½åè¾ç解å³åæ³å¦ä¸ï¼
é¦å
ï¼å¨è¿æ¥jdbc驱å¨çæ¶åï¼æå¦ä¸è¯å¥ï¼
String connstr ="jdbc:mysql://localhost:3306/tp_db?&useUnicode=true&characterEncoding=8859_1";
ç¶åï¼è¾å
¥ä¸ææ¶è½¬æ¢æ¶ï¼æå¦ä¸è¯å¥ï¼
sql=new String(sql.getBytes("iso8859-1"));
æåï¼è¾åºä¸ææ¶è½¬æ¢ï¼æå¦ä¸è¯å¥ï¼
String bookname=new String(rs.getString("bookname").getBytes("iso8859-1"),"GBKæè
GB2312");
注ï¼æ¥çæ¾ç¤ºç»æåºå¨ä¸ææ¯æçç¯å¢ä¸ï¼æçé
置为ï¼Linux7.3+Tomcat4.0+Mysql3.22 ä½æå¡å¨ç«¯ï¼IE6æNetscapeä½æµè§å¨ã
温馨提示:答案为网友推荐,仅供参考