锘??xml version="1.0" encoding="utf-8" standalone="yes"?>
鎴戦亣鍒扮殑涓涓敊璇?/font>錛?br />Release/Server.pch No such file or directory
Server鏄垜鐨勭▼搴忓悕銆傝В鍐蟲柟娉曪細
宸ョ▼鈥斺旇緗斺擟/C++鈥斺斿垎綾伙細棰勭紪璇戠殑澶存枃浠垛斺斾笉浣跨敤棰勮ˉ鍋塊〉鐪夆斺旂‘瀹氣斺斿叏閮ㄩ噸寤?br />
涓嶇敓鎴恟elease鐗堢殑璇濆埌鍒漢鐨勬満鍣ㄤ笂涓嶅ソ浣匡紝榪欏氨鏄彂甯冨晩錛侊紒鍚屽浠紒
Proxool is a Java connection pool. It's not rocket science but we've been doing it since 2001 and we've ironed out a lot of problems. Development has slowed down considerably over the past few years but we're still here, making releases and answering support questions.
rocket science :
net stop mysql
net start mysql
絎簩鎷涖佺櫥闄唌ysql
璇硶濡備笅錛?mysql -u鐢ㄦ埛鍚?-p鐢ㄦ埛瀵嗙爜
閿叆鍛戒護mysql -uroot -p錛?鍥炶濺鍚庢彁紺轟綘杈撳叆瀵嗙爜錛岃緭鍏?2345錛岀劧鍚庡洖杞﹀嵆鍙繘鍏ュ埌mysql涓簡錛宮ysql鐨勬彁紺虹鏄細
mysql>
娉ㄦ剰錛屽鏋滄槸榪炴帴鍒板彟澶栫殑鏈哄櫒涓婏紝鍒欓渶瑕佸姞鍏ヤ竴涓弬鏁?h鏈哄櫒IP
絎笁鎷涖佸鍔犳柊鐢ㄦ埛
鏍煎紡錛歡rant 鏉冮檺 on 鏁版嵁搴?* to 鐢ㄦ埛鍚岪鐧誨綍涓繪満 identified by "瀵嗙爜"
濡傦紝澧炲姞涓涓敤鎴穟ser1瀵嗙爜涓簆assword1錛岃鍏跺彲浠ュ湪鏈満涓婄櫥褰曪紝 騫跺鎵鏈夋暟鎹簱鏈夋煡璇€佹彃鍏ャ佷慨鏀廣佸垹闄ょ殑鏉冮檺銆傞鍏堢敤浠oot鐢ㄦ埛榪炲叆mysql錛岀劧鍚庨敭鍏ヤ互涓嬪懡浠わ細
grant select,insert,update,delete on *.* to user1@localhost Identified by "password1";
濡傛灉甯屾湜璇ョ敤鎴瘋兘澶熷湪浠諱綍鏈哄櫒涓婄櫥闄唌ysql錛屽垯灝唋ocalhost鏀逛負"%"銆?/p>
濡傛灉浣犱笉鎯硊ser1鏈夊瘑鐮侊紝鍙互鍐嶆墦涓涓懡浠ゅ皢瀵嗙爜鍘繪帀銆?/p>
grant select,insert,update,delete on mydb.* to user1@localhost identified by "";
絎洓鎷涳細 鎿嶄綔鏁版嵁搴?/p>
鐧誨綍鍒癿ysql涓紝鐒跺悗鍦╩ysql鐨勬彁紺虹涓嬭繍琛屼笅鍒楀懡浠わ紝姣忎釜鍛戒護浠ュ垎鍙風粨鏉熴?/p>
1銆?鏄劇ず鏁版嵁搴撳垪琛ㄣ?/p>
show databases;
緙虹渷鏈変袱涓暟鎹簱錛歮ysql鍜宼est銆?mysql搴撳瓨鏀劇潃mysql鐨勭郴緇熷拰鐢ㄦ埛鏉冮檺淇℃伅錛屾垜浠敼瀵嗙爜鍜屾柊澧炵敤鎴鳳紝瀹為檯涓婂氨鏄榪欎釜搴撹繘琛屾搷浣溿?/p>
2銆?鏄劇ず搴撲腑鐨勬暟鎹〃錛?/p>
use mysql;
show tables;
3銆?鏄劇ず鏁版嵁琛ㄧ殑緇撴瀯錛?/p>
describe 琛ㄥ悕;
4銆?寤哄簱涓庡垹搴擄細
create database 搴撳悕;
drop database 搴撳悕;
5銆?寤鴻〃錛?/p>
use 搴撳悕;
create table 琛ㄥ悕(瀛楁鍒楄〃);
drop table 琛ㄥ悕;
6銆?娓呯┖琛ㄤ腑璁板綍錛?/p>
delete from 琛ㄥ悕;
7銆?鏄劇ず琛ㄤ腑鐨勮褰曪細
select * from 琛ㄥ悕;
絎簲鎷涖佸鍑哄拰瀵煎叆鏁版嵁
1. 瀵煎嚭鏁版嵁錛?/p>
mysqldump --opt test > mysql.test
鍗沖皢鏁版嵁搴搕est鏁版嵁搴撳鍑哄埌mysql.test鏂囦歡錛屽悗鑰呮槸涓涓枃鏈枃浠?/p>
濡傦細mysqldump -u root -p123456 --databases dbname > mysql.dbname
灝辨槸鎶婃暟鎹簱dbname瀵煎嚭鍒版枃浠秏ysql.dbname涓?/p>
2. 瀵煎叆鏁版嵁:
mysqlimport -u root -p123456 < mysql.dbname銆?/p>
涓嶇敤瑙i噴浜嗗惂銆?/p>
3. 灝嗘枃鏈暟鎹鍏ユ暟鎹簱:
鏂囨湰鏁版嵁鐨勫瓧孌墊暟鎹箣闂寸敤tab閿殧寮銆?/p>
use test;
load data local infile "鏂囦歡鍚? into table 琛ㄥ悕;
1:浣跨敤SHOW璇彞鎵懼嚭鍦ㄦ湇鍔″櫒涓婂綋鍓嶅瓨鍦ㄤ粈涔堟暟鎹簱錛?/p>
mysql> SHOW DATABASES;
2:2銆佸垱寤轟竴涓暟鎹簱MYSQLDATA
mysql> CREATE DATABASE MYSQLDATA;
3:閫夋嫨浣犳墍鍒涘緩鐨勬暟鎹簱
mysql> USE MYSQLDATA; (鎸夊洖杞﹂敭鍑虹幇Database changed 鏃惰鏄庢搷浣滄垚鍔?)
4:鏌ョ湅鐜板湪鐨勬暟鎹簱涓瓨鍦ㄤ粈涔堣〃
mysql> SHOW TABLES;
5:鍒涘緩涓涓暟鎹簱琛?/p>
mysql> CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));
6:鏄劇ず琛ㄧ殑緇撴瀯錛?/p>
mysql> DESCRIBE MYTABLE;
7:寰琛ㄤ腑鍔犲叆璁板綍
mysql> insert into MYTABLE values ("hyq","M");
8:鐢ㄦ枃鏈柟寮忓皢鏁版嵁瑁呭叆鏁版嵁搴撹〃涓?渚嬪D:/mysql.txt)
mysql> LOAD DATA LOCAL INFILE "D:/mysql.txt" INTO TABLE MYTABLE;
9:瀵煎叆.sql鏂囦歡鍛戒護(渚嬪D:/mysql.sql)
mysql>use database;
mysql>source d:/mysql.sql;
10:鍒犻櫎琛?/p>
mysql>drop TABLE MYTABLE;
11:娓呯┖琛?/p>
mysql>delete from MYTABLE;
12:鏇存柊琛ㄤ腑鏁版嵁
mysql>update MYTABLE set sex="f" where name='hyq';
posted on 2006-01-10 16:21 happytian 闃呰(6) 璇勮(0) 緙栬緫 鏀惰棌 鏀惰棌鑷?65Key
13錛氬浠芥暟鎹簱
mysqldump -u root 搴撳悕>xxx.data
14錛氫緥2錛氳繛鎺ュ埌榪滅▼涓繪満涓婄殑MYSQL
鍋囪榪滅▼涓繪満鐨処P涓猴細110.110.110.110錛岀敤鎴峰悕涓簉oot,瀵嗙爜涓篴bcd123銆傚垯閿叆浠ヤ笅鍛戒護錛?/p>
mysql -h110.110.110.110 -uroot -pabcd123聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 // 榪滅▼鐧誨綍
(娉?u涓巖oot鍙互涓嶇敤鍔犵┖鏍鹼紝鍏跺畠涔熶竴鏍?
3銆侀鍑篗YSQL鍛戒護錛?exit (鍥炶濺)
5 6 M 0 1 M 1 2 M 1 3 S 1 M 1 2 S 3 3 1 M 1 2 0 0
Case #1: 3 Case #2: 2