1.寮€鍚疢ySQL鏈嶅姟
聽 聽 聽/etc/init.d/mysqld start
service mysqld start
systemctl 聽start mysqld聽
2.妫€娴嬬鍙ｆ槸鍚﹁繍琛?
聽 聽 聽lsof -i :3306
netstat -lntup |grep 3306
聽
3.涓篗ySQL璁劇疆瀵嗙爜鎴栬€呬慨鏀瑰瘑鐮?
璁劇疆瀵嗙爜
聽 聽 聽mysql -uroot -ppassword -e "set passowrd for root = passowrd('passowrd')"
mysqladmin -uroot passowrd "NEWPASSWORD"
鏇存敼瀵嗙爜
聽 聽 聽mysqladmin -uroot passowrd oldpassowrd "NEWPASSWORD"
聽 聽 聽use mysql;
聽 聽 聽update user set passowrd = PASSWORD('newpassword') where user = 'root';flush privileges;
聽 聽 聽msyql 5.7浠ヤ笂鐗堟湰淇敼榛樿瀵嗙爜鍛戒護 聽
alter user 'root'@'localhost' identified by 'root'聽聽
4.鐧婚檰MySQL鏁版嵁搴撱€?
聽 聽 聽mysql -uroot -ppassword聽
5.鏌ョ湅褰撳墠鏁版嵁搴撶殑瀛楃闆?
聽 聽 聽show create database DB_NAME;
聽
6.鏌ョ湅褰撳墠鏁版嵁搴撶増鏈?
聽 聽 聽mysql -V
聽 聽 聽mysql -uroot -ppassowrd -e "use mysql;select version();"
聽
7.鏌ョ湅褰撳墠鐧誨綍鐨勭敤鎴楓€?
聽 聽 聽select user();
聽
8.鍒涘緩GBK瀛楃闆嗙殑鏁版嵁搴搈ingongge锛屽苟鏌ョ湅宸插緩搴撳畬鏁磋鍙?
聽 聽 聽create database mingongge DEFAULT CHARSET GBK COLLATE gbk_chinese_ci;
聽
9.鍒涘緩鐢ㄦ埛mingongge锛屼嬌涔嬪彲浠ョ鐞嗘暟鎹簱mingongge
聽 聽 聽grant all on mingongge.* to 'mingongge'@'localhost' identified by 'mingongge';
聽
10.鏌ョ湅鍒涘緩鐨勭敤鎴穖ingongge鎷ユ湁鍝簺鏉冮檺
聽 聽 聽show grants for [email聽protected]
聽
11.鏌ョ湅褰撳墠鏁版嵁搴撻噷鏈夊摢浜涚敤鎴?
聽 聽 聽select user from mysql.user;
聽
12.杩涘叆mingongge鏁版嵁搴?
聽 聽 聽use mingongge
聽
13.鍒涘緩涓€innodb GBK琛╰est锛屽瓧娈礽d int(4)鍜宯ame varchar(16)
聽 聽 聽create table test (
id int(4),
name varchar(16)
)ENGINE=innodb DEFAULT CHARSET=gbk;
聽
14.鏌ョ湅寤鴻〃缁撴瀯鍙婅〃缁撴瀯鐨凷QL璇彞
聽 聽 聽desc test;
show create table test\G
聽
15.鎻掑叆涓€鏉℃暟鎹€?,mingongge鈥?
聽 聽 聽insert into test values('1','mingongge');
聽
16.鍐嶆壒閲忔彃鍏?琛屾暟鎹?鈥?,姘戝伐鍝モ€濓紝鈥?,mingonggeedu鈥?
聽 聽 聽insert into test values('2','姘戝伐鍝?),('3','mingonggeedu');
聽
17.鏌ヨ鍚嶅瓧涓簃ingongge鐨勮褰?
聽 聽 select * from test where name = 'mingongge';
18.鎶婃暟鎹甶d绛変簬1鐨勫悕瀛梞ingongge鏇存敼涓簃gg
聽 聽 update test set name = 'mgg' where id = '1';
19.鍦ㄥ瓧娈祅ame鍓嶆彃鍏ge瀛楁锛岀被鍨媡inyint(2)
聽 聽 alter table test add age tinyint(2) after id;
20.涓嶉€€鍑烘暟鎹簱,瀹屾垚澶囦喚mingongge鏁版嵁搴?
聽 聽 聽system mysqldump -uroot -pMgg123.0. -B mingongge >/root/mingongge_bak.sql
聽鏇翠粠绮懼僵鍐呭 璇鋒寔缁叧娉ㄦ湰鍗氬鎴栨壂鐮佸叧娉ㄦ皯宸ュ摜涓漢鍏紬鍙?
杞澆浜?https://blog.51cto.com/mingongge/1961093