鏍囩锛?
mysql瀹夎瀹屼箣鍚庯紝鐧婚檰鍚庡彂鐜板彧鏈変袱涓暟鎹簱锛歮ysql> show databases;
+--------------------+
| Database聽 聽聽 聽聽 聽聽聽|
+--------------------+
| information_schema |
| test聽 聽聽 聽聽 聽聽 聽聽 聽|
+--------------------+
锛宮ysql> use mysql
ERROR 1044 (42000): Access denied for user 鈥樷€楡鈥榣ocalhost鈥?to database 鈥榤ysql鈥?
璁块棶琚嫆缁濓紝鍘熷洜灏辨槸鍦ㄥ垹闄ゆ暟鎹簱鏃?rpm -e mysql*)娌℃湁鍒犻櫎骞插噣锛岄渶瑕佹妸/var/lib/mysql鐨勭洰褰曞叏閮ㄥ垹闄ゅ共鍑€锛岀劧鍚庡啀閲嶆柊瀹夎鍗冲彲銆?
椤轰究璁颁竴涓嬩竴浜涘父鐢ㄧ殑鍛戒护锛?
涓€銆佽繛鎺YSQL銆傛牸寮忥細 mysql -h涓绘満鍦板潃 -u鐢ㄦ埛鍚?锛峱鐢ㄦ埛瀵嗙爜
1銆佽繛鎺ュ埌鏈満涓婄殑MYSQL銆?
# mysql -u root -p
鍥炶溅鍚庢彁绀轰綘杈撳瘑鐮侊紝娉ㄦ剰鐢ㄦ埛鍚嶅墠鍙互鏈夌┖鏍间篃鍙互娌℃湁绌烘牸锛屼絾鏄瘑鐮佸墠蹇呴』娌℃湁绌烘牸锛屽惁鍒欒浣犻噸鏂拌緭鍏ュ瘑鐮併€?
濡傛灉鍒氬畨瑁呭ソMYSQL锛岃秴绾х敤鎴穜oot鏄病鏈夊瘑鐮佺殑锛屾晠鐩存帴鍥炶溅鍗冲彲杩涘叆鍒癕YSQL涓簡锛孧YSQL鐨勬彁绀虹鏄細 mysql>
2銆佽繛鎺ュ埌杩滅▼涓绘満涓婄殑MYSQL銆傚亣璁捐繙绋嬩富鏈虹殑IP涓猴細192.168.2.2锛岀敤鎴峰悕涓簉oot锛屽瘑鐮佷负123456銆傚垯閿叆浠ヤ笅鍛戒护锛?
# mysql -h192.168.2.2 -uroot -p123456
3銆侀€€鍑篗YSQL鍛戒护锛?
# exit (鍥炶溅)
浜屻€佷慨鏀瑰瘑鐮併€?
鏍煎紡锛歮ysqladmin -u鐢ㄦ埛鍚?-p鏃у瘑鐮?password 鏂板瘑鐮?
1銆佺粰root鍔犱釜瀵嗙爜123456銆傞敭鍏ヤ互涓嬪懡浠わ細
# mysqladmin -u root -password 123456
2銆佸啀灏唕oot鐨勫瘑鐮佹敼涓?6789銆?
# mysqladmin -u root -p123456 password 56789
涓夈€佸鍔犳柊鐢ㄦ埛銆傛牸寮忥細grant select on 鏁版嵁搴?* to 鐢ㄦ埛鍚岪鐧诲綍涓绘満 identified by 鈥滃瘑鐮佲€?
1銆佸鍔犱竴涓敤鎴穞est1瀵嗙爜涓篴bc锛岃浠栧彲浠ュ湪浠讳綍涓绘満涓婄櫥褰曪紝骞跺鎵€鏈夋暟鎹簱鏈夋煡璇€佹彃鍏ャ€佷慨鏀广€佸垹闄ょ殑鏉冮檺銆傞鍏堢敤root鐢ㄦ埛杩炲叆MYSQL锛岀劧鍚庨敭鍏ヤ互涓嬪懡浠わ細
mysql>grant select,insert,update,delete on *.* to test1@鈥?鈥?Identified by 鈥渁bc鈥?
mysql>flush privileges;聽聽聽聽浣夸箣鐢熸晥
2銆佸鍔犱竴涓敤鎴穞est2瀵嗙爜涓篴bc,璁╀粬鍙彲浠ュ湪localhost涓婄櫥褰曪紝骞跺彲浠ュ鏁版嵁搴搈ydb杩涜鏌ヨ銆佹彃鍏ャ€佷慨鏀广€佸垹闄ょ殑鎿嶄綔(localhost鎸囨湰鍦颁富鏈猴紝鍗矼YSQL鏁版嵁搴撴墍鍦ㄧ殑閭ｅ彴涓绘満)锛岃繖鏍风敤鎴峰嵆浣跨敤鐭ラ亾test2鐨勫瘑鐮侊紝浠栦篃鏃犳硶浠巌nternet涓婄洿鎺ヨ闂暟鎹簱锛屽彧鑳介€氳繃MYSQL涓绘満涓婄殑web椤垫潵璁块棶浜嗐€?
mysql>grant select,insert,update,delete on mydb.* to [email聽protected] identified by 鈥渁bc鈥?
mysql>flush privileges;聽聽聽聽浣夸箣鐢熸晥
濡傛灉浣犱笉鎯硉est2鏈夊瘑鐮侊紝鍙互鍐嶆墦涓€涓懡浠ゅ皢瀵嗙爜娑堟帀銆?
mysql>grant select,insert,update,delete on mydb.* to [email聽protected] identified by 鈥溾€?
mysql>flush privileges;聽聽聽聽浣夸箣鐢熸晥
鎿嶄綔鎶€宸?
1銆佸鏋滀綘鎵撳懡浠ゆ椂锛屽洖杞﹀悗鍙戠幇蹇樿鍔犲垎鍙凤紝浣犳棤椤婚噸鎵撲竴閬嶅懡浠わ紝鍙鎵撲釜鍒嗗彿鍥炶溅灏卞彲浠ヤ簡銆備篃灏辨槸璇翠綘鍙互鎶婁竴涓畬鏁寸殑鍛戒护鍒嗘垚鍑犺鏉ユ墦锛屽畬鍚庣敤鍒嗗彿浣滅粨鏉熸爣蹇楀氨OK銆?
2銆佷綘鍙互浣跨敤鍏夋爣涓婁笅閿皟鍑轰互鍓嶇殑鍛戒护銆?
鏌ヨ銆佸垱寤恒€佸垹闄ゃ€佹洿鏂板懡浠?
1銆佹樉绀哄綋鍓嶆暟鎹簱鏈嶅姟鍣ㄤ腑鐨勬暟鎹簱鍒楄〃锛?
mysql>show databases;
娉ㄦ剰锛歮ysql搴撻噷闈㈡湁MYSQL鐨勭郴缁熶俊鎭紝鎴戜滑鏀瑰瘑鐮佸拰鏂板鐢ㄦ埛锛屽疄闄呬笂灏辨槸鐢ㄨ繖涓簱杩涜鎿嶄綔銆?
2銆佹樉绀烘暟鎹簱涓殑鏁版嵁琛細
mysql>use 搴撳悕锛?
mysql>show tables;
3銆佹樉绀烘暟鎹〃鐨勭粨鏋勶細
mysql>describe 琛ㄥ悕;
4銆佸缓绔嬫暟鎹簱锛?
mysql>create database 搴撳悕;
5銆佸缓绔嬫暟鎹〃锛?
mysql>use 搴撳悕;
mysql>create table 琛ㄥ悕 (瀛楁鍚?varchar(20), 瀛楁鍚?char(1));
6銆佸垹闄ゆ暟鎹簱锛?
mysql>drop database 搴撳悕;
7銆佸垹闄ゆ暟鎹〃锛?
mysql>drop table 琛ㄥ悕;
8銆佸皢琛ㄤ腑璁板綍娓呯┖锛?
mysql>delete from 琛ㄥ悕;
9銆佹樉绀鸿〃涓殑璁板綍锛?
mysql>select * from 琛ㄥ悕;
10銆佸線琛ㄤ腑鎻掑叆璁板綍锛?
mysql>insert into 琛ㄥ悕 values (鈥?23鈥?鈥漛鈥?;
11銆佹洿鏂拌〃涓暟鎹細
mysql>update 琛ㄥ悕 set 瀛楁鍚?=鈥榓鈥?瀛楁鍚?=鈥榖鈥?where 瀛楁鍚?=鈥榗鈥?
12銆佺敤鏂囨湰鏂瑰紡灏嗘暟鎹鍏ユ暟鎹〃涓細
mysql>load data local infile 鈥?root/mysql.txt鈥?into table 琛ㄥ悕;
13銆佸鍏?sql鏂囦欢鍛戒护锛?
mysql>use 鏁版嵁搴撳悕;
mysql>source /root/mysql.sql;
14銆佸懡浠よ淇敼root瀵嗙爜锛?
mysql>update mysql.user set password=PASSWORD(鈥樻柊瀵嗙爜鈥? where user=鈥榬oot鈥?
mysql>flush privileges;
15銆佹樉绀簎se鐨勬暟鎹簱鍚嶏細
mysql>select database();
16銆佹樉绀哄綋鍓嶇殑user锛?
mysql>select user();
澶囦唤鏁版嵁搴?
1.瀵煎嚭鏁翠釜鏁版嵁搴擄紝瀵煎嚭鏂囦欢榛樿鏄瓨鍦ㄥ綋鍓嶆搷浣滅洰褰曚笅
# mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 > 瀵煎嚭鐨勬枃浠跺悕
# mysqldump -u user_name -p123456 database_name > outfile_name.sql
2.瀵煎嚭涓€涓〃
# mysqldump -u 鐢ㄦ埛鍚?-p 鏁版嵁搴撳悕 琛ㄥ悕> 瀵煎嚭鐨勬枃浠跺悕
# mysqldump -u user_name -p database_name table_name > outfile_name.sql
3.瀵煎嚭涓€涓暟鎹簱缁撴瀯
# mysqldump -u user_name -p -d 鈥揳dd-drop-table database_name > outfile_name.sql
-d 娌℃湁鏁版嵁 鈥揳dd-drop-table 鍦ㄦ瘡涓猚reate璇彞涔嬪墠澧炲姞涓€涓猟rop table
4.甯﹁瑷€鍙傛暟瀵煎嚭
# mysqldump -uroot -p 鈥揹efault-character-set=latin1 鈥搒et-charset=gbk 鈥搒kip-opt database_name > outfile_name.sql
鏍囩锛?