linuxç³»ç»è¿å
¥mysqlæ°æ®åºçæ¹æ³ï¼
è¿æ¥MYSQLï¼
æ ¼å¼ï¼ mysql -h主æºå°å -uç¨æ·å ï¼pç¨æ·å¯ç
1ãè¿æ¥å°æ¬æºä¸çMYSQLã
é¦å
å¨æå¼DOSçªå£ï¼ç¶åè¿å
¥ç®å½ mysqlbinï¼åé®å
¥å½ä»¤mysql -uroot -pï¼å车åæç¤ºä½ è¾å¯ç ï¼å¦æåå®è£
好MYSQLï¼è¶
级ç¨æ·rootæ¯æ²¡æå¯ç çï¼æ
ç´æ¥å车å³å¯è¿å
¥å°MYSQLä¸äºï¼MYSQLçæ示符æ¯ï¼mysql>
2ãè¿æ¥å°è¿ç¨ä¸»æºä¸çMYSQLãå设è¿ç¨ä¸»æºçIP为ï¼110.110.110.110ï¼ç¨æ·å为root,å¯ç 为abcd123ãåé®å
¥ä»¥ä¸å½ä»¤ï¼
mysql -h110.110.110.110 -uroot -pabcd123ï¼æ³¨:uä¸rootå¯ä»¥ä¸ç¨å ç©ºæ ¼ï¼å
¶å®ä¹ä¸æ ·ï¼
3ãéåºMYSQLå½ä»¤ï¼ exit ï¼å车ï¼
ä¸ä¸ªå»ºåºå建表以åæå
¥æ°æ®çå®ä¾ï¼
create database school; //建ç«åºSCHOOL
use school; //æå¼åºSCHOOL
create table teacher //建ç«è¡¨TEACHER
(
id int(3) auto_increment not null primary key, //id设置为主å
³é®åï¼å¹¶èªå¨è®¾å¼ï¼ä¹å°±æ¯æ·»å çæ¶åï¼ä½ ä¸å¿
åIDå段åå
容
name char(10) not null,
address varchar(50) default 'æ·±å³', //设置é»å¼ä¸ºæ·±å³
year date
); //建表ç»æ
//以ä¸ä¸ºæå
¥å段
insert into teacher values('','glchengang','建平ä¸ä¸','1976-10-10'); //IDä¸ç¨åå
容
insert into teacher values('','jack','建平ä¸ä¸','1975-12-23');
温馨提示:答案为网友推荐,仅供参考